Birst with Treasure Data

Birst provides an easy-to-use cloud-based enterprise BI service. By combining Birst and Treasure Data, users can quickly explore both operational data and big data.

Table of Contents

Prerequisites

  • Birst account
  • Basic knowledge of Treaure Data and a Treasure Data account

Step 1: Download BirstConnect Artifacts

First, visit the Navigation Page under Manage Space, and select Use Birst Connect.

Then, download your .jnlp file by clicking Launch for one of your configurations. Next, download your BirstConnect.zip too.



Finally, let’s put two files under the same directory. In this article, we’ll reference the directory as $BIRST_CONNECT_DIRECTORY. We need to unzip BirstConnect.zip.

$ cd $BIRST_CONNECT_HOME
$ tar -zxvf BirstConnect.zip

Step 2: Download Treasure Data JDBC Driver

Please download Treasure Data’s JDBC driver from here, and put the file to $BIRST_CONNECT_HOME/dist/lib.

$ cd $BIRST_CONNECT_HOME
$ mv /PATH/TO/td-jdbc-xxx-jar-with-dependencies.jar dist/lib/

Step 3: Launch Birst Connect

Next, let’s launch Birst Connect. Please specify .jnlp file you’ve donwloaded to the dnlp.file parameter.

$ java -Djnlp.file=/PATH/TO/xxx.jnlp -Xmx1024m -cp "dist/*:dist/lib/*" com.birst.dataconductor.DataConductorApp

Step 4: Set up Task

Now you have successfully launched Birst Connect, with Treasure Data JDBC driver built in. Please click Add Task to set up the task to extract data from Treasure Data into Birst.



Once launched, you’ll specify ‘Task Name’ first. Then, click the Sources tab and Add Query.



You’ll see the fields to specify JDBC connection. Fill the information accordingly.



  • Database Type: Generic JDBC Connection
  • Driver Name: com.treasuredata.jdbc.TreasureDataDriver
  • Connection String: jdbc:td://api.treasuredata.com/testdb;useSSL=true
  • Username: YOUR_TREASURE_DATA_EMAIL_ADDRESS
  • Password: YOUR_TREASURE_DATA_PASSWORD
  • Query: Your Query
Untitled-3
You can switch query engines by using type parameter like jdbc:td://api.treasuredata.com/testdb;useSSL=true;type=presto. Please refer Treasure Data JDBC Driver documentation for more information.

Finally click Update, and Save to save the task.

Step 5: Run the Task

Please go back to Birst Connect main dialog and click Run Tasks Now. The query will be executed on Treasure Data, and your data will be inserted into Birst.


Last modified: Jul 07 2016 19:00:56 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.