Strategy ONE

Connect to a JDBC Driver

You can also use Universal Semantic Layer to connect to a database that uses a JDBC driver.

Prerequisite

Cognitive search index must be enabled. For more information, see Cognitive Search.

Connect to a JDBC Driver Example

If your data tool has JDBC Trino/Presto connectivity, you can use Universal Semantic Layer to connect your data. See the following example using DBeaver:

  1. In the Library Navigation pane, click Data.

  2. Find your data model and click Additional Information.

  3. Copy the JDBC connection string depending on your authentication method:

    • Standard authentication and LDAP: Click Copy next to JDBC URL.

      For more information on authentication configurations, see LDAP Authentication

    • Token based authentication: Click Copy next to JDBC URL, Extra Credentials, and Access Token.

      For more information on authentication configurations, see OAuth 2

  4. Open DBeaver.

  5. In the left navigation pane, right-click and choose Create > Connection.

  6. Find and choose Trino.

  7. Click Next.

  8. If you are using standard/LDAP authentication, enter your environment information in the following fields in Main:

    • Connect by: Select URL.

    • JDBC URL: Paste the value you copied above.

    • Username and Password: Type your credentials.

  9. If you are using token based authentication, enter your environment information in the following fields:

    • In Main:

      • Connect by: Select URL.

      • JDBC URL: Paste the value you copied above.

    • In Driver properties, paste the values you copied above in accessToken and extraCredentials.

      For more information on authentication configurations, see OAuth 2

  10. Click OK.

  11. Proceed to use your Strategy data in DBeaver.