Oracle Cloud Infrastructure Documentation

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

  1. Access Apache Ambari.
  2. From the side toolbar, under Services select Trino.
  3. Select Summary.
  4. Make a note of the Trino Coordinator hostname.
  5. Connect to a Windows workstation and navigate to Program Files.
  6. Download the BI desktop tool, either Power BI or Tableau.
  7. Download the Simba Trino ODBC connector.
  8. To install, double-click the 64-bit Simba connector.
  9. Copy the obtained Simba ODBC license and paste it to C:\Program Files\Simba Trino ODBC Driver\lib with <LicenseFileName>.lic. Be sure to include the file extension.
  10. In Windows Search, search for and open ODBC Data Sources (64-bit).
  11. Select Add, and then select Simba Trino ODBC Driver.
  12. Select Finish.
  13. Enter Simba Trino ODBC Driver DSN Setup details listed here.
    Data Source Name
    Enter a name for the data source.
    Host
    Enter the Big Data Service Trino Coordinator hostname.

    Be sure the Trino Coordinator hostname resolves to its IP. If not, update the Windows host file at C:\Windows\System32\drivers\etc\hosts with the IP and hostname.

    Port
    Enter 8285 for unsecured.
    Catalog
    Select Hive.
    Schema
    Select the database you want to connect to. For example, default.
  14. To test the connection, select Test.
  15. To save the setup, select OK.