Jump to content

BIRT Developer Center Download

BIRT Evangelist Blog


BIRT Usergroup Mannheim Meets November 21st

Posted by Virgil , 04 November 2013 - - - - - - · 8316 views
BIRT, BUG, Germany
If you will be in or around the Mannheim, Germany area on November 21, I encourage you to take some time to attend the next Mannheim BIRT User Group meeting (BUG Mannheim). It should be a great experience for all participants where you'll be able to connect with other BIRT users in the area as well as share and learn some cool things about BIRT!

The meeting will take place on November 21, 2013 starting at 6pm German time at OIO http://www.oio.de in Mannheim, Weinheimer Strasse 68. Food and drink will be available and attendance is free.
For directions see: http://goo.gl/hTVYK

Please register so they'll know to expect you: https://www.xing.com...annheim-1317629


Introducing the Free BIRT Viewer Toolkit - BIRT TechTalk Series

Posted by Virgil , 02 November 2013 - - - - - - · 7776 views
BIRT, Viewer, integration and 1 more...
Introducing BIRT TechTalks: Our monthly series of BIRT-focused technical sessions!

By joining our TechTalk community you will be kept abreast of all the latest happenings in the world of BIRT. We’ll have experts reveal tips and tricks, share best practices, give you a sneak peek into new product features, and more.

Can’t make it? No problem. All recordings will be posted to our site so you don’t have to miss a single episode!

In our first 30 minute TechTalk - Introducing the Free BIRT Viewer Toolkit - Enhance the Way Your Users View BIRT Designs - on Wednesday, November 13, 2013 at 11am PT we’ll cover how the newly launched BIRT Viewer Toolkit renders BIRT-based data visualizations and reports in a more powerful and user-friendly way, enhancing the experience for your internal users or in your externally-facing application.
Attend this TechTalk to learn:
  • What is the BIRT Viewer Toolkit?
  • How does the Viewer Toolkit enhance the viewing experience of your application?
  • How can you easily integrate the Viewer Toolkit into your existing application?
Thank you for joining us and stay tuned!
Event Details:
Title: Introducing the Free BIRT Viewer Toolkit - Enhance the Way Your Users View BIRT Designs
Date: Wednesday, November 13, 2013
Time: 11am PT | 2pm ET
Duration: 30 minutes

Location: Web



BIRT developer vs Java coder

Posted by Virgil , 02 November 2013 - - - - - - · 6865 views
BIRT, Java, web app, development and 3 more...
Have you ever wondered just how much time and effort BIRT can save you in developing information driven, customer facing web and mobile applications? This "docu-drama" compares the experience of two enterprise developers creating a mission critical application, one who uses BIRT, and one who insists on hand coding in Java.

Attached Image
Watch the Video



Sneak Peek at the Upcoming MongoDB ODA

Posted by Virgil , 22 April 2013 - - - - - - · 7656 views

Soon after the MongoDB noSQL-style database system started becoming popular, the BIRT community started asking for ways to get at that data. The good news for developers using BIRT, is that BIRT was designed with data source extensibility in mind. There are several ways to connect to MongoDB as a data source within BIRT. This post will show how to connect to MongoDB with your existing BIRT version, plus several screenshots from the new MongoDB ODA driver being added to the next major release of BIRT due out this summer.

BIRT Scripted Data Source Connection to MongoDB
The BIRT Scripted Data Source is like the ?silver-bullet? into any data source. If you cannot connect to your data with one of the built-in BIRT data sources, then the Scripted Data Source may be the answer. It uses the server-side RHINO JavaScript engine allowing you to write a bit of Java or JavaScript as a simple wrapper to your data. As long as you can get to your data in your application, then it?s likely the Scripted Data Source can get that data into BIRT.

To create a connection to MongoDB, you first need to add the MongoDB JAR to your project classpath. Now, you just add a bit of JavaScript to the following methods to make it work.

Create connection and query in the open method

m = new Mongo( "localhost" , 27017 );
db = m.getDB( "scratch" );
col = db.getCollection("zips");

query = new BasicDBObject();
query.put("state", "AL");
cursor = col.find(query);

