Add new engine - connect_cdc_sqdata - Latest

Connect CDC (SQData) Change Data Capture

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Change Data Capture
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:05:48.570404

New Engines added to an existing Capture may run on an existing Engine platforms or a new one often depending on the Target that the Engine will write to. A new Engine platform will require installation of the Connect CDC (SQData) product. Once the product is installed, the steps to configure the new Engine parallel those required to configure existing Engines.

In the example, the new Engine is named ORATOSQL. The Engine script will specify only simple mapping of columns in a DDL description to columns in the target relational table. See Apply Engine commands and Apply Engine functions for all the options available.

While not as simple as straight replication due to potentially different names for corresponding columns, the most important aspect of the script will be the DATASTORE specification for the source CDC records:

Syntax
DATASTORE cdc://<host><:port>/<capture_agent_alias>/<engine_agent_alias>
Keyword and Parameter Descriptions
Keyword Description
<host> Location of the Capture Controller Daemon.
<:port> Optional, required only if non-standard port is specified by the service parameter in the Controller Daemon configuration.
<capture_agent_alias>

Must match the alias specified in the Controller Daemon agents configuration file. The engine will connect to the Controller Daemon on the specified host and request to be connected to that agent. In our example we have used oracdc.

<engine_agent_alias>

Must match the alias provided in the "sqdconf add" command "--datastore" parameter when the Capture/Publisher agent is configured to support the new target Engine.

Example
DATASTORE cdc://<host><:port>/oracdc1/ORATOSQL
         OF UTSCDC
         AS CDCIN
         DESCRIBED BY <schema_name>.<new_table_name>
        ;