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
Install ODBC Driver
Install the Treasure Data 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.
QlikView
Establish ODBC Connection
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.
Qlik Sense
Establish ODBC Connection
Launch Qlik Sense, go to Add data from files and other sources.
Select ODBC icon, and select System DSN and choose Treasure Data 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.