Configuring the Client Machine ODBC Connector on Unsecure Big Data Service Cluster
- Access Apache Ambari.
- From the side toolbar, under Services select Trino.
- Select Summary.
- Make a note of the Trino Coordinator hostname.
- Connect to a Windows workstation and navigate to Program Files.
- Download the BI desktop tool, either Power BI or Tableau.
- Download the Simba Trino ODBC connector.
- To install, double-click the 64-bit Simba connector.
-
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. - In Windows Search, search for and open ODBC Data Sources (64-bit).
- Select Add, and then select Simba Trino ODBC Driver.
- Select Finish.
-
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.
- To test the connection, select Test.
- To save the setup, select OK.