Database support for CDC - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13

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