# Qlikview And Qlik Sense Export Integration

Using QlikView® and Qlik Sense® with Treasure Data allows users to interactively explore large amounts of data, and also share the knowledge across your organization.

## Prerequisites

- Windows 7, 8.1, or later
- QlikView v11 or later
- Qlik Sense Desktop v11 or later


June, 2025: TD packaged ODBC driver is no longer supported. Use Qlik provided ODBC Driver.

## Install ODBC Driver

Install the [Qlik provided ODBC driver](https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Install-ODBC-connector.htm), and register it to your machine. We’ll assume you have DSN (Data Source Name) as `Treasure Data Presto` in the following sections.

## QlikView

### Establish ODBC Connection

Launch QlikView, goto File and select Edit Script.

![](/assets/image-20191016-203629.17a15810a50e7b5fcb901103fc72df7c62680acbf16add088b2accb2081ba497.f199fcd4.png)

Select Data tab, select ODBC and click **Connect**.

![](/assets/image-20191016-203650.05cf8e7f0110249ed9588b659ab90d6d4b8c39139b75a936123004fa5b05aeff.f199fcd4.png)

Edit your Treasure Data API key in only User ID, then select appropriate Data Source you have set up. Click **OK**, and make sure it shows `Connection Test Succeeded`.

- User ID: YOUR_TD_APIKEY
- Password: blank


Go to the previous screen, and check if ODBC connection string exists in the script.

Select Database and Owner, and choose the name of the database on Treasure Data. Make sure to select the same names for both Database and Owner. Then, select the name of the table you want to load. Select Preceding Load and click **Add**.

![](/assets/image-20191016-203728.b888a580f2bd45b7edb6d7a13896134898b48f2afc3b7988c8adda52fd2caf16.f199fcd4.png)

Click the **Reload** icon. The data gets populated.

![](/assets/image-20191016-203745.90cc6cd4d2e6fdd786939debc50f9e5da4e050561748be08a068c2f2443308f7.f199fcd4.png)

## Qlik Sense

### Establish ODBC Connection

Launch Qlik Sense, go to Add data from files and other sources.

![](/assets/image-20191016-203802.fe48629790c1d25fef020a1900f5740a83fec16348ab85a19e6c0640fffa9637.f199fcd4.png)

Select ODBC icon, and select System DSN and choose Presto ODBC DSN.

Edit your TD API KEY in Username, and then click **Create**.

- Usename: YOUR_TD_APIKEY
- Password: blank


![](/assets/image-20191016-203829.34d4ea76eaafe76f672ebdb5271f34ef4f2984e968115a6a2559c83010b18052.f199fcd4.png)

Select Owner, and select the name of the table you want to load.

Click on column checkboxes you want to use, and click **Add data**.

![](/assets/image-20191016-203956.89953e7b454359b941928b3c3b2ac4a2fd56eee73b820db12362b0d72c67b70d.f199fcd4.png)

Choose columns in the Fields icon. The data gets populated.

![](/assets/image-20191016-204005.bac090c10cf5ae2a5a492820897b303368f43565c3fec76ba32273af4d12ac44.f199fcd4.png)

## Reference

- [https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Presto/Presto-connector.htm](https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Presto/Presto-connector.htm)