BEGIN:VCALENDAR
X-ORIGINAL-URL:http://channel9.msdn.com/Events/TechEd/NorthAmerica/2012/DBI322
VERSION:2.0
METHOD:PUBLISH
BEGIN:VEVENT
DESCRIPTION;LANGUAGE=en;CHARSET=utf-8:Exploring real-world customer scenarios, we take a look at how the new Change Data Capture (CDC) components for SSIS in Microsoft SQL Server 2012 simplify incremental ETL and Data Warehouse loads. We demo the new functionality in SSIS, and show off how the new tools make it easy to set up and configure CDC against both SQL Server and Oracle sources. We present the different CDC configuration options, and demonstrate design patterns that can be used to overcome common problems you’ll face while doing incremental loading of data. If your ETL solution needs to handle incremental loads from data sources that were designed explicitly to support them, then this is a session you can’t afford to miss. #TEDBI322
LOCATION;LANGUAGE=en;CHARSET=utf-8:
SUMMARY;LANGUAGE=en;CHARSET=utf-8:Incremental ETL Using CDC for SQL and Oracle with SQL Server Integration Services (SSIS) 2012
CONTACT;LANGUAGE=en;CHARSET=utf-8:Matt Masson
UID:Code: DBI322
X-ALT-DESC;FMTTYPE=text/html:Exploring real-world customer scenarios, we take a look at how the new Change Data Capture (CDC) components for SSIS in Microsoft SQL Server 2012 simplify incremental ETL and Data Warehouse loads. We demo the new functionality in SSIS, and show off how the new tools make it easy to set up and configure CDC against both SQL Server and Oracle sources. We present the different CDC configuration options, and demonstrate design patterns that can be used to overcome common problems you’ll face while doing incremental loading of data. If your ETL solution needs to handle incremental loads from data sources that were designed explicitly to support them, then this is a session you can’t afford to miss. #TEDBI322
DTSTART;VALUE=DATE-TIME:20120612T141500Z
DTEND;VALUE=DATE-TIME:20120612T153000Z
END:VEVENT
END:VCALENDAR