Parse SQL, Supported Operations, and Generated Records

The Oracle CDC Client origin generates records differently depending on whether the origin is configured to parse SQL queries:
Parsing SQL Queries
When the Oracle CDC Client origin parses SQL queries, it can create records for the following operations:
  • INSERT
  • DELETE
  • UPDATE
The origin generates records based on the Oplog operation type, the logging enabled for the database and tables, and the operations selected in the Operations stage property.
For example, if you specify Insert operations, the origin generates only Insert records, ignoring all Update and Delete operations.
The following table describes how the origin generates record data:
Oplog Operation Identification/Primary Key Logging Only Full Supplemental Logging
INSERT All fields that contain data, ignoring fields with null values. All fields.
UPDATE Primary key field and fields with updated values. All fields.
DELETE Primary key field. All fields.
When parsing the SQL query, the origin also includes CDC and CRUD information in record header attributes.
To parse the SQL query, on the Oracle CDC tab, select the Parse SQL Query property. This property is enabled by default.
Then, configure the Operations property to specify the operations that you want to process.
Not parsing SQL queries

When the Oracle CDC Client origin does not parse the SQL query, it writes each LogMiner SQL statement to a field named sql. The origin also generates field attributes that provide additional information about field.

You might write LogMiner SQL statements to generated records to pass the queries to the SQL Parser processor to be parsed or to archive that information.

When not parsing the SQL query, the origin can create records for the following operations:
  • INSERT
  • DELETE
  • UPDATE
  • SELECT_FOR_UPDATE
The records are created based on the selected operations in the Operations stage property.
To write LogMiner SQL statements to generated records, on the Oracle CDC tab, clear the Parse SQL Query property.
Then, configure the Operations property to specify the operations that you want to include.