BIRT/ODA ObjectDB Driver
The ObjectDB BIRT/ODA driver is an extension for the open-source Business Intelligence and Reporting Tools (BIRT). It adds support for ObjectDB as a data source and JPQL as a data set query language.
For step by step
instructions on using BIRT with ObjectDB see the Report Generation with BIRT and JPA tutorial.
Driver installation
The driver is available as an Eclipse for Java EE Developers extension. To install it:
- Open the Install dialog box by selecting Help > Install New Software....
- In the Work with field, enter the ObjectDB update site URL: http://www.objectdb.com/eclipse and press Enter.
- Select the ObjectDB BIRT/ODA feature.
- Complete the installation by clicking Next twice, accepting the license agreement, clicking Finish, and then approving the installation and restarting the IDE.
Note: See this issue regarding matching the driver version to the ObjectDB server version when using client-server mode.
ObjectDB/JPA data source
To create an ObjectDB data source:
- Open the New Data Source dialog box by right-clicking the Data Sources node in the Data Explorer window and selecting New Data Source.
- Select ObjectDB Data Source from the list of available data source types.
- Enter a data source name (for example, ObjectDB Points) and click Next.
- Specify an ObjectDB connection URL. This can be an embedded URL (for example,
c:\points.odb) or a client-server URL (for example,objectdb://localhost/points.odb;user=admin;password=admin).
- Click Finish to create the ObjectDB data source.
Data sets and JPQL
To create the data set:
- Open the New Data Set dialog box by right-clicking the Data Sets node in the Data Explorer window and selecting New Data Set.
- Select an ObjectDB data source (for example, ObjectDB Points).
- Enter a data set name (for example, Points by X) and click Next.
- Enter a JPQL or a JDOQL query and click Finish.
See the Report Generation with BIRT and JPA tutorial for more detailed instructions.