Defining a JDBC Data Source

To define a data source of type JDBC

1. In the BIRT Data Explorer view, select the Data Sources entry.

2. Choose New Data Source from the context menu.

3. In the New Data Source wizard, specify the following information:

a. Select JDBC Data Source from the list of data source types.

b. In Data Source Name, type a name for the JDBC data source.

4. Click Manage Drivers..., and then the Add... button.

5. In the Open dialog box, navigate to the following folder:

<Software AG_directory>/Designer/eclipse/plugins

6. Select the file com.centrasite.ext.dd.cjdbc_*.jar, and click Open.

The wildcard symbol (*) is a placeholder to represent the version number of the driver library. Make sure that you select the latest version of the driver library.

7. In Driver Class, type the corresponding driver of the relational database you want to access:

DB2: com.softwareag.common.jdbc.driver.DB2ProxyDriver

Microsoft SQL Server: com.softwareag.common.jdbc.driver.MSSQLProxyDriver

Oracle: com.softwareag.common.jdbc.driver.OracleProxyDriver

Sybase: com.softwareag.common.jdbc.driver.SybaseProxyDriver

8. In Database URL, type the URL for the database, using the format that the driver requires.

DB2: jdbc:wm:db2://<server_name>:<port>;databasename=<database_name>

Microsoft SQL Server: jdbc:wm:sqlserver://<server_name>:<port>;databasename=<database_name>

Oracle: jdbc:wm:oracle://<server_name>:<port>;sid=<database_name>

Sybase: jdbc:wm:sybase://<server_name>:<port>

Wherein, the substitution tokens <server_name>, <port>, and <database_name> are placeholders that should be replaced by real values.

9. In User Name, type a valid user name to connect to the JDBC data source.

10. In Password, type a valid password to connect to the JDBC data source.

11. Click Finish to create the data source with the specified name.