Connecting a JDBC client
You see how to establish the connection between your JDBC client and Unified Analytics.
- Log in to the CDP web interface and navigate to the Data Warehouse service.
- Click .
- Click on the Virtual Warehouse tile.
Click Download JDBC Jar or Download JDBC/ODBC
Driver, depending on your Virtual Warehouse SQL engine
This action downloads the JAR (driver) file to your local system.
- Provide the JAR file you downloaded to your JDBC client. For most of the clients, the JAR file should be added under the Libraries folder. Refer to your client documentation for information about the correct location.
- Click the options again.
- Click Copy JDBC URL.
Paste the copied JDBC URL into a text file. It looks something like this:
Provide the JDBC URL to your client.
On the JDBC client end, check that the user can set the authentication
Authentication: Username and PasswordUsername: Username you use to connect to the CDP Data Warehouse service.Password: Password you use to connect to the CDP Data Warehouse service.