The CDC (Capture Data Changes) Provider Sybase Replication Server component is used for implementing incremental load. It:
Receives data changes from Sybase Replication Server, translates them to an ETL standard data flow, and then sends the data out to the next component.
Automates the process of configuring Sybase Replication Server, which includes marking the source table as replicated, creating or dropping replication definitions, connections, and subscriptions. This entire process is termed as Creating or Dropping Replication, and it enables Replication Server to start or stop capturing source table data changes.
CDC Provider Sybase Replication Server component only
supports ASE and Oracle as the source database.
Before configuring the CDC Provider Sybase Replication Server component:
Install Replication Server.
You need not install Replication Server and ETL Server
on the same machine.
Allocate sufficient disk space for the Replication Server partition. See Chapter 3, “Replication Server Commands,” in the Replication Server 15.2 Reference Manual.
Configure the Replication CDC Service:
Edit the interfaces files for the source database, Replication Server, and ETL Server. See “Updating the interfaces files for the source database, Replication Server, and ETL Server”.
Configure the Replication CDC Service Name for each ETL Server. See “Configuring Replication CDC Service name for each ETL Server”.
If the source database is Adaptive Server® Enterprise, use rs_init to add the source database to the Replication Server. See the Replication Server Configuration Guide.
If the source database is Oracle, see “Configuring Oracle as a replication source”, on how to add Oracle to the Replication Server.
