Creating a data connection definition for an ODA data source

The IO Design perspective uses an open data access (ODA) driver to connect to an ODA data source. The preconfigured ODA data source types include:

e.Reports Data Connector for iHub

BIRT document

Flat file

POJO

Static

Web services

XML

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

1 In Navigator, select the project to use.

2 Choose File➛New➛Data Connection Definition.

New Data Connection Definition appears.

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‑9 shows an example of creating an ODA data source connection definition.

Figure 2‑9 Creating an ODA data source connection definition

Choose Finish. The IO Design perspective displays the data connection definition file in Navigator.

Data source connection properties appears.

4 In Data source connection properties, complete the following steps:

Provide a configuration key if you did not provide one earlier.

Figure 2‑10 shows an example of specifying the connection properties for an ODA data source.

Figure 2‑10 Specifying connection properties for an ODA data source connection definition

Choose Data Source Properties.

In Custom Data Source properties, complete the following steps:

Provide values for the data source connection properties.

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

Figure 2‑11 Specifying connection properties for a flat file data source

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

If the IO Design perspective 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.

For more information about creating a map, see Creating maps.