The Apply engine reads from and writes to any type of datastore.
The Apply Engine is a component that reads from and writes to any type of datastore (file, hierarchical or relational database, VSAM file, message queue, or TCP/IP port). The apply engine can run on mainframe, Linux, or Windows and is the full-featured, general-purpose client. It can work with any combination of source and target, and can apply any filtering or transformation logic (using its scripting language). You need to use the apply engine if you have a source or target that is not supported by the replicator, or if you need to apply any business logic to the data during replication.
The Apply Engine is controlled by an SQL like scripting language with a very rich syntax providing a wide range of operations ranging from replication of identical source and target structures using a single command to complex business rule based transformations. Connect CDC (SQData) Apply Engine commands and functions provide full procedural control of data filtering, mapping and transformation including manipulation of data at its most elemental level if required.
There are two (2) engines available to apply changes to target systems, the apply engine and the replicator.
It can interpret virtually any type of data structure including all forms of relational DDL, COBOL copybooks, JSON and comma delimited files. The most common function performed by an Engine however, is to process data published by a Change Data Capture (CDC) component, applying business rules, if necessary to transform that data and efficiently write AKA Apply that data to a Target datastore of any type on any operating platform.
The Apply Engine is controlled by an SQL like scripting language with a very rich syntax providing a wide range of operations ranging from replication of identical source and target structures using a single command to complex business rule based transformations. Connect CDC (SQData) Apply Engine commands and functions provide full procedural control of data filtering, mapping and transformation including manipulation of data at its most elemental level if required.
The graphic below is a representation of the Apply Engine for Db2z.
