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:
-
In the Library Navigation pane, click Data.
-
Find your data model and click Additional Information
.
-
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
-
-
Open DBeaver.
-
In the left navigation pane, right-click and choose Create > Connection.
-
Find and choose Trino.
-
Click Next.
-
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.
-
-
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
-
-
Click OK.
-
Proceed to use your Strategy data in DBeaver.