0
No reviews. Be the first!

Resources

Big Data Analytics for Cassandra

Primary tabs

Jaspersoft Cassandra Connector

The Jaspersoft Cassandra Connector works with Jaspersoft Studio and JasperReports Server.  This page supports v1.0 of the connector, for documentation of v0.5.1 go here.

Target Audience

Users who want to integrate Jaspersoft's JasperReports Server with Cassandra. This document assumes that the user already has familiarity with Cassandra and already has data in a Cassandra database.

Background

JasperReports Server 5.5 and below does not ship with built-in connectors to Cassandra and therefore is considered a community release without technical support. The connector is released under the AGPL license.

What's new in version 1.0?

  • CQL3 support
  • Authantication support
  • Jaspersoft Studio support

Using the Cassandra connector

Obtain and unzip Cassandra Connector for Jaspersoft

Download the latest v1.0 from the project /project/cassandra-connector/releases. The following files are included:

WEB-INF/

      | — bundles/
      |       |
      |       | — CassandraDataSource.properties
      | ---- lib/
      |       |--- cassandra-all-1.2.9.jar
      |       |--- cassandra-thrift-1.2.9.jar
      |       |--- jasperserver-cassandra-connector-5.6-connectors-SNAPSHOT.jar
      |       |--- js-cassandra-datasource-1.0.0-SNAPSHOT.jar
      |       |--- guava-14.0.1.jar
      |       |--- libthrift-0.9.0.jar

      | — applicationContext-CassandraDataSource.xml

 

Configure JasperReports Server

  1. Unzip and merge the content into your Jaspersoft Server and restart. (Minimal version 5.1)
  2. Log in to your server 
  3. Create a new "Cassandra Data Source" 

jdbc:cassandra://YOU_CASSANDRA_SERVER_IP:9160/keyspace

Report Development

  1. Download the latest Jaspersoft Studio here (Minimum version required 5.5.1)
  2. File → New →Jasper Report
  3. Choose any template and click "Launch Report Wizard".
  4. Set the report name and location.
  5. On the New Report Wizard, select the specific Data Adapter or create a new one for "Cassandra Data Source".
  6. Use the following connection string format: jdbc:cassandra://50.19.26.17:9160/test?version=3.0.0
  7. Input your query and proceed as any report.
  8. Deploy your report to the server like any other report and set the data source as the new JasperReports Server data source you created

Run the report

Search for the report or browse to the report in the JasperReports Server repository.

Feedback