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:
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 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. |
DATASTORE cdc://<host><:port>/oracdc1/ORATOSQL
OF UTSCDC
AS CDCIN
DESCRIBED BY <schema_name>.<new_table_name>
;