Script Structure and Syntax |
Scroll |
The Replicator Engine utilizes a very simple Configuration Script syntax with none of the additional "Parts" files used in an Apply Engine script. No source or target DESCRIPTIONS are required because the SQData Relational Capture agent (initially only z/OS Db2) will utilize the source relational database catalog and subsequent source database maintenance "ALTER TABLE" activity to provide the source Table schema information to the Replicator Engine. The Replicator Engine can similarly interact with the Confluent Schema Registry to maintain the time sequenced Kafka AVRO schemas. No "CDCPROCs" (change data mapping procedures) are required because the entire before and after content of the source Table will be replicated.
Configuration Script Syntax Summary
REPLICATE Specifies the source of input and the type and format of the replicated output
OPTIONS Specification of certain global behavior and tuning parameters
MAPPINGS both Static and Dynamic, explicitly specifies the link between source record types and the identifying characteristics of the target records as well as how new and unexpected source data is to be handled.
Note, all statements terminate with a semi-colon.