business intelligencebusiness intelligence data integration
Home > Products > InfoSphere Change Data Capture > Features and BenefitsEmail this page to a frienddata protectionPrint this page
     
  InfoSphere Change Data Capture - Features and Benefits

Key Product Features: Business Benefits:
Log-based Change Data Capture
Whether data is integrated in real-time or periodically, only changed data is captured and transferred from publisher to subscriber systems. Rather than performing queries directly against the database Information Server Change Data Capture captures 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. By accessing data from the logs Information Server Change Data Capture ensures there is no performance impact on mission critical applications.
Zero Programming/Multi-Platform Support
Out-of-the-box, programming-free data integration between DB2 UDB, Microsoft SQL Server, Oracle, Sybase, Teradata, XML, and PointBase across UNIX, Linux, Microsoft Windows NT/2000/XP/2003, IBM OS/400, OS/390 and z/OS. Flat file integration is also supported.
With zero programming required, existing programming staff can invest their time in higher value-added IT projects. Companies can leverage their legacy systems and integrate data across all supported platforms without making changes to their existing environment. Future changes in the computing environment can also be easily accommodated to future-proof your investment.
High-Performance Communications
Fine-tuned architecture for optimizing communications between source and target systems. Supports the efficient transmission of data, including large object binaries (LOBs) such as multi-media audio and video data.
Improve integration network performance and robustness, and make efficient use of available bandwidth. Minimize manual intervention required for setup and maintenance of the network.
Built-in Transformation and Filtering
Translate values, derive new calculated fields, join tables at the source or target, and more. Create, store, and retrieve custom data transformations as macros. Row/column selection allows users to limit access to sensitive information or flow user-specific data to particular sites.
Massage, cleanse and filter corporate and customer data for enhanced data quality and more accurate decision making. Ensure sensitive data is securely delivered and accessible to only authorized recipients.
Direct Peer-to-Peer Integration
Peer-to-peer architecture and native support for TCP/IP ensure direct database connectivity. No data staging or gateway technologies are required.
Ensure information flows in the most efficient and fastest path directly between source and target systems. Maximize information delivery to employees, allowing them to make intelligent business decisions based on the most current information.
Management Console
A graphical tool for viewing and monitoring the integration network through user-defined views. The Monitor actively pulls and displays replication metrics, such as status and latency, providing an up-to-date health check of the system.
Monitor complex integration networks at various levels of granularity to better understand the health of your network and accelerate problem determination and resolution. Easily create, copy, re-use, or delete user-defined network diagrams, saving time and increasing efficiency.
Extended Update Options
Summarization allows users to summarize numerical data from multiple rows in one or more source tables into a single row in a target table. Row consolidation allows users to merge data from multiple source tables into one or more rows in a target table. Adaptive apply gives users the option to specify that the same operation that occurred on the source table will be applied to the target table, regardless of the absence or presence of the source row in the target table.
Extended update options provide more flexible replication capabilities in data warehousing environments, resulting in better database design, lower processing power and storage capacity requirements, and more ease of use in querying and reporting.
Role-Based Security
Assign each Management Console user to one of four roles, which differ according to the range of operations that can be performed.
User access to a replication can be confined to just monitoring or expanded to also allow modifications to a configuration, allowing you to distribute administrative duties while maintaining control.