May 6, 2009

Attunity Oracle-CDC for SSIS

SQL 2008 Enterprise Edtion has a nice feature "change data capture"(CDC) which would reduce a lot of efforts when dealing with SCD2. However, your SQL 2005 may have to stay in production for a long while or you may not have 2008 Enterprise Edition, and you need to extract data from Oracle database. Here is a good news for you.

Attunity provide a simple solution for replicating and integrating Oracle data efficiently and in real-time using SSIS.

The following information is from Attunity:
"Attunity Oracle-CDC for SSIS addresses the key challenges that data integration teams face in addressing business and IT requirements. Using it, you can:

  • Simplify and accelerate CDC implementation
  • Deliver real-time information
  • Design efficient data integration solutions
  • Leverage existing SQL Server investments
  • Reduce resources and costs

"

More info can be found in its website
http://www.attunity.com/oracle_cdc_for_ssis


Although the tool is not free, I would like to try its trail version whenever I have an opportunity.

unable to update McAfee VirusScan Enterprise 8.5.0i

One day in the early April, I found my McAfee could not do an update.
Error message said McAfee Framework Service wasn't running. Actually it disappeared from Services list.

McAfee was reinstalled successfully with Framework Service, however it still was unable to connect the server to do an update.

After I compared a working copy of McAfee on another PC, I found out SiteMapList.xml didn't exist on my Windows XP - C:\Documents and Settings\All Users\Application Data\McAfee\Common Framework\.

My Vista had the same issue as well. The location is C:\ProgramData\McAfee\Common Framework

After SiteMapList.xml was copied over, it has been working well since then.