Drivers

You can connect to tQL remotely using the standard drivers.

JDBC Driver

Download the latest OpenSearch JDBC Driver and use it with your favorite tool:

• Connect string: jdbc:opensearch://https://tsm.datalite.cloud/ts
• m-ticket/api/opensearch
• Authentication: use an existing tSM User with “System.Tql.Remote” privilege

ODBC Driver

Download the latest OpenSearch ODBC Driver and configure Windows ODBC DataSource using the OpenSearch manual.

• Host: https://tsm.datalite.cloud/tsm-ticket/api/opensearch
• Authentication: BASIC, use an existing tSM User with “System.Tql.Remote” privilege
• Advanced options -> Enable SSL (for https servers)

Additional connectors for ODBC

Using ODBC driver, you can connect:

• Power BI Desktop: OpenSearch.mez
• Tableau: opensearch_sql_odbc.taco

For more details consult https://github.com/opensearch-project/sql/tree/main/sql-odbc.

• Using ODBC driver for powerBI with ODBC connect, will be configured:
• Click on Home > Get Data > More > Other. Select ODBC. Click on Connect.
• Then choose your ODBC DSN and write a query for index data in the advanced options:
• Click ok
• Data preview will be loaded.