A securities company requires an immediate customer profile when the broker receives a call from the customer. The broker client application immediately brings up the customer profile based on the telephone number of the caller. This data is stored in the Oracle database at the local work group’s office in Memphis and is updated through ECDA Option for Oracle. Real-time feeds from outside the system are stored in DB2 UDB on a zSeries host located in New York and are accessed by ECDA Option for ODBC. Client inquiries regarding other investments and current prices need to be queried off the zSeries host and displayed within the broker client application
To set up transparent access to heterogeneous data stores, the securities company uses these two components in ECDA:
Sybase ECDA Option for Oracle
Sybase ECDA Option for ODBC, with an IBM DB2 UDB ODBC driver
This combination of components gives the securities company access to heterogeneous data stores.
Figure 4-2 illustrates this sample scenario.
Figure 4-2: Access to distributed data sources
In Figure 4-2, the client application sends a request through ASE/CIS and ECDA Option for Oracle to an oracle database, which returns data or a message to the client. It also sends a request through ASE/CIS and ECDA Option for ODBC to a DB2 UDB for zSeries database, which returns data or a message to the client.
For descriptions of specific ECDA components used in the sample scenarios, see “ECDA components”.
