Book description
To make better informed business decisions, better serve clients, and increase operational efficiencies, you must be aware of changes to key data as they occur. In addition, you must enable the immediate delivery of this information to the people and processes that need to act upon it. This ability to sense and respond to data changes is fundamental to dynamic warehousing, master data management, and many other key initiatives. A major challenge in providing this type of environment is determining how to tie all the independent systems together and process the immense data flow requirements. IBM® InfoSphere® Change Data Capture (InfoSphere CDC) can respond to that challenge, providing programming-free data integration, and eliminating redundant data transfer, to minimize the impact on production systems.
In this IBM Redbooks® publication, we show you examples of how InfoSphere CDC can be used to implement integrated systems, to keep those systems updated immediately as changes occur, and to use your existing infrastructure and scale up as your workload grows. InfoSphere CDC can also enhance your investment in other software, such as IBM DataStage® and IBM QualityStage®, IBM InfoSphere Warehouse, and IBM InfoSphere Master Data Management Server, enabling real-time and event-driven processes. Enable the integration of your critical data and make it immediately available as your business needs it.
Table of contents
- Front cover
- Notices
- Preface
- Chapter 1. Introduction and overview
- Chapter 2. InfoSphere CDC: Empowering information management
-
Chapter 3. Business use cases for InfoSphere CDC
- 3.1 InfoSphere CDC techniques for transporting changed data
- 3.2 Data warehousing and business intelligence
- 3.3 Consolidation
- 3.4 Distribution
- 3.5 Database migration
- 3.6 Application integration
- 3.7 Integration with master data management
- 3.8 Integration with IBM Information Server
- 3.9 Operational business intelligence
- Chapter 4. Solution topologies
- Chapter 5. InfoSphere CDC features and functionality
- Chapter 6. Understanding the architecture
-
Chapter 7. Environmental considerations
- 7.1 Globalization with InfoSphere CDC
- 7.2 Firewall configurations
- 7.3 Log retention
- 7.4 Remote processing capabilities
-
7.5 Using InfoSphere CDC in resilient environments
- 7.5.1 InfoSphere CDC reachability: Virtual IP
- 7.5.2 InfoSphere CDC binary files and metadata for the Linux, UNIX, and Windows engine
- 7.5.3 InfoSphere CDC on a shared volume
- 7.5.4 InfoSphere CDC on separate nodes with a shared database
- 7.5.5 InfoSphere CDC on separate servers with separate databases
- 7.5.6 System i resilient environments
- 7.5.7 z/OS / Sysplex and InfoSphere CDC in resilient environments
- 7.6 Change management
- Chapter 8. Performance analysis and design considerations
-
Chapter 9. Customization and automation
- 9.1 Options for managing InfoSphere CDC
- 9.2 Management Console GUI
- 9.3 Management Console commands
- 9.4 InfoSphere CDC engine commands (CLI)
-
9.5 InfoSphere CDC API
- 9.5.1 Development environment setup
- 9.5.2 Contents of the api.jar file
- 9.5.3 Connecting to and managing the Access Server
- 9.5.4 Connecting to the data stores
- 9.5.5 Configuring InfoSphere CDC replication
- 9.5.6 Creating a subscription
- 9.5.7 Procedure for mapping tables
- 9.5.8 Table mapping example
- 9.5.9 Procedure for removing mapped tables
- 9.5.10 Table mapping removal example
- 9.5.11 Row and column filtering
- 9.5.12 Derived columns
- 9.5.13 Encoding conversions (before and after Version 6.5)
- 9.5.14 Operations and user exits
- 9.5.15 Common procedures (updating table definitions)
- 9.5.16 Deploying subscription changes and considerations
- 9.5.17 Starting, stopping, and monitoring subscriptions
- 9.5.18 Monitoring latency
- 9.5.19 Monitoring event logs using the API
- 9.6 Monitoring and integration with external monitoring solutions
- 9.7 User exits
- Appendix A. Single scrape events and errors
- Appendix B. Additional material
- Glossary
- Related publications
- Back cover
Product information
- Title: Smarter Business: Dynamic Information with IBM InfoSphere Data Replication CDC
- Author(s):
- Release date: March 2012
- Publisher(s): IBM Redbooks
- ISBN: 9780738436371
You might also like
book
Architecting and Deploying DB2 with BLU Acceleration
IBM® DB2® with BLU Acceleration is a revolutionary technology that is delivered in DB2 for Linux, …
book
InfoSphere DataStage Parallel Framework Standard Practices
In this IBM® Redbooks® publication, we present guidelines for the development of highly efficient and scalable …
video
Strata Data Superstream Series: Creating Data-Intensive Applications
As the scale of data continues to grow (alongside an ever expanding ecosystem of tools to …
book
DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition
The Easy, Visual Introduction to IBM DB2 Version 10.5 for Linux, UNIX, and Windows Foreword by …