An example that integrates systems from of two separate companies.
Profile
A Paris retail company has acquired company in New York, and must to integrate its Oracle data with the DB2 UDB for UNIX data of the acquired company as quickly as possible to share information such as customer profiles and orders. The company must capture data changes and replicate them to other systems where they can be incorporated without having to re-code existing applications.
Sybase Components
To set up bidirectional, enterprise-wide replication, the retail company uses these components:
- ECDA Option for ODBC (to be used with an IBM ODBC Driver)
- ECDA Option for Oracle
- Sybase Replication Agent for Oracle
- Replication Agent for DB2 UDB
- Replication Server
Sample Scenario
Data stored in a DB2 UDB database for UNIX is sent through Replication Agent for DB2 UDB to Replication Server 1 and Replication Server 2, which replicate the information into Oracle through ECDA Option for Oracle to the Oracle database. Data from the Oracle database is then sent through Replication Agent for Oracle to Replication Server 2 and Replication Server 1, which replicate the information into DB2 UDB through ECDA Option for Oracle using an IBM ODBC driver to the DB2 UDB for UNIX database.