This article explains how to use Treasure Data with JasperReports Server by leveraging our JDBC driver. By combining Treasure Data with JasperSoft, you can process terabytes of data on the cloud, while continuing to use your existing JasperSoft instances.


Prerequisites

Don't have time to setup JasperSoft and Treasure Data, leverage our Setup Consultation Service.

Download JasperReports Server

You can download JasperReports Server from the link below. Version 4.7.0 was used for this article.


Download the Treasure Data JDBC Driver

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

The driver is still in beta. Feedback is appreciated.


Add Treasure Data as Data Source

Let’s add Treasure Data as Jasper’s data source.


  1. Copy the Treasure Data JDBC driver to the JasperReports Server’s jasperserver application before starting JasperReports Server.

$ cp td-jdbc-VERSION.jar \
  <jasper-server-install>/apache-tomcat/webapps/jasperserver/WEB-INF/lib/

2. Start JasperReports Server


$ cd <jasper-server-install>
$ ./ctlscript.sh start

3. Log in to JasperReport Server as AdministratorAdministrators log-in through the standard login page using the following default credentials:


4. Select View > Repository. Right-click Data Sources and select Add Resource > Data Source from the context menu.


5. Configure your JDBC parameters as shown below. When asked for your user name and password, type use your Treasure Data credentials (your user name is the email address you used to register on Treasure Data). Select Test Connection and then Submit. The data source is now registered on your JasperReports Server.



Register Reports in JasperReports Server

Create and run reports with a JDBC source.

  1. Select View > Repository. Right-click Input data Types and select Add Resource > Query from the context menu.



2. Name the query.

3. Select Next.



4. Select the sample Treasure Data data source that you registered.

5. Select Next.


6. Define the query.

7. Select Save. The query is registered in JasperReports Server. The following query is introduced in the JasperSoft iReport with JDBC Driver article.


8. Select View > Repository.

9. Right-click Input data Types.

10. Select Add Resource > JasperReport from the context menu.


11. Set up the report as shown in the figure below.



12. Upload your JRXML file (the JasperSoft iReport with JDBC Driver article explains how to create this file).

13. Select the sample Treasure Data data source that you registered.



14. Select the query that you registered as shown below, then hit the Submit button. The report will be registered in JasperReports Server.


15. Select View > Repository. When you select Input data Types, you will see your registered report. Right-click it and select Run from the context menu.