Chapter 2: Sample solutions  Access to distributed data sources

Chapter 2: Sample solutions

Transparent access to local heterogeneous data stores

Profile

An insurance company has an application that processes claims and requires data from two sources: an DB2 UDB for AS/400 database and an Oracle database. The company uses DirectConnect for DB2 UDB to retrieve data from the DB2 UDB for AS/400 database and DirectConnect 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 the following components in ECDA:

Figure 2-1 illustrates this sample scenario.

Figure 2-1: Transparent access to local heterogeneous data stores

See “What does ECDA include?” for descriptions of specific components.





Copyright © 2005. Sybase Inc. All rights reserved. Access to distributed data sources

View this book as PDF