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. Select Add, and then select Simba Trino ODBC Driver.
  9. Select 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. Select 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. Select OK.
  12. Provide the following information:
    Service Name
    Enter Trino.
    Data Source Host
    Enter the Big Data Service 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, select SSL Options.
  14. To test the connection, select Test.
  15. To save the setup, select OK.
  16. In the Catalog field, select Hive.
  17. In the Schema field, select the database you want to connect to. For example, default.