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.

Apr 13, 2009

Issues to access SQL Server in Oracle SQL Developer

1. Failed when tried to connect to a SQL server.

Error Message: Status: Failure -I/O Error: SSo Failed: Native SSPI library not loaded. Check the java.library.path system property.

Fix: Copy \x86\SSO\ntlmauth.dll to \jdk\jre\bin

2. How to connect a named SQL server instance.

In SQLServer tab:

Hostname:
Port: /;instance=

Ex: 1433/EDW_SA;instance=edw_dev

Seems it(1.5.4) doesn't support schema.

Feb 20, 2009

SQL 2005 installation failure on XP SP3

SQL 2005 and management studio tool cannot be installed on XP with SP3 applied.

Problem: MSXML 6.0 sp2 backward compatibility issue.

Error: Product: MSXML 6 Service Pack 2 (KB954459) -- Configuration failed.

Workaround:

1. uninstall msxml 6.0 sp2. If cannot, remove its entry in Registry.
2. Before removing it from Registry, do a backup first.
3. SQL 2005 should be able to be installed successfully.
4. patch SQL to the latest SP.
5. install MSXML 6.0 SP2.

Also refer to the following post:
http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/97c58e05-c61b-4f29-8507-f83f437c6f1d/

Feb 11, 2009

TDWI Search Plugin for Mozilla Firefox


<[[CDATA

]]>

TDWI Search Plugin Install TDWI Search Plugin to search the TDWI.org site.