How to specify the connection information for a database or other JDBC data source
In Data Explorer, right-click Data Sources, then choose New Data Source.
On New Data Source, supply the following information:
Select JDBC Data Source from the list of data source types.
In Data Source Name, type a name for the data source. The name must be unique in the current report.
Figure 2‑2 shows a default data source name.
Creating a JDBC data source
New JDBC Data Source Profile shows connection properties, as shown in
Defining JDBC connection information
Specify the connection information for the JDBC data source:
In Driver Class, choose a driver class from the drop-down list. If you do not see the driver class that you want to use, add a driver as described later in this section.
In Database URL, type the database URL, using the syntax that the driver requires. Typically, BIRT Report Designer displays the necessary syntax in Database URL. For a Sun JDBC/ODBC bridge, for example, the syntax is
jdbc:odbc:<data source name>
where <data source name> is the name of your data source. For example, the following URL identifies the sales database:
In User Name, type the user name to use when connecting to the JDBC data source. This field can be left blank if your data source does not require a user name.
In Password, type the password to use when connecting to the JDBC data source. This field can be left blank if your data source does not require a password.
In JNDI URL, type the full path to the connection pooling service, if applicable. The following path is an example:
In the example, MyDataSource is the name of the JNDI database service.
To ensure that the connection information is correct, choose Test Connection. If Test Connection returns an error, repeat the preceding steps to correct the error. Then, test the connection again.
Choose Finish. The new JDBC data source appears under Data Sources in Data Explorer.