| Log-based Change Data Capture: Whether you integrate data in real-time or periodically, IBM® InfoSphere™ Change Data Capture captures only changed data and transfers it from publisher to subscriber systems. Rather than performing queries directly against the database, you can now capture changed data directly from the database logs. | Change data capture improves operational efficiency and saves time and resources by eliminating redundant data transfer and saving network bandwidth. Because it accesses data from the logs, InfoSphere Change Data Capture ensures top performance of your mission critical applications. |
| Multi-platform support without programming: Discover easy, programming-free data integration between IBM DB2® Universal Database™, Oracle, Microsoft® SQL Server, Sybase, Informix, Teradata, XML and DataStage for UNIX®, Linux™, Microsoft Windows®, IBM i, IBM System z. | With no programming required, existing programming staff can invest their time in IT projects that provide more value to your organization. Companies can make the most of their existing systems and integrate data throughout all supported platforms with no changes required in their current environment. InfoSphere Change Data Capture accommodates upcoming changes in your computing environment to help companies better prepare to meet the future. |
| Built-in transformation and filtering: Translate values. Derive new calculated fields. Join tables at the source or target. InfoSphere Change Data Capture lets you create, store and retrieve custom data transformations as macros. Row/column selection makes it possible for users to limit access to sensitive information, or to flow user-specific data to particular sites. Data stored in various character sets and languages can be seamlessly replicated to disparate platforms. | Make better decisions faster with a solution that massages, cleanses and filters corporate and customer data for enhanced data quality. Securely deliver sensitive data and make it accessible to authorized recipients only. |
| Direct peer-to-peer integration: Peer-to-peer architecture and native support for TCP/IP deliver direct database connectivity. No data staging or gateway technologies are required. | With this IBM solution, information flows in the most efficient and fastest path: directly between source and target systems. Strengthen your organization’s ability to deliver information to employees. Help them make intelligent business decisions based on the most current information. |
| Extended update options: “Adaptive apply” will take operations that occurred on the source table and merge / upsert changes to a target table, regardless of the absence or presence of the source row in the target table. Use "Live audit" capability to keep a history of all changes made to source tables with information including the user and program identities who made the change. Users can summarize numerical data from multiple rows in one or more source tables into a single row in a target table. Row consolidation lets users merge data from multiple source tables into one or more rows in a target table. | Extended update options provide more flexible replication capabilities in data warehousing environments. Expect better database design, lower processing power and storage capacity requirements, and easier querying and reporting. |
| Package data as a message: InfoSphere Change Data Capture can monitor transactional systems for specific transactions and package that information as a single XML message to target a specific message queue. | Get the right information to the right people—fast. With this IBM solution, critical data can be packaged with additional information from other systems and passed to a message queue that’s based on business rules. This triggers or applies the appropriate business process. |
| High-performance communications: Experience fine-tuned architecture that optimizes communications between source and target systems. Changed data is efficiently transmitted, including large object binaries (LOBs) such as multi-media audio and video data. | Improve integration network performance. Make efficient use of available bandwidth. Minimize the manual intervention required for setup and maintenance of the network. |
