Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Difference between revisions of "Cassandra Scripted Data Source (BIRT)"

Line 1: Line 1:
 
{{Backlink|Report Developer Examples (BIRT)}}  
 
{{Backlink|Report Developer Examples (BIRT)}}  
BIRT Designer and runtime deployment packages now support scripted data source connections for use with Cassandra distributions, including:<br>
+
BIRT Designer and runtime deployment packages now support scripted data source connections for use with Cassandra distributions, including:
 
*Apache Cassandra
 
*Apache Cassandra
 
*Datastax Cassandra Community
 
*Datastax Cassandra Community

Revision as of 14:17, 8 February 2013

< To: Report Developer Examples (BIRT)
BIRT Designer and runtime deployment packages now support scripted data source connections for use with Cassandra distributions, including:

  • Apache Cassandra
  • Datastax Cassandra Community
  • Datastax Cassandra Enterprise

BIRT connects to and queries a Cassandra data source using the Hector API. You must install the Hector client library JAR files in the org.eclipse.birt.me.prettyprint.hector_<version>/lib folder, and then restart BIRT Designer or the runtime deployment application.


Introduction

This example illustrates using the Web Service Data Source in a report.

BIRT Version Compatibility

This example was built and tested with BIRT 2.2 RC0.

Example Files

Example Report Zipped

Description

This example accesses a city locator from zip code web service located here: http://www.webservicex.net/uszip.asmx?WSDL.

The above URL is entered in the data source WSDL URL property. The data set is set to the getInfoByZIP Method. The default SOAP request template generated by the driver supplies one data set parameter for the zip code. It is important to remember any part of the SOAP request can be modified. To link a portion of the SOAP request to a data set parameter use the

&?symbol?&

syntax, where symbol is the name of the data set parameter. In the data set editor this parameter can be linked to a report parameter. In this example symbol is linked to the report parameter zipcode.

Once the response is returned, it is parsed just like the XML data source using XPath syntax.

Comments

Please enter comments below by selecting the edit icon to the right. You will need a Bugzilla account to add comments.


It appears that the web service that this report uses is no longer available.

___

Changed the report to use a new web service.

Back to the top