PDA

View Full Version : Data source



gwessels
09-30-2005, 02:40 AM
Hello,

How can I specify ONE datasource for use in all my BIRT reports. I cannot edit every report definition with the respective datasource connection parameters at each client I deploy to! As far as I know BIRT doesn't support a common datasource across reports yet. Is there a workaround in Pentaho for this. Is this where JNDI comes in? An example would be great.

Thanks.

mbatchelor
09-30-2005, 05:07 AM
I have written a BIRT plugin that uses JNDI as a datasource - it needs further testing though.

The way it works is as follows:

For desktop use (i.e. during report design), it utilizes simple-jndi (http://www.osjava.org) and tries to locate the JNDI name from there. When deployed inside Pentaho, it finds the bound JNDI name within the container.

It isn't quite ready for prime-time yet, and there are some reported bugs in BIRT that make the whole thing more bloated than it should be, it is still a useful plugin. We'll see about making it available in our next release as a pre-beta.