Course description: Introduction to InfoSphere Change Data Capture How to Use CDC WBT

Note: This is a self-paced online course. This course usually requires 5 hours to complete.

This course will put you in charge of the subscription development process and requires that you interact with CDC, DB2, and SQL Server environments within the tutorial's 'guided tour simulation' environment. You will learn by doing and benefit from expert instruction as you go.

This course begins by defining the CDC product. Next it discusses the components of CDC and the terminology used. It then discusses different modes or scenarios of replication. It talks about administration and how to set up CDC. Then It talks about setting up a subscription and the steps involved. It also gets into some details about mapping tables and columns.

In a Guided Tour Product Simulation, you will do some basic administration and set up some subscriptions. After performing a non-continuous, basic refresh subscription (Simple Standard Replication), you will then go on to create a number of continuous subscriptions. Overall, you will create the following types of subscriptions:

• Simple Standard Replication
• Simple Auditing
• Advanced Standard Replication
• Four types of Complex Update Subscriptions:
  • Adaptive Apply
  • Summarization
  • Consolidation One-to-One
  • Consolidation One-to-Many

Note: This is a self-paced online course in which the Guided Tour Product Simulation requires no installations: Everything is through your IE 5.0+ browser. Please DO NOT make travel arrangements for this course. After you receive confirmation that you are registered, just follow the instructions to access the course.

This browser-based product simulation let's you "learn-by-doing" in a case-study scenario in which you solve a 'real-life' business problem - no installations needed just a browser and a passion to learn.

By the end of this training you'll have a better understanding of this InfoSphere product's terminology, an overview of its architecture, and a better understanding of how it can be implemented.

You can learn more about the FlexLearning library:

http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=page&c=a0011797

USA IBM Training Registrar:

Phone: (978) 899-2188

Fax: (978) 899-2188

e-mail: iiseduc@us.ibm.com

View this course in other countries

Training Paths that reference this course are:

• Change Data Capture (CDC)
• InfoSphere Overview - FlexLearning Library

Back to top

IBM Education Advantage Program Eligibility

• Yes - IBM Education Pack - Online account

Back to top

This basic course is for:

• DBA (Database Administrators)
• Application Programmers and Developers
• People Tasked with Populating Data Warehouses
• People Tasked with Setting Up Replication
• Integration Teams, Team Leads, and Project Managers
• Migration Teams

Back to top

You should have:

• Knowledge of SQL
• Understanding of Relational Database Concepts
• Experience with any Relational Database

Back to top

• Become familiar with the terminology and navigation of the CDC product
• Understand the components of the CDC product and where they reside
• Set up and administer Datastores and users and conduct basic configuration and administration
• Define what data is accessed and which users can access it

In a practice environment:

• Do a simple refresh
• Set up replication subscriptions in both refresh and in Real Time
• Perform replications as a snapshot or instant refresh
• Perform replications in the more common scenario of continuously replicating (Constantly tracking changes to the DB to a particular table and moving those changes (implementing those changes) in some target table
• Create a variety of subscriptions including a refresh, a continuous audit, a continuous custom subscription, and perform details such as mapping tables and columns, performing simple derivations and transformations of data, and the like
• Use the product to understand how to set up relationships between source and target tables for replication

Back to top

• Introduction
• What is Change Data Capture?
• Business Use Cases
• CDC Concepts
• Components of CDC
• An Overview of InfoSphere CDC
• Data Replication Terminology
• 3 Steps for Setting Up Security
• Replication Set-up
• Logical Subscriptions
• 5 Steps to Set Up Replications
• Guided Tour Product Simulation Perform Administrative Tasks
• Understand the Data in the Database
• Create a Non-Continuous Refresh Subscription
• Create a Continuous Audit Subscription
• Create a Standard Custom Subscription Perform Filtering
• Map Columns
• Create Expressions
• Derive Columns
• Perform Translations
• Complex Update Subscriptions: Advanced Create an Adaptive Apply Subscription
• Create a Summarization Subscription
• Consolidation One-to-one Subscription
• Consolidation One-to-many Subscription

Back to top

• Mandatory: Learners must have a screen resolution set to a minimum of 1024 x 768 (1200 x 1400 recommended) and an IE 5.0+ browser

Back to top