The Apply and Replicator Engines can process data from Connect CDC (SQData) capture agents running on any supported platform. The communication between Capture/Publisher and Engine is managed to ensure that only complete Units of work are committed to Targets ensuring data integrity between source and target.
- IMS
- Relational Databases (Db2, Db2/LUW and Oracle)
- VSAM Files
- Sequential File on any platform
The Apply Engine can also read and write to most other databases using ODBC including SQL Server, MySQL and PostgreSQL including cloud platforms such as AWS RDS PostgreSQL.
The Apply Engine scripting language can perform virtually any data filtering and transformation imaginable including bit level manipulation. It automatically performs source to target code page translation and can problematically produce reports describing its processing.
The Replicator Engine is designed to operate like a utility, either replicating identical Source/Target datastores (LIMITEDto Db2/z and Db2/LUW today) or replicating IMS and Db2/z data to streaming targets like Kafka and HDFS without any "record level" instructions or manual scripting. In the case of Db2/z the Replicator automatically adapts to source table alterations, modifying JSON schemas automatically or if AVRO is specified, maintaining the Confluent Schema Registry.