Steps to Enable TRIRIGA_DB Data Source

A new BIRT Eclipse environment will not have the database drivers installed so it will take a few preliminary steps in order to enable direct database access from within the BIRT-Eclipse environment. These steps are described for an Oracle database, but the steps are nearly identical for a Microsoft SQL Server database.

In order to run through these steps, be sure that the BIRT-Eclipse environment is in a 'Report Design' perspective:

  1. Open TRIRIGA report or library that utilizes the TRIRIGA_DB data source (e.g. TRIRIGALibrary.rptlibrary).

If you are not starting from an existing report, you can add the Data Source. Those steps are described in the Steps to add TRIRIGA_DB Data Source to new Report. Once that is done, you can resume these steps.

  1. From the 'Data Explorer' tab, select option to edit the TRIRIGA_DB data source:
  1. Enter connection information in Driver Class, Database URL, User Name, and Password:

  1. Click 'Test Connection...'. If the driver is not installed, an error will be thrown:
  1. Locate the Oracle JDBC JAR on the file system. A TRIRIGA install includes this JAR in the lib directory (e.g. C:\Tririga\62390\lib\ojdbc6.jar)
  2. At this point, select 'Manager Drivers...' and click 'Add...' to add the Oracle driver. Once selected, this will be added to the 'JAR Files' list.

After added, the 'Drivers' tab will now show the Oracle drivers:

  1. If you leave the 'Manage JDBC Drivers', the 'Test Connection' should now work assuming it's pointing to a valid database with the correct credentials.

Note that the JNDI URL will not be used in the Eclipse environment. This will only be used when running inside a TRIRIGA server. Also note that, when running in a TRIRIGA server, the Database URL and credentials will not be used; in that context, only the JNDI URL will be used.

Steps to add TRIRIGA_DB Data Source to new Report

  1. In new report, create a New Data Source
  1. Select 'JDBC Data Source' and enter the name as 'TRIRIGA_DB'