All entries for Thursday 19 May 2005

May 19, 2005

Eclipse: Business Intelligence and Reporting Tools

Writing about web page http://eclipse.org/birt/

I quite often find myself wanting to get little reports out of different systems (generally blogs, but sometimes SSO or something else) and unless you've already created some nice reporting screens, it comes down to getting out your SQL tool of choice (Tora) and writing some SQL. Once you've got your data, you might then dump it into Excel and make some nice graphs. All in all, it's a pain in the ass, and you might end up doing the same thing over and over again.

If it annoys you enough, you might end up getting around to writing some code to do it for you automatically within your application, but this isn't the most flexible solution.

Whilst upgrading to the latest and very speedy Eclipse M7, I noticed BIRT. BIRT is a set of Eclipse plugins that can do business reporting for you. Having not worked with any other reporting tools before (and I'm sure there are some great and expensive ones), I didn't have much to base any investigations on, but I thought I'd have a look anyway.

Within about half an hour I'd vaguely got my head around it and could produce basic reports. It goes something like this:

  1. Create new empty report (optionally choosing a template)
  2. Set up a datasource pointing to your data
  3. Create a dataset that contains some particular chunks of data you're interested in
  4. Bind the dataset and datasource to an element in your report, such as a table or a pie chart
  5. Do a live preview of your report, showing a nice and always up to date report. Lovely.

That's about as far as I've gone, but it does work. I've not managed to make my reports look all that great so far, but it does look promising. In the ideal world I'd be able to do this and then publish the reports onto an app server and be able to visit it whenever I liked (and I may be able to, I've just not found that out yet), but it'll do for now.


May 2005

Mo Tu We Th Fr Sa Su
Apr |  Today  | Jun
                  1
2 3 4 5 6 7 8
9 10 11 12 13 14 15
16 17 18 19 20 21 22
23 24 25 26 27 28 29
30 31               

Tags

Search this blog

Most recent comments

  • One thing that was glossed over is that if you use Spring, there is a filter you can put in your XML… by Mathew Mannion on this entry
  • You are my hero. by Mathew Mannion on this entry
  • And may all your chickens come home to roost – in a nice fluffy organic, non–supermarket farmed kind… by Julie Moreton on this entry
  • Good luck I hope that you enjoy the new job! by on this entry
  • Good luck Kieran. :) by on this entry

Galleries

Not signed in
Sign in

Powered by BlogBuilder
© MMXXII