Downloading a JDBC driver from Cloudera Data Warehouse
To use third-party BI tools, your client users need a JDBC JAR to connect your BI tool and the service. You learn how to download the JDBC JAR to give to your client, and general instructions about how to use the JDBC JAR.
- You created a Database Catalog.
You have the option to populate your Database Catalog with sample data when you create it.
- You created a Virtual Warehouse and configured it to connect to the Database Catalog.
- Log in to the CDP web interface and navigate to the Data Warehouse service.
- In the Data Warehouse service, click Virtual Warehouses in the left navigation panel.
Select a Hive Virtual Warehouse, click options for the warehouse you want to connect to your BI tool, and
select Download JDBC Jar to download the Apache Hive JDBC
Provide the JAR file you downloaded to your JDBC client.
On most clients, add the JAR file under the Libraries folder. Refer to your client documentation for information on the location to add the JAR file.
In the Data Warehouse service Overview page, for the Virtual
Warehouse you want to connect to the client, in options, click Copy JDBC
A URL is copied to your system clipboard in the following format:
Paste the URL into a text editor and configure your client BI tool to connect to the
Virtual Warehouse using the following portion of the URL, represents the server name of
the Virtual Warehouse:
In your JDBC client, set the following other options:
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.