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. See the Installation Section for the applicable platform Installation instructions. Once the product is installed, the steps to configure the new Engine parallel those required to configure existing Engines .
In our example the new Engine is named DB2TOORA. The Engine script will specify only simple mapping of columns in a DDL description to columns in 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, 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 | 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 db2cdc. |
| <engine_agent_alias> |
Must match the alias provided in the "sqdconf add" command "--datastore" parameter when the Capture/Publisher is configured to support the new target Engine. |
DATASTORE cdc://<host><:port>/db2cdc/DB2TOORA
OF UTSCDC
AS CDCIN
DESCRIBED BY <schema_name>.<table_name>
;