# Pentaho Report Designer Export Integration

You can use Treasure Data with [Pentaho Business Analytics](http://www.pentaho.com/) using [our JDBC driver](https://docs.treasuredata.com/articles/project-integrations/pentaho-report-designer-export-integration#PentahoReportDesignerExportIntegration-DownloadourJDBCDriver). By combining Treasure Data with Pentaho, you can process huge volumes of data in the cloud, using existing Pentaho instances.

**Don't have time** to set up Pentaho and Treasure Data? Use our [Setup Consultation Service](https://docs.treasuredata.com/smart/project-product-documentation/consultation).

## Download Pentaho Report Designer

Download [Pentaho Report Designer](http://reporting.pentaho.com/). Version 3.9.0-GA was tested for this article.

![](/assets/image-20191016-202827.7a84fd2f6711f614362d808ea3b6215cfac9ffb276f65270963f33ca752f20bf.f9f2883c.png)

## Download our JDBC Driver

This driver works only with Treasure Data. It does not work with other environments such as your local Hadoop/Hive cluster.

Download td-jdbc-jar-with-dependencies-(version).jar from the following link.

- [Treasure Data JDBC Driver Download](https://docs.treasuredata.com/articles/project-integrations/pentaho-report-designer-export-integration#PentahoReportDesignerExportIntegration-DownloadourJDBCDriver)


If you want to know more about Treasure Data JDBC driver, see[https://github.com/treasure-data/td-jdbc](https://github.com/treasure-data/td-jdbc).

## Add Treasure Data as Data Source

### Add JDBC Driver to Pentaho

Let’s copy the Treasure Data JDBC driver to Pentaho’s JDBC directory. The command for the MacOS environment is as follows:


```
$ cp td-jdbc-jar-with-dependencies-(version).jar \
  /Applications/pentaho/design-tools/Pentaho\ Report\ Designer.app/lib/
```

## Create a New Data Source

Navigate to Data -> Add Data Source -> Advanced -> JDBC (Custom). Create a new data source, select the GREEN plus button.

![](/assets/image-20191016-202951.318a0520c3348ba77192fc8eb6fa6508624e20719e9e03c47775b34bb93ca5a0.f9f2883c.png)

## Configure JDBC Connection

Select Generic database -> Native (JDBC) and configure the JDBC connection as follows. Be sure to edit your credentials (your email + password).

![](/assets/image-20191016-203008.547177476a0a5ebd64ab1f5a69e21b80cdce3025ae9f954f000a32da80140157.f9f2883c.png)


```
Connection Type: Generic Database                                     
Custom Connection URL:  jdbc:td://api.treasuredata.com/(database name)
Custom Driver Class Name: com.treasuredata.jdbc.TreasureDataDriver
User Name: Your TreasureData Account
Password: Your TreasureData Password
```

API endpoint is up to your account site.

If your account site is in Tokyo, then the Custom Connection URL is "jdbc:td://**api.treasuredata.co.jp**/(database name)".

For details, see [Sites and Endpoints](https://api-docs.treasuredata.com/en/overview/aboutendpoints/).

## Create Reports

You can create reports using generic SQL queries. Open the window from Data > Add Datasource > JDBC to add Treasure Data as the data source for the report. When you select **Preview**, the job starts running on the cloud (you can confirm this using the td jobs command). You can now design your reports using Treasure Data as a data source.

![](/assets/image-20191016-203110.326b86ec19527fbaaeb28e7e107c630dce8ece35f049746be7f85632a0cebe67.f9f2883c.png)