Birst provides an easy-to-use cloud-based enterprise business intelligence (BI) service. By combining Birst and Treasure Data, users can quickly explore both operational data and big data.
Continue to the following topics:
Basic knowledge of Treasure Data and a Treasure Data account
Download BirstConnect Artifacts
Navigation Page under
Manage Space, and select
Use Birst Connect.
Download your .jnlp file by selecting
Launch for one of your configurations. Also, download your
Put two files under the same directory. In this article, we’ll reference the directory as
Download Treasure Data JDBC Driver
Download Treasure Data’s JDBC driver from here, and put the file to
Launch Birst Connect
Launch Birst Connect. Specify the
.jnlp file you’ve downloaded to the
Set Up Task
After successfully launching Birst Connect, with the Treasure Data JDBC driver built-in.
Select Add Task to set up the task to extract data from Treasure Data into Birst.
After launching, specify ‘Task Name’ first.
Go to the Sources tab and select Add Query.
Edit the fields to specify JDBC connection, accordingly.
Database Type: Generic JDBC Connection
Driver Name: com.treasuredata.jdbc.TreasureDataDriver
Connection String: jdbc:td://api.treasuredata.com/testdb;useSSL=true
Query: Your Query
You can switch query engines by using type parameters like jdbc:td://api.treasuredata.com/testdb;useSSL=true;type=presto. See the Treasure Data JDBC Driver documentation for more information.
Select Update and Save to save the task.
Run the Task
Go back to the Birst Connect main dialog and select Run Tasks Now. The query is executed on Treasure Data, and your data is inserted into Birst.