Oracle's website has its OEM version of Informatica PowerCenter 8.6, which supports the SQL Server database as Service Master DB:
Http://www.oracle.com/technology/global/cn/software/products/ias/htdocs/101320bi.html
The installation files (including server and client) 8.6> to 8.6 in the <informatica PowerCenter and PowerConnect adapters file1 section of the above page are file2 to hotfix4. There is a Oracle_all_os_prod.key file in the file2 Informatica powercenter 8.6.0 for Windows 32Bit directory for the licensing of the EVA version installation. Install server-side component installation steps:
1. Find the Install.bat in the powercenter_8.6.0_se_for_windows_32bitpc86_win32_x86 directory of File1, which will invoke the installer (. ServerWindowsDisk1InstDataVMinstall.exe). PowerCenter does not have a specially customized version for Win 7/win 2008, so you may encounter the following error when you install server-side components-> Create domain on Win7:
The installer able to create Domain but could not create the node.
Error:
Error message:
Cannot start Informatica Services. Use the ' error below and Catalina.out and Node.log in the ' Server/tomcat/logs directory on the Nformation. Select Retry to continue the installation.
EXIT code:s
However, some of the binary and registry have been changed, even after the installation process, you must manually remove the PowerCenter from the Add/remove programs, delete the need reboot. After cleaning up the scene, you can change the install.exe to WinXP SP2 or Win2000 compatibility mode, and then reinstall, you can create domain normally.
2. Continue to install, after configuring Informatica service, still need to connect to this domain. But you will find that the Informatica service will automatically stop after 5 seconds of startup, so the installer ping domain cannot be completed. You can see the following error in the C:informaticapowercenter8.6.1servertomcatlog log:
2010-05-19 17:54:03,258 FATAL [main] [pcsf_10420] Failed to initialize the repository utility with native code because: [n o PMJREPN in Java.library.path].
Java.lang.UnsatisfiedLinkError:no PMJREPN in Java.library.path
The solution is to add the server's Bin directory to the system variable path (default is C:\Informatica\PowerCenter8.6.0\server\bin), do not need to reboot, this time to go to the list of services
Locate the Informatica service and start manually. Direct retry can be.
[2011-02-26 UPDATE]
If you install PowerCenter Server in the case of UAC on Windows 7, you will also need to enable the admin privilege for Installer.exe, as shown in the following illustration:
When you install the Informatica service to enter the services account, first choose to install with the current account (because the previous change in the Installer.exe property defaults to the current user settings only). If it is not set correctly, you may experience the following error while installing the Informatica service:
Informatica Services Startup
===========================
Current Time:2011-feb-26 21:49:32
Command executed
----------------
"C:informaticapowercenter8.6.0servertomcatbininfaservice.bat" Install "InformaticaServices8.6.0" "Informatica Services 8.6.0 "Informaticauser" "********"
Output of execution
-------------------
Output:installing the service ' "Informatica Services 8.6.0" ' on node Hu Jintao
Using Current_dir:c:informaticapowercenter8.6.0servertomcatbin
Using infa_home:c:informaticapowercenter8.6.0
The service ' "Informatica Services 8.6.0" ' has been installed.
error:the filename, directory name, or volume label syntax is incorrect.
The service name is invalid.
More help are available by typing NET helpmsg 2185.
Exitcode:2
removing Informatica Services
==========================
Current Time:2011-feb-26 21:49:32
Command executed
----------------
"C:informaticapowercenter8.6.0servertomcatbininfaservice.bat" Remove "InformaticaServices8.6.0"
Output of execution
-------------------
Output:removing the service ' Informatica Services ' on node ********
The service ' Informatica Services ' has been removed
Error:the service name is invalid.
More help are available by typing NET helpmsg 2185.
The filename, directory name, or volume label syntax is incorrect.
exitcode:0