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.
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:
ASE/CIS
ECDA Option for ODBC (with the IBM DB2 UDB ODBC driver)
ECDA Option for Oracle
Figure 4-1 illustrates this sample scenario.
Figure 4-1: Transparent access to local heterogeneous data stores
In Figure 4-1, the client application sends a request through ASE/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 ASE/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”.