Attunity SQL Server-CDC for SSIS Tutorial

Attunity SQL Server-CDC for SSIS Tutorial
A step-by-step sample of an SQL Server CDC solution
This document outlines a simple and easy to follow tutorial that demonstrates how to
use the Attunity SQL Server-CDC for SSIS in order to implement a data integration
solution based on capturing changes made to a selected SQL Server database.
This tutorial uses a sample TPCD database that you create using the SQL Server
Management Console. You create the database tables and populate them with data
from a script that is downloaded from the Attunity FTP site. This tutorial can be
completed in about 30 minutes. It is easiest to run this sample on a stand-alone and
default SQL Server database installation.
This tutorial takes you through the following steps:
■ What You Need
■ Create the Source TPCD Database
■ Creating a New SSIS Project
■ Configuring a new CDC Service
■ Building Packages (Full Load and CDC)
■ Viewing the Generated Packages and Tables
■ Testing the Solution
■ Summary
What You Need
To work with this tutorial, make sure that you have the following.
■ Source SQL Server database (2000 or 2005) with a database called TPCD
Note: You need to create this database in your SQL Server source and then
populate it with the correct tables. A script that creates the tables is available from
the Attunity FTP at the following link:
ftp://ftp.attunity.com/public/source/sqltpcd/SQL_Server_
TPCD.sql
■ Target SQL Server database (2005 or 2008) with:
– The default tempdb system ...