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
ft:lastEdition
2024-09-05
ft:lastPublication
2024-09-05T15:00:09.754973

Adding a new Engine on the target platform requires, in the case of Linux only parsing of the new Engine script once the platform's Engine Controller Daemon has also been configured. In our example the new Engine is named IMSTOORA.

The actions performed by an Engine are described by an Engine Script. In this example the script will specify only simple mapping of fields in a COBOL copybook layout to columns in a the target relational table. See the Engine Reference for all the options available through Engine Script commands and functions.

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

Syntax
 DATASTORE cdc://<host><:port>/<publisher_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.

<publisher_agent_alias>

Must match the alias specified in the Controller Daemon sqdagents.cfg file on that host.

<engine_agent_alias>

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

Example
 DATASTORE cdc://<host><:port>/imspub/IMSTOORA
 OF IMSCDC
 AS CDCIN
 DESCRIBED BY <description_name>
 ;