- Use a file manager to copy the JAR files that contain the JDBC drivers you want to use to the following directory in your BIRT Report Designer installation:
If you do not copy the JAR file to this location, you will have to restore the driver whenver you want to use it.
- In BIRT Report Designer, open or create a project and a report design.
- Choose Data Explorer.
- Right-click Data Sources, then choose New Data Source from the context menu.
New Data Source--Select a Data Source type appears.
- Identify the type of data source as JDBC:
- In Data sources, select JDBC Data Source.
- In Data Source Name, type a name for the data source or accept the default name.
You do not need to create a BIRT Report Designer data source to add a JDBC driver but the name in this field must be unique in the current report design.
- Choose Next.
New Data Source--New Data Source appears.
- In New Data Source--New Data Source, choose Manage Drivers.
Manage JDBC Drivers--JAR Files appears.
- Add the JAR files for the additional JDBC driver:
- Choose Add.
Open appears.
- Navigate to the directory with the driver class file, select the driver JAR file and choose Open.
Manage JDBC Drivers--JAR Files appears, showing the new driver class.
- Choose Drivers.
Manage JDBC Drivers--Drivers appears.
- Specify the properties for a driver:
- Select the new driver.
- Choose Edit.
Edit JDBC Driver appears.
- Specify settings for the JDBC driver:
- In Driver Display Name, type a name you want to display for this driver on the Display Name column of Manage JDBC Drivers--Drivers.
- In URL Template, type the syntax suggestion you want to display for this driver in Database URL on New Data Source--New Data Source.
Choose OK.
Manage JDBC Drivers--Drivers appears, displaying the new display name and URL template syntax suggestion.
- Choose OK.
New Data Source--New Data Source appears. If you choose the driver you specified in Edit JDBC Driver, BIRT Report Designer displays the URL template syntax suggestion you provided.