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 .
- In Virtual Warehouses, click options in an Impala Virtual Warehouse tile.
Click Download Unified Analytics JDBC Driver.
This action downloads the JAR 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 Unified Analytics JDBC URL.
Paste the copied JDBC URL into a text file. It looks something like this:
Provide the Unified Analytics 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.