This article explains how to use Treasure Data with IBM SPSS Modeler using Presto ODBC driver. By combining Treasure Data with IBM SPSS Modeler, you can have integration to Treasure Data Database.
Download IBM SPSS Modeler
Download IBM SPSS Modeler from the following link. IBM SPSS Modeler Subscription Version 1.0 was tested for this article. After you installed IBM SPSS Modeler, the screen looks like the following
Download Presto ODBC Driver
Download TreasureDataPrestoODBC.msi from the following link. Note that this driver works with Windows machine only.
Configure Presto ODBC Driver
After you install the ODBC Driver, open ‘ODBC Data Source Administrator (64-bit)’. Now you see the window screen like the following.
Choose 'Treasure Data Presto ODBC DSN' and select Configure.
Now you should see the screen similar to the following image:
Configure the setting as follows. Select Test. If successful, select OK.
Authentication Type: No Authentication
User: Leave blank
Configure IBM SPSS Modelar Database
While still within IBM SPSS Modeler, you configure the connection.
Database Connections Setting
Now you have to configure Database on IBM SPSS Modelar side. Go to Tools > Databases. Now you see a configuration screen which looks like the following.
For Data Source, choose 'Treasure Data Presto ODBC DSN'. Then provide your API key into User name column. Make sure to use TD master API key, otherwise, it causes an error when running queries.
Now you have the connection to Treasure Data throughout the ODBC source set in the previous step. Select to add a new Database, and choose Data source as '[your api key]@treasure Data Presto ODBC DSN' as follows:
Querying the Connected Database
You are ready to query the database. Note that you can specify the table as follows.
If the preview is as you expect, then querying the database is successfully done.