netezza -> S3 copy

SCT can use Netezza as a source for the "schema" only, not the actual data. DMS uses Change Data Capture (CDC) to keep a source and a target synchronized. Netezza is not a source for DMS, because the CDC relies on logs, which Netezza does not use for transaction control. So, Netezza cannot be "synched" with a target using DMS.

The work-around is to have the ETL systems that are loading Netezza write to a second target, in this case SAP, so that the data changes can be applied to each independently. There is a lot of complexity in making sure there is no split-brain, where the systems become unsynchronized. This is mitigated by using Audit/Balance/Control mechanisms in the ETL. This ABC will likely need to be built as net-new for this migration--most Netezza customers do not have ABC built into their ETL architecture.

Sending the changes to S3 is not recommended, because they usually contain UPDATE and DELETE requests, which S3 cannot support. The target needs to be able to perform these (in addition to INSERT) in a preserved order, to ensure the two databases are equivalent/synchronized.

Some customers perform this synchronization in low-latency form, others prefer to update the second target in batches, but the order of the transactions matters and so they must be performed in alignment with that strategy.