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”

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

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.

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

BIRT Tutorial