Transparent Access to Local Heterogeneous Data Stores

An example that illustrates transparent access to local heterogeneous data stores.

Profile

An insurance company has an application that processes claims and requires data from two sources: a DB2 UDB for iSeries database and an Oracle database. The company uses ECDA Option for ODBC to retrieve data from the DB2 UDB for iSeries database and ECDA Option for Oracle to retrieve data from the Oracle database. This eases administration and eliminates the need for changes to the claims application.

Sybase Components

To retrieve the data without the application (or the user) being aware of the specific data location, the insurance company uses these three components in ECDA:

Adaptive Server/CIS
ECDA Option for ODBC (with the IBM DB2 UDB ODBC driver)
ECDA Option for Oracle

Sample Scenario

Transparent Access to Local Heterogeneous Data Stores

The figure is explained fully within the text.

The client application sends a request through Adaptive Server/CIS and ECDA Option for ODBC to a DB2 UDB for iSeries database, which returns data or a message to the client. It also sends a request through Adaptive Server/CIS and ECDA Option for Oracle to an Oracle database, which returns data or a message to the client.

For descriptions of specific ECDA components used in the sample scenarios, see ECDA Components.