# Birst With The Treasure Data JDBC Driver

Treasure Data JDBC Driver is deprecated.

[Birst](http://www.birst.com/) 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.

# Prerequisites

- Birst account
- Basic knowledge of Treasure Data and a Treasure Data account


# Download BirstConnect Artifacts

Visit the `Navigation Page` under `Manage Space`, and select `Use Birst Connect`.

![](/assets/image-20191015-213140.ab5431144a46e3b87e1a7bd790d755f0668dd8030a1853d4df49982ec435e862.7b8998b7.png)

Download your .jnlp file by selecting `Launch` for one of your configurations. Also, download your `BirstConnect.zip` file.

![](/assets/image-20191015-213153.2a588c630117db7ee18bf61e2a3e231d123038c58b8ae30a48c4f998722432be.7b8998b7.png)

Put two files under the same directory. In this article, we’ll reference the directory as `$BIRST_CONNECT_DIRECTORY`. Unzip `BirstConnect.zip`.


```bash
cd $BIRST_CONNECT_HOME
tar -zxvf BirstConnect.zip
```

# Download Treasure Data JDBC Driver

Download [Treasure Data’s JDBC driver](https://docs.treasuredata.com/articles/project-product-documentation/jdbc-driver-for-hive-query-engine) from here, and put the file to `$BIRST_CONNECT_HOME/dist/lib`.


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

# Launch Birst Connect

Launch Birst Connect. Specify the `.jnlp` file you’ve downloaded to the `dnlp.file` parameter.


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

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

![](/assets/image-20191015-213259.0755c08fbe8e382962cd6753f1e4eeb7d13e697991da8fffe7f0d80d1b05807b.7b8998b7.png)

1. After launching, specify ‘Task Name’ first.


![](/assets/image-20191015-213308.55b7a5bf56ebef599d9755c1bdf2694722f3d88ae52f53e146f1e11763a7e39e.7b8998b7.png)
2. Go to the Sources tab and select **Add Query**.

Edit the fields to specify JDBC connection, accordingly.

![](/assets/image-20191015-213316.8da37952f86c3fe89071b05b99081e2b1b91a8499962eff3efe2e2743ebc7af2.7b8998b7.png)

- 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


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](https://docs.treasuredata.com/articles/project-product-documentation/jdbc-driver-for-hive-query-engine) 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.