Setting Up an Oracle Database Connection in BIRT 1. Open BIRT. 2. In Data Explorer, right-click Data Sources. 3. Click New Data Source.
4. Select JDBC Data Source. 5. Click Next >
6. Click Manage Drivers…
7. Click Add…
8. Navigate to C:\oracle\ora92\jdbc\lib and select ojdbc14.jar. Click Open. Click OK. The driver now appears in the Manage JDBG Drivers dialog.
9. Select the Drivers tab. Select oracle.jdbc.OracleDriver (1.0). Click Edit…
10. In the Edit JDBC Driver dialog, enter “Oracle Driver” as Display Name and “jdbc:oracle:thin:@
::” as URL Template. Click OK.
11. The driver has been correctly set up in the Manage JDBG Drivers dialog. Click OK.
12. From the Driver Class drop-down, select the driver just configured. In Database URL, enter the URL, using the URL Template and substituting values for the database host (IP address), port number, and service name (database name). Enter the User Name and Password for the database. Click Test Connection…. In the Test connection dialog, click OK.
13. Click Finish.
14. The data source is now set up. You can create a new data set and run queries against the oracle database.