How to create a data connection definition for an ODA data source

1	In Navigator, select the appropriate project.

2	Choose File→New→Data Connection Definition.

3	In New Data Connection Definition:

In Name, type the name of the ODA data source.

In Type, choose a type from the drop-down list.

In Description, type a description for the ODA data source.

To retrieve the connection property values from the data source connection configuration file at run time, type the configuration key in Configuration key.

Figure 2-8 shows an example of creating an ODA data source connection definition.

Figure 2-8

Creating an ODA data source connection definition

Choose Finish.

The data connection definition file name appears in Navigator, and Data source connection properties appears.

4	In Data source connection properties:

If you did not provide a configuration key earlier, you may provide one now.

Figure 2-9 shows an example of beginning to specify the connection properties for an ODA data source connection definition.

Figure 2-9

Specifying connection properties for an ODA data source connection definition

Choose Data Source Properties.

In the data source connection properties dialog:

Provide values for the data source connection properties.

Figure 2-10 shows an example of specifying the properties for a flat file data source.

Figure 2-10

Specifying connection properties for a flat file data source

Choose Test Connection to test the connection to the data source.

If Information Object Designer connects to the data source, a confirmation message appears. Choose OK.

Choose Finish.

Choose Map tables to create a map of an ODA data source query result set.

Copyright Actuate Corporation 2012