CDAP ODBC Drivers enable integration with Windows-based applications that support an ODBC interface, allowing access to CDAP Datasets. CDAP provides ODBC drivers that support both 32-bit and 64-bit Windows operating systems.
ODBC Driver | Version | CDAP Versions |
---|---|---|
Windows 32-bit driver | 1.0.0.1 | CDAP 3.4 and higher |
Windows 64-bit driver | 1.0.0.1 | CDAP 3.4 and higher |
The ODBC drivers can be downloaded from these locations:
After downloading the appropriate msi installer for your operating system and starting it, follow the prompts to install the driver:
System restart will be required after the installation is successful for the drivers to load:
Once the driver is installed, data sources with either CDAP Datasets 32-bit or CDAP Datasets 64-bit will be created.
CDAP Datasets can be accessed via the Microsoft Query Wizard in Microsoft Excel. To access the datasets in a given namespace and to run queries against them, follow these steps:
From the Data Tab of Microsoft Excel, click Get External Data > From Other Sources > From Microsoft Query:
In the next dialog box, enter the CDAP router hostname, port, auth token, and the CDAP namespace.
Note: Auth token is required if perimeter security is enabled. Otherwise, auth token is optional.
Click on Options and ensure the Tables is checked:
A list of CDAP datasets appears in the next dialog. Choose the tables to be queried:
Choose either the columns to be fetched or to run a SQL query to fetch the data:
Interactive data analytics can be performed on CDAP Datasets using Tableau software by accessing the data with the CDAP ODBC driver. To use ODBC drivers on Tableau, follow these steps:
Choose the Other Databases (ODBC) option as the method to connect to the CDAP server:
Choose the correct version of the ODBC driver in the DSN radio button:
Provide CDAP router host, port, auth token, and the CDAP namespace.
Note: Auth token is required if perimeter security is enabled. Otherwise, auth token is optional.
Look for the CDAP datasets using the Search option provided by Tableau:
Choose the desired table and column and click the Update Now button to see the data for a particular dataset: