DB2® DataPropagator leverages the SQL replication architecture to flexibly manage scheduling, transformation, and distribution topologies.
It efficiently and effectively populates data warehouses or marts, maintaining data consistency between disparate applications, or efficiently managing distribution and consolidation configurations involving central locations and distributed branch or retail sites.
The replication server supports distribution (moving data from one database to many) and consolidation (moving data from many databases to one) scenarios.
Data can be filtered either horizontally or vertically so that only relevant data is replicated.
Transformation can be applied inline with the data movement via standard SQL expressions or stored procedure execution.
Data movement can be automated on a specific schedule, at designated intervals, continuously, or event-driven.
Data movement can be managed table-at-a-time such as for warehouse loading during batch windows or with transaction consistency for data which is never offline.
