Cloudera Docs

Connecting a JDBC client

You see how to establish the connection between your JDBC client and Unified Analytics.

In this task, you connect to a Unified Analytics Virtual Warehouse. First, you download the JDBC driver to give to your client. Next, you obtain the Unified Analytics endpoint for the connection. Finally, you provide necessary information to your client.
  1. Log in to the CDP web interface and navigate to the Data Warehouse service.
  2. Click Data Warehouse > Overview.
  3. Click on the Virtual Warehouse tile.
  4. Click Download JDBC Jar or Download Unified Analytics JDBC Driver, depending on your Virtual Warehouse SQL engine type.
    This action downloads the JAR (driver) file to your local system.
  5. 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.
  6. Click the options again.
  7. Click Copy JDBC URL.
  8. Paste the copied JDBC URL into a text file. It looks something like this: 
    jdbc:hive2://<your-virtual-warehouse>.<your-environment>.<your-domain.com>/default;transportMode=http;httpPath=cliservice;ssl=true;retries=3
  9. Provide the Unified Analytics JDBC URL to your client. 
    <your-virtual-warehouse>.<your-environment>.<domain.company.com>
  10. On the JDBC client end, check that the user can set the authentication credentials:
    Authentication: Username and Password
    Username: Username you use to connect to the CDP Data Warehouse service.
    Password: Password you use to connect to the CDP Data Warehouse service.