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 |