This article describes how to implement a database ingestion incremental load task that replicates change data from a Db2 for i source to a Snowflake Data Cloud target. It covers initial setup tasks for the Mass Ingestion environment and how to configure, deploy, run, and monitor a database ingestion task.
The use cases for replicating real-time change data from a mission-critical Db2 for i production system to a Snowflake data warehouse include:
Minimizing intrusive, non-critical work, such as offline reporting or analytical operations on the Db2 for i source database system.
Reducing costly CPU usage, disk space, and CDC processing time on the Db2 for i source database system.
Getting the latest database changes to your data warehouse in real time for downstream processing.
Migrating to a subscription-based Cloud environment.