Database support for CDC
The CDC feature is available for the following databases: AS/400, DB2, Informix, Ingres, MS SQL Server, MySQL, Oracle, PostgreSQL, Sybase, and Teradata. Note that the CDC feature works only with database systems running on the same server.
The following table provides information about the database support for CDC. As explained in the CDC architectural overview, the CDC feature captures the updated data from a Source database and sends the captured data to a Change table, where the Talend Studio Job reads the data from.
|
Source database |
Change table with the same database as the source |
Change table with a different database from the source |
|---|---|---|
|
AS/400 |
Supported |
Supported |
|
MySQL |
Supported |
Supported |
|
Teradata |
Supported |
Supported |
|
|
Change table with the same database as the source |
Change table with a different database from the source |
||
|---|---|---|---|---|
|
Source database |
Same schema (table) |
Different schema (table) |
Same schema (table) |
Different schema (table) |
|
DB2 |
Supported |
Supported |
Unsupported |
Unsupported |
|
Informix |
Supported |
Supported |
Unsupported |
Unsupported |
|
Ingres |
Supported |
Unsupported |
Unsupported |
Unsupported |
|
MS SQL Server |
Supported |
Supported |
Supported |
Supported |
|
Oracle |
Supported |
Supported |
Unsupported |
Unsupported |
|
PostgreSQL |
Supported |
Supported |
Unsupported |
Unsupported |
|
Sybase |
Supported |
Supported |
Supported |
Supported |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!