CDC-Enabled Stages

CDC-enabled stages provide the CRUD operation type in the sdc.operation.type record header attribute. Some origins provide alternate and additional header attributes.

The following stages provide CRUD record header attributes:
CDC-Enabled Stage CRUD Record Header Attributes
MapR DB CDC Includes the CRUD operation type in the sdc.operation.type record header attribute.

Includes additional CDC information in record header attributes.

For more information, see CRUD Operation and CDC Header Attributes.

MongoDB Oplog Includes the CRUD operation type in the sdc.operation.type record header attribute.

Can include additional CDC information in record header attributes, such as the op and ns attributes.

For more information, see Generated Records.

MySQL Binary Log Includes the CRUD operation type in the sdc.operation.type record header attribute.

Includes additional CDC information in record fields.

For more information, see Generated Records.

Oracle CDC Client Includes the CRUD operation type in both of the following headers:
  • sdc.operation.type
  • oracle.cdc.operation

For more information, see CRUD Operation Header Attributes.

Includes additional CDC information in record header attributes with the oracle.cdc prefix, such as oracle.cdc.table.

PostgreSQL CDC Client Includes the CRUD operation type in the record.

Includes additional CDC information in record header attributes with the postgres.cdc prefix, such as postgres.cdc.lsn.

Salesforce Includes the CRUD operation type in the sdc.operation.type record header attribute.

For more information, see CRUD Operation Header Attribute.

SQL Parser Includes the CRUD operation type in both of the following headers:
  • sdc.operation.type
  • oracle.cdc.operation

For more information, see Generated Records.

SQL Server CDC Client Includes the CRUD operation type in the sdc.operation.type record header attribute.

Includes CDC information in header attributes named jdbc.<CDC column name>. For more information, see Record Header Attributes.

SQL Server Change Tracking Includes the CRUD operation type in the sdc.operation.type record header attribute.

Includes additional information from change tables in the jdbc.SYS_CHANGE header attributes. For more information, see Record Header Attributes.