Adding data sources
In BIRT reports, all data is accessed through data sources. A starter report includes a single data source that is named TRIRIGA®. TRIRIGA is a scripted data source. All data sets that obtain their data from an IBM® TRIRIGA server must use this data source.
About this task
If the TRIRIGA data source does not provide all the data that you need, you can use the data access methods that BIRT supports, including JDBC and XML. Use a JDBC data source for direct access to the IBM TRIRIGA database. Note that this method does not go through the IBM TRIRIGA meta-layer and does not include built in business logic around security. You must add a JDBC data source manually, and it must be named TRIRIGA_DB. At run time, the report is modified so that it interacts with the IBM TRIRIGA database that is associated to the server that the report is running on.
Procedure
- In BIRT, select Data Explorer.
- Right-click Data Sources and select New Data Source.
- Select JDBC Data Source and in the Data Source Name field specify TRIRIGA_DB.
- Select Next.
- Optional: Select Driver Class.
- Specify the database URL, the user name, and the password.
- In the JNDI URL field, enter jdbc/local/Datasource-TRIRIGA-data, and select Finish.
- Right-click Data Sets and select the new data set name.
- Specify the SQL statement.
- Optional: Add parameters.
- Select Finish.