This section provides information about the database support for CDC.
For more information about the CDC feature, see CDC architectural overview.
For more information about setting up a CDC environment, see Setting up a CDC environment.
The CDC feature is available for AS/400, DB2, Informix, Ingres, MS SQL Server, MySQL, Oracle, PostgreSQL, Sybase and Teradata.
Databases |
Same Database |
Different Database | ||
---|---|---|---|---|
AS/400 |
Yes |
Yes | ||
MySQL |
Yes |
Yes | ||
Teradata |
Yes |
Yes |
Note
For AS/400, MySQL and Teradata, no schema is involved.
|
Same Database |
Different Database | ||
---|---|---|---|---|
Databases |
Same Schema |
Different Schema |
Same Schema |
Different Schema |
DB2 |
Yes |
Yes |
No |
No |
Informix |
Yes |
Yes |
No |
No |
Ingres |
Yes |
No |
No |
No |
MS SQL Server |
Yes |
Yes |
Yes |
Yes |
Oracle |
Yes |
Yes |
No |
No |
PostgreSQL |
Yes |
Yes |
No |
No |
Sybase |
Yes |
Yes |
Yes |
Yes |