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 Data Warehouse service as DWAdmin.
  2. Go to the Resource and Downloads tile and click See More.
  3. Click Download JDBC Jar or Download JDBC/ODBC Driver, depending on your Virtual Warehouse SQL engine type.
    This action downloads the JAR (driver) file to your local system.
  4. 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.
  5. Go to the Virtual Warehouses tab, locate the Virtual Warehouse you to connect the JDBC client to, and click > Copy JDBC URL.
  6. Paste the copied JDBC URL into a text file. The URL is in the following format:
    jdbc:hive2://<your-virtual-warehouse>.<your-environment>.<your-domain.com>/default;transportMode=http;httpPath=cliservice;ssl=true;retries=3
  7. Provide the Unified Analytics JDBC URL to your client.
    <your-virtual-warehouse>.<your-environment>.<domain.company.com>
  8. 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.