- Distributing data to many targets
- Consolidating data from many sources
- Feeding changed data to warehousing, business intelligence, and ETL tools such as InfoSphere DataStage
However, there are times when IBM's Q Replication is the better choice. Primarily, Q Replication should be used when you need one or more of the following:
- The lowest latency of data at target systems
- Highly scalable replication for large volumes of changed data
- Multi-way replication with robust conflict detection and resolution
- Continuous availability or disaster recover
- Load balancing across databases
- The lowest impact on source systems
In other words, Q is the way to go for availability and high performance solutions.
Other posts in this thread:
- Which IBM products contain Q and SQL Replication?
- What is the difference between InfoSphere Replication Server and the IBM Homogeneous Replication Feature?