How to connect BIRT to Database

Written By Bear

Make sure you have the correct jdbc driver for your database in the jdbc drivers folder:

Ex: eclipse\plugins\org.eclipse.birt.report.data.oda.jdbc_(eclipse_version)\drivers

In a new report find the Data Explorer and right click the Data Sources folder then select “New Data Source”

picture1.png

In the New Data Source window select the “JDBC Data Source” then name your data source in the “Data Source Name” box.

picture2.png

In your new JDBC Data Source Profile window add your jdbc jar files associated driver class, Database URL connection string, Database User Name, and Database Password.

picture3.png

Test Your connection to see if credentials are correct and you can connect to your target database.

picture4.png

BIRT Tutorial

Bear
Previous

Create alternate row colors in a BIRT report.
Next

Create BIRT Data Set