Configuring Stardust ODA Data Sources

The next two sections explain how to create an ODA data source to connect to Stardust Process Model and Runtime Data. After having created Stardust ODA data sources, you may specify arbitrary Runtime Views and Model Views on these data sources as primary sources for your reports. For basic information on connecting data sources please refer to the BIRT Help.

This chapter describes the configuration for the following data source types:

The Process Database Data Source

An Stardust Process Database ODA Datasource is a connection to a Stardust Audit Trail Database.

Creating a Data Source

To create a data source:

Create Data Source

Now you may specify the connection parameters in the following dialog:

General Database Settings

Hereby, Driver Class Path, Database URL, Database User and Database Password are the JDBC Connection parameters to a local JDBC-connected database. Datasource JNDI Name is the name of a database in a managed environment, e.g. a Web application server or an application server.

The JDBC connection parameters are used to connect to the database during report design time for preview purposes, the data source JNDI name is used at runtime, when the carnot-reporting.war is deployed to an application server.

In case you enter a JNDI name, the driver class is looked up via JNDI. If you do not provide the data source JNDI name, the JDBC connection parameters are also used at runtime. In this case, you cannot use the pooling or transaction synchronization mechanisms of the application server environment.

There are some predefined driver class paths provided, which you can select via the drop-down arrow on the right side of the Driver Class Path entry. To extend or modify this list, select the button Manage Drivers... to open the Manage JDBC Drivers dialog:

In the JAR Files tab you can add, delete or restore a new database driver jar. If you click the Add button, a file browser opens to browse for a driver jar:

To edit the default settings for a driver, like the name displayed or a URL template:

  1. Select the tab Drivers.
  2. In the driver class list select the driver you want to edit and click Edit....


  3. In the Edit JDBC Driver dialog enter a driver display name and a URL template you want to use for the Database URL entry, e.g.:


Now you can select the defined driver class in the Driver Class Path list:

The entry for the Database URL will be filled with the URL template defined for the selected database driver, e.g.:

Database Partition

If this field is left empty, the audit trail will be checked for partitions. In case exactly one partition exists, its ID will be used. In case there are more than one partitions an exception will be thrown with the message that the partition needs to be specified.

In case you specify a partition ID in this field, its existence in the audit trail will be checked. If a partition with this ID exists, it will be used, otherwise an exception is thrown.

Worktime Calculator

The Worktime Calculator selects the plug-in containing the worktime calculation business logic. For more information on this issue please refer to chapter Calculating Worktime.

You may use an arbitrary number of different Stardust Process Database data sources per report.

Test Connection

Once you filled out all the necessary entries, you can test the connection by clicking Test Connection.

Note

If you are not able to create a DataSource please check in the Error Log view (Window > Show View > Error Log) of the Java perspective, if your license might not be valid.

Using the embedded Derby Database in a RAD Environment

This section describes how to connect to the embedded derby database that is used within the RAD (Rapid Application Development) environment.

  1. In the Select Process Database dialog select Manage Drivers.
  2. In the Manage JDBC Drivers dialog select Add.
  3. Now a file browser opens, where you go to your Eclipse folder and choose the derbyclient.jar from the following location:
    eclipse/plugins/org.eclipse.stardust.ide.thirdparty.db.derby.client_10.8.2.2/lib

Add the Derby Driver.

Now this driver is provided in the Driver Class Path list, where you can select it:

Select the Derby Driver.

Enter the following Database URL:

jdbc:derby://localhost/carnot

Choose a JNDI name:

java:comp/env/jdbc/AuditTrail.DataSource

Now start the server and test your connection.

The Model Data Source

a Stardust Process Model ODA Datasource is a connection to a Stardust Process Model. To select it:

Provide the file path to the process model in File Path Process Model, e.g.:

You may use an arbitrary number of different Stardust Process Model data sources per report.

Stardust Parameters Data Source

Stardust provides predefined parameters to be evaluated by the data source. Please refer to the section Stardust Parameters of the chapter Sample Reports and Library for detailed information.

To create a data source with predefined Stardust Parameters: