Home
Analytics
How to make the database connection a library or shared so each report does not contain a separate d
Eswar B
Hi,
For the a project which has same datasource for all reports. If we have 10 report files and we have to keep same Data Source in each report. But I want it to be secure and keep the database connection separate and use it in all the reports.
How to make the database connection a library or shared so each report does not contain a separate database connection.
Thanks
Eswar Bathini
Find more posts tagged with
Comments
CBR
Hi,
you have to create a library and add the data source to this library. Then you have to use the library in your report and importing the data source into your report.
The tutorial at:
http://www.theserverside.com/news/1364376/Using-Eclipse-BIRT-Report-Libraries-and-Templates
gives quite a good insight in how to work with libraries in BIRT.
hope this helps
Christian
CBR
The tutorial is quite old. There is no view Library Explorer in current releases. Just use the resource explorer view (it's the third most in the palette section to the left)
Kirtiraj
Hi cbrell,
Thanks for your post. Most helpful. We followed your instruction "you have to create a library and add the data source to this library. Then you have to use the library in your report and importing the data source into your report." and this works fine in the report designer.
But when i try and load this up on the iserver, and try to view it in the Information Console we get the error
"An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Missing properties in Connection.open(Properties). "
What i have done is load our report(.rptdesign) to a folder called /Report and library(.rptlibrary) to a folder called /Resources. is this correct?? and how does the report get internally linked to the library??
Thanks.
Sadia Khan
Hey Kirtiraj,
I am also getting same error when using data source from library
An exception occurred during processing. Please see the following message for details:
Cannot open the connection for the driver: org.eclipse.birt.report.data.oda.jdbc.
org.eclipse.birt.report.data.oda.jdbc.JDBCException: Missing properties in Connection.open(Properties).
Did you get any solution? If so kindly share.