Nov
3
2009

CDC for heterogeneous sources with SSIS, from Attunity and Microsoft

See the press release from yesterday (11/2/2009): Attunity extends its partnership with Microsoft to enable heterogeneous Change Data Capture Some excerpts: The solution, based on Microsoft’s SQL Server Integration Services (SSIS) and Attunity’s low-impact change data capture (CDC) technology, enables efficient and real-time integration of heterogeneous data with significant cost savings. ... The integrated offering of Attunity’s CDC with Microsoft’s SSIS is now available for many... [More]
Nov
10
2008

Learn more about using Change Data Capture (CDC) in SSIS 2008

SQL Server 2008 Enterprise includes the new Change Data Capture feature, or CDC, largely intended for use by ETL developers performing incremental loads of a data warehouse. With CDC, you can easily identify rows that have been inserted, updated, or deleted -- no more need for complex queries and other custom solutions! The other day I promised links to some resources, and now they're finally all online. Try the 2 new end-to-end samples on Codeplex Sandra Ward, the developer of CDC, has done extraordinary w... [More]
Nov
5
2008

InfoWorld praises Lookup caching, CDC in SSIS 2008

Read what Sean McCown of InfoWord says about the benefits of Lookup caching and Change Data Capture for the enterprise. "Microsoft has taken some big steps to ensure that SSIS (SQL Server Integration Services) can compete directly with competitors such as Informatica by offering lookup caching and CDC.  ...both lookup caching and CDC can improve the speed of loads by orders of magnitude." InfoWorld praises Lookup caching, CDC in SSIS 2008 How can you learn more about the new features in Lo... [More]