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.
- 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 the Qlik provided ODBC driver, and register it to your machine. We’ll assume you have DSN (Data Source Name) as Treasure Data Presto in the following sections.
Launch QlikView, goto File and select Edit Script.
Select Data tab, select ODBC and click Connect.
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.
Click the Reload icon. The data gets populated.
Launch Qlik Sense, go to Add data from files and other sources.
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
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.
Choose columns in the Fields icon. The data gets populated.