The fetch method will get called repeatedly while you return true
if( cursor.hasNext() ){
var jsonStr = new String(cursor.next());
row["city"] = jsonStr.split(",")[1].split(":")[1].replace("\"", "");
row["zip"] = jsonStr.split(",")[2].split(":")[1].replace("\"", "");
row["state"] = jsonStr.split(",")[6].split(":")[1].replace("\"", "").replace("}","");
return true;
return false;

The close method is used to discard objects

Community Created BIRT Plug-Ins for MongoDB
Part of BIRT?s extensibility allows for external plug-ins to be dropped into existing versions of BIRT. There have been several community developed BIRT plug-ins to access MongoDB data created over the years. At the time of this post, a quick search in the BIRT Exchange DevShare shows 3 different MongoDB ODA Driver plug-ins to choose from.
Attached Image

New MongoDB ODA Driver for BIRT
The next major release of BIRT will include a new data driver for accessing MongoDB. This means, instead of creating your own connection to MongoDB in a scripted data set, you can now simply select MongoDB from a list of available choices.
Attached Image

Next, fill out the database credentials and connection information. This information can be hard-coded in each specific field or the connection information can be dynamically generated at runtime using BIRT?s Property Binding feature.
Attached Image

Once you have created a connection, you can now create a new Data Set to query for specific data. BIRT supports the MongoDB operations that return data. This includes the Query commands, the Aggregate command, MapReduce, and select Database Commands that return data.

Creating a MongoDB Data Set in BIRT
Attached Image
The new MongoDB Data Set dialog allows you to choose the data Collection and fields you want returned from the query. Java Objects can be flatted out to bring in just the data elements, or the entire object can be brought back for further processing. Select Finish and we can now preview the results of the MongoDB query.
Attached Image

Using a MongoDB MapReduce Command in BIRT
Attached Image

Using a MongoDB Aggregate Command in BIRT
Attached Image: MongoDB_ODA_Aggregate.png

Using a MongoDB Database Command in BIRT
Attached Image: MongoDB_ODA_DatabaseCommand.png

BIRT supports a subset of the MongoDB Database Commands that return data. The following is a list of the supported database commands from within BIRT.

buildInfo, collStats, connPoolStats, count, cursorInfo, dataSize, dbStats, distinct,
eval with nolock: true geoNear, geoSearch, getLastError, getLog, getPrevError, group, isMaster, isdbgrid, listCommands, listDatabases, listShards, ping, printShardingStatus, replSetGetStatus, serverStatus

There are several ways to connect to MongoDB no matter what version you are using. The new MongoDB ODA driver will make it?s first appearance in BIRT version 4.3 Milestone 7 due out soon.


Visualizing Big Data with Hadoop and BIRT

Posted by Virgil , 22 April 2013 - - - - - - · 8028 views

According to Wikipedia, Big data is a collection of data sets so large and complex that they are difficult to process using on-hand database management tools or traditional data processing applications. Big data usually includes data sets with sizes beyond the ability of commonly used software tools.

It?s a good thing BIRT is not your traditional data processing application!

Eclipse BIRT was built with data source extensibility in mind. BIRT does this by leveraging the Eclipse Data Tools Project (DTP) and more specifically, the Open Data Access (ODA) framework. This framework allows new data sources, like recent big data sources, to be easily added to BIRT as needed. This post walks through creating a connection to Hadoop in order to visualize the data within BIRT.

Using HQL to query Hadoop data
BIRT provides an out-of-the-box driver that allows access to Hadoop Data through Hive using Hive Query Language (HQL). Hive is a data warehouse infrastructure built on top of Hadoop for providing data summarization, query, and analysis. To retrieve data from Hadoop, you write a query in Hive
Query Language (HQL). HQL supports many of the same keywords as SQL, for example

A Hive query is executed by a series of automatically generated MapReduce jobs.
Alternatively, you can use the TRANSFORM statement to specify scripts that translate into
MapReduce functions in Hadoop. These scripts can be written in virtually any programming language. For example, the following HQL query specifies the script file mytest.py, written in the Python programming language.

TRANSFORM (userid, movieid, rating, unixtime)
USING 'python mytest.py'
AS (userid, movieid, rating, weekday)
FROM u_data

Creating an HQL query in BIRT
To create a new query, select Hive Datasource from the New Data Source wizard
and enter the connection properties, as shown in the figure below.

Attached Image

Next, choose Manage Drivers and add the Hive client JAR files. You
only need to do this once.

Attached Image

Now, you can create a data set by writing an HQL query. If your query uses TRANSFORM
statements that reference script files, use the Add File Statement property to add files to the
Hadoop distributed cache. Type a semicolon-separated list of Add File commands. This property can be overridden by the data source or data set, using property binding or script. Type the HQL query in the query text area of the data set editor as shown below.

Attached Image Complex HQL Subquery Example

Attached Image Get JSON Object Example

Attached Image Regular Expression Example

Attached Image HQL Hints Example

Getting the Important Data to Stand Out
You can create multiple data sets using the same steps above, even joining data sets within BIRT. Once you have your big data connections and queries defined, you can start using the data to define your report within BIRT. At this point, you can simply drag your data sets onto the report canvas and start formatting.
Attached Image

But, being able to store more data brings its own new sets of challenges. The more data collected typically means more data that needs to be analyzed and displayed. This means, the important data really needs to stand out. BIRT supports this with several out-of-the-box features.

With the Highlighting feature in BIRT, you can set up formatting rules that are based on expressions. You can create simple to quite complex expressions in order to highlight the data. Highlighting can be added to grids, tables, columns, rows, data elements, labels, charts, and images.
Attached Image

The Visibility feature allows you to use expressions to decide which areas of BIRT are visible. This is quite useful for allowing certain groups of people to see only their data but can also be used to hide whole areas based on the data discovered. Visibility can also be applied to grids, tables, columns, rows, data elements, labels, charts, and images, but you can also have seperate visibility rules based on the final output, like PDF, HTML, etc.
Attached Image

Try it Yourself
The Hive/Hadoop data source has been available since BIRT 3.7 and can be downloaded as part of the Eclipse BIRT Designer from eclipse.org/birt or BIRT Exchange.


BIRT DZone RefCard Updated for BIRT 3.7

Posted by Virgil , 03 April 2012 - - - - - - · 7958 views

The popular Getting Started with BIRT DZone Refcard has been updated. The BIRT DZone Refcard is the 50,000 view of the BIRT project from a developers perspective. It briefly explains the BIRT project in terms of components, select capabilities and features. It's just enough information to get you interested in BIRT and just enough detail to get you started.

The latest version has been updated to support BIRT 3.7 and includes additional information on BIRT Syles, Expressions and Scripting.

Download the BIRT DZone Refcard from http://www.birt-exchange.org/org/devshare/designing-birt-reports/1486-birt-cheat-sheet-from-dzone-refcardz/
Posted Image


BIRT and Big Data at EclipseCon 2012

Posted by Virgil , 14 March 2012 - - - - - - · 6789 views

BIRT Exchange will once again be sponsoring the EclipseCon 2012 Developer Conference. This year the conference will be held in Reston, VA (Washington DC area) from March 26th-29th.

There are 3 BIRT Sessions in this years EclipseCon conference program:

What is BIRT? Quick Jumpstart (presented by Virgil Dodson)
This session introduces BIRT and looks at how you can leverage BIRT to quickly create data-driven reports, web pages, and compelling information visualizations using its visual drag-and-drop design environment. This session provides a great orientation to the BIRT project and technology and how it might benefit your applications.

Extending BIRT with Plug-ins (presented by Michael Williams)
This session will show off several new plug-ins created by the community from a recent BIRT plug-in contest and also show step-by-step use of the ODA wizard to create a new BIRT data source and show where to find current plug-ins in the source code to use as a starting point for creating your own BIRT plug-ins faster. Attendees will leave this talk with an understanding of BIRT plug-ins and the various ways to extend BIRT.

Introduction to BIRT (by John Ward)
This tutorial will walk users through the BIRT environment and guide them through building their first few reports using the BIRT reporting tool

BIRT and Big Data
Pick up a whitepaper in the BIRT Exchange booth with step-by-step instructions on how to connect, access and display Hadoop data using HIVE Query Language (HQL) within BIRT-based applications.

Contests and Prizes
There will be lots of random giveaways to booth visitors, and we?ll announce a developer contest where we?ll be awarding three (3) new iPads.


Announcing BIRT Style Contest

Posted by Virgil , 09 January 2012 - - - - - - · 6935 views

After the success of our recent BIRT plug-in contest, we started thinking about another contest to keep the great BIRT community contributions coming in. We wanted a contest with a low barrier of entry allowing more users of BIRT, even new ones, to get involved. What we came up with is the 'BIRT Style Contest'. The contest allows BIRT users to show off their creative side by submitting a BIRT style example to the BIRT Exchange DevShare or Marketplace.

Actuate will award a Kindle Fire to each of the best three style examples submitted to either DevShare or the BIRT Exchange Marketplace between January 9, 2012 and February 9, 2012.

Styles are used within BIRT designs allowing you to create richly formatted web content. These styles can be applied directly within the BIRT Designer, imported from existing CSS stylesheets, and referenced at runtime to match your existing web application look and feel. Styles can also be applied dynamically based on parameters or scripting creating a customized experience for the user.

Some BIRT style examples might include:
  • Clever use or colors (seasons, team colors)
  • Style applied dynamically based on time of day, or year.
  • Style applied based on external data like weather or regional info
  • Your unique BIRT style example

Any DevShare submission that makes use of a BIRT style will be considered for this contest.

Contest rules, details and more suggestions can be found on the Contest Details and Examples page.

I look forward to seeing some more great contributions!


BIRT Techies Needed

Posted by Virgil , 22 July 2011 - - - - - - · 9594 views

There are several open positions at Actuate but a couple of these positions may be of interest to the BIRT Exchange developer community. Actuate is looking for developers who are familiar with BIRT to fill the following roles.

Marketing Applications Developer
The Marketing Applications Developer will create and maintain BIRT-based application content for demonstrations, proofs of concept, and deployment to the BIRT onDemand hosted reporting application platform and service from Actuate. This high-visibility position requires a broad base of experience in Business Intelligence, application development, Internet infrastructure, cloud deployment (in Amazon AWS) and security, application hosting and integration, and Java development. The ideal candidate will also possess deep knowledge of databases, data warehouses, BIRT, Eclipse, Actuate iServer, and its configuration and management in large-scale, highly available environments.

Customer Support Engineer
The Customer Support Engineer provides accurate, timely technical support to Actuate Software customers primarily via the telephone and E-mail. The Engineer will deal with support issues that are complex in nature, carry differing priorities and must be addressed within predetermined service levels, so the Engineer must be adept at balancing multiple priorities. In addition, the Customer Support Engineer will be handling pre-sales support calls, so must have an orientation toward sales as well. The callers will expect enterprise-level support, therefore the Engineer will need to be well-versed technically, and fully understand customer service concepts. Other objectives are to contribute to the development of the automated, self-help tools; to collect and report upon information gathered from incidents; and to interface with Sales, Marketing, QA/Test and others as necessary. In addition, a Customer Support Engineer will carry out projects as assigned by the management staff, cooperate with other Customer Support Engineers in carrying out their day-to-day duties, and represent Actuate Software in a visibly supportive manner.

If you want more information about these jobs, contact
Actuate HR: Lisa Yakushi, lyakushi@actuate.com, 650-645-3413


BIRT Sessions at EclipseCon 2011

Posted by Virgil , 16 March 2011 - - - - - - · 6957 views

There are several BIRT sessions this year at EclipseCon. Below is a list of BIRT related sessions that should give anyone a jumpstart to learning BIRT. If you are attending and interested in BIRT then it is a good idea to print this page to take with you.

Monday, March 21st

What is BIRT? 20 Minute Jumpstart ? Virgil Dodson (20 min) 1:00pm


BIRT for ISV and OEM Applications ? Rob Murphy (20 min) 1:30pm


Reports and Charts right from your EMF models - Lothar Werzinger (20 min) 2:00pm


Getting Started with BIRT - John Ward (2 hrs) 3:40pm


Tuesday, March 22nd

BIRT to the Bare Metal: Framework and API ? Jason Weathersby (40 min) 11:40am


Wednesday, March 23rd

Extending the BIRT Chart Model ? Jason Weathersby (20 min) 11:10am


Thursday, March 24th

FAQ: Hands-on Tips from the BIRT Forums ? Michael Williams (20 min) 1:30pm


BIRT 360 ? Would Your Users Like BIRT Based Dashboards? ? Mihail Mihaylov (20 min) 2:00pm


BIRT Data Analyzer ? Instantly Convert your BIRT Report into an Analytic Application!! ? Mihail Mihaylov (20 min) 2:30pm


height="100" width="130" alt="I'm sponsoring EclipseCon 2011"/>

We are sponsoring EclipseCon again this year so be sure to stop by and see us in the Exhibit Hall

August 2017

20212223 24 2526

0 user(s) viewing

0 members, 0 guests, 0 anonymous users

Search My Blog