QlikView with Treasure Data
Using QlikView with Treasure Data allows users to interactively explore huge amounts of data, and also share the knowledge across multiple people.
Table of Contents
- Windows 7, 8.1, or later
- QlikView v11
Install ODBC Driver
Please install Treasure Data ODBC Driver, and register to your machine. We’ll assume you have DSN (Data Source Name) as
Treasure Data in the following sections.
Establish ODBC Connection
Please launch QlikView, goto
File and select
Data tab, and select
ODBC and click
First, please fill in
User ID and
Password, then please check
Show User DNSs, and select appropriate
Data Source you have setted up. Please click
OK, and make sure it shows
Connection Test Succeeded.
- User ID: YOUR_EMAIL_ADDRESS
- Password: YOUR_PASSWORD
Please go to the previous screen, and check if ODBC connection string exists in the script. Also please check
Force 32 Bit checkbox, and lick
Owner, and choose the name of database on Treasure Data. Please make sure to select the same names for both Database and Owner. Then, please select the name of table you want to load. Finally, please select
Preceding Load and click
Please go to the previous screen, and edit after
FROM clause. By default QlikView populates
Table, but please change to
Finally, please click
Reload icon. Then the data will get populated.
Last modified: Oct 15 2014 18:58:30 UTC