Change Data Capture Addition with R2
With SQL Server 2008 R2, Microsoft has introduced some additional capability around grabbing changes from tables as a part of SSIS. A series of new adapters are now available from Attunity; they have implemented a streaming agent that detects changes in several different database platforms and makes these changes available to SSIS package processing. Attunity CDC products for SQL Server Integration Services provide end-to-end operational data replication (ODR) solutions for many heterogeneous sources. Using these products, you can enable efficient and real-time data warehousing, set operational business intelligence requirements, replicate data from one source to another, and synchronize two or more data ...
Get Microsoft® SQL Server 2008 R2 Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
