A Paris retail company has just acquired another company in New York. It needs 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 needs to capture data changes and replicate them to other systems where they can be incorporated without having to re-code existing applications.
To set up bidirectional, enterprise-wide replication, the retail company uses these five components, which are available with Sybase Data Integration Suite Replication:
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
Figure 4-3 illustrates the sample scenario which integrates Oracle data with DB2 UDB for UNIX data.
Figure 4-3: Bidirectional, enterprise-wide replication
In Figure 4-3, 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.
For descriptions of specific ECDA components used in the sample scenarios, see “ECDA components”.
For more information about Replication Agent for DB2 UDB, Replication Server, and Replication Server Options, see “Related products and options”.
For more information about the DI Suite Replication component, see the Sybase Data Integration Suite Overview Guide.
