BIRT Implementation with custom Data Source

wang31894

All,

I am brand new to BIRT, Please pardon my question below. :-)

I am interested to find a way to implement BIRT with a custom data source, for example, I have a database connection string in a XML file ( ex: Ibatis), I like to use the same connection in BIRT to create reports. I also like to know if anyone out there who already done so and willing to share the sample source codes, I like to learn how Java class reads the database connection from XML file, how to use connection to create dataset(s) then display report(s) in jsp page?

I really appreciate your help and this will greatly shorten my learning process

thx

mwilliams

To create the connection, you could create a connection profile. If you're always connecting to the same data, you could also create the dataSource one time in a library, then use this dataSource in all of your reports. If you're needing to change the dataSource connection dynamically, you can pass the info in through parameters doing something like:

http://www.birt-exchange.org/org/devshare/designing-birt-reports/734-how-to-replace-db-connection-parameters-at-run-time/

For the displaying of the report in JSP. If you deploy the viewer to an app server, you can use the tag library to embed the viewer into JSP pages to display your reports.

http://www.birt-exchange.org/org/devshare/deploying-birt-reports/298-2.2-birt-tag-library/