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

Prerequisites

  • 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 Edit Script.



Select Data tab, and select ODBC and click Connect.



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 Select.



Please select Database and 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 Add.



Please go to the previous screen, and edit after FROM clause. By default QlikView populates Database.Owner.Table, but please change to Database.Table.





Finally, please click Reload icon. Then the data will get populated.


Last modified: Oct 15 2014 18:58:30 UTC

If this article is incorrect or outdated, or omits critical information, please let us know. For all other issues, please see our support channels.