Skip to content

Usage with Birt

Jump to bottom
declan-wilson edited this page Apr 30, 2015 · 2 revisions

Overview

This page will outline using the JAQL jdbc based driver for Birt Eclipse (Luna 4.4.0), to create Birt Reports based on Ariel data.

PRE-REQUISITES

Birt Eclipse 4.4+ Download Birt

Simple Report

Create Data Adapter

  1. Launch Birt Eclipse
  2. Change view to "Report Design Explorer"
  3. File > New > Project > "Business Intelligence and Reporting Tools" > "Report Project" > Project Name = "MyFirstBirtProject"

  1. Navigator tab > highlight "MyFirstBirtProject" > File > New > Report > File Name = "first_report.rptdesign" > Blank Report

  1. Data Explorer tab > highlight "data sources" > right click > "New data source" > select "JDBC Data Source" > Data Source Name = "Ariel Data Source"

  1. Data source details:

  1. Data source jar: Manage Drivers > add jaql jar location

  1. "Test connection" to check connectivity to the Ariel instance

Build a Data Set

  1. Data Explorer tab > highlight "Data Sets" > rightclick "New Data Set" > Data set Name = "last_24hrs_events_summary"

  1. Build query : Query text window and output columns:

  1. Preview the data:

Build a Report

Some errors may occur when running the internal eclipse browser, if so: Windows > Preferences > Report Design > Preview > check "Always use external browser" Windows > Preferences > General > Web browser > check your preferred external browser

  1. Data Explorer tab > highlight "Data Sets" > highlight "last_24hrs_events_summary" > rightclick > "Insert into Layout"

  2. Bind the query's select columns for report display

  1. Layout should default to:

  1. Run > View Report > "In web viewer" (or select preferred output)

  1. You can use the same dataset, to insert charts, using the chart wizard to plot series of data

Clone this wiki locally