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

Note: For AS/400, MySQL and Teradata, no schema is involved.

	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 – please let us know!

Leave your feedback here