Oracle Cloud Infrastructure Documentation

Configuring the Client Machine ODBC Connector on Secure Big Data Service Cluster

Before starting this step, complete Configuring the Client Machine ODBC Connector on Unsecure Big Data Service Cluster first.
  1. Install MIT Kerberos Client on the Windows machine.
  2. Copy the contents of /etc/krb5.conf from a cluster node to the C:\ProgramData\MIT\Kerberos5\krb5.ini file.
  3. Collect Root CA certificate and the Trino Server certificate pem files, and then create a pem file to append both certificates.

    Example:

    C:\Users\opc\cloud.oracle.com.pem

  4. Create an MIT user principle and create its keytab.
  5. Copy the keytab to the a Windows directory.

    Example:

    C:\Users\opc\admin.user.keytab

  6. Be sure the Trino Coordinator's hostname .

    If not, update the Windows host file at C:\Windows\System32\drivers\etc\hosts with the IP and hostname.

  7. In Windows Search, search for and open ODBC Data Sources (64-bit).
  8. Click Add, and then select Simba Trino ODBC Driver.
  9. Click Finish.
  10. Enter Simba Trino ODBC Driver DSN Setup details.
    1. In the Data Source Name field, enter a name for the data source.
    2. Select Kerberos Authentication for the Authentication Type.
    3. Check Use GSSAPI.
    4. Click Kinit Options to enter the user principal information.
    5. Complete one of the following:
      • For Kinit with Keytab, enter the user principal information into the Kerberos Username and Keytab File Path fields.
      • For Kinit with Password, enter the user principal information into the Kerberos Username and Keytab Password fields.
  11. Click OK.
  12. Provide the following information:
    Service Name
    Enter Trino.
    Data Source Host
    Enter the BDS Trino Coordinator hostname.
    Port
    Enter 7778 for secure SSL enabled clusters.
  13. To configure SSL and provide certificate detail for the Trino certificate and its Root Certificate, click SSL Options.
  14. To test the connection, click Test.
  15. To save the setup, click OK.
  16. In the Catalog field, select Hive.
  17. In the Schema field, select the database you want to connect to. For example, default.