Downloading JDBC JAR and integrating third-party BI tools
To use third-party BI tools, such as Tableau with Cloudera Data Warehouse service, you must configure the connection between your BI tool and the service. These instructions configure a connection with Tableau, but you can use the same JDBC JAR file and URL to connect other BI tools.
Before you can use your BI tool with the Data Warehouse service, you must have created a Database Catalog that is populated with data. You have the option to populate your Database Catalog with sample data when you create it. You must also create a Virtual Warehouse and configure it to connect to the Database Catalog that is populated with data.
- 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 the options menu for the warehouse you want to
connect to your BI tool, and select Download JDBC Jar to download
the Apache Hive JDBC JAR and install it:
See the Tableau documentation for the location where you must place the JAR file.
- In Tableau, select . The Connect dialog box appears.
In the Connect dialog box, in the list of More... servers,
search for Cloudera Hadoop and launch the Cloudera Hadoop
In the Data Warehouse service Overview page, for the Virtual
Warehouse you want to connect to Tableau, in the options menu, click Copy JDBC
When you click this, it copies a URL on your system clipboard similar to the below URL:
Paste the URL into a text editor and copy the following section into the
Server field of the Tableau Cloudera Hadoop dialog box:
Then in the Tableau Cloudera Hadoop dialog box, set the following other options:
- Port: 443
- Type: HiveServer2
- Authentication: Username and Password
- Transport: HTTP
- Username: Username you use to connect to the CDP Data Warehouse service
- Password: Password you use to connect to the CDP Data Warehouse service
- HTTP Path: cliservice
- Require SSL: is checked
- Click Sign In.