Recently I installed Informatica v9.6.1 and Oracle 11g (for repository database) on a windows 7 virtual machine on my macbook air. Here I will be sharing a step by step guide on how you can also install latest Informatica PowerCenter software for personal use. I am assuming you already have a windows 7 machine, either virtual or dedicated, hence I will be leaving it out of this guide.
As this is a long process I am dividing this guide into 6 parts. Each covering one of the below topics needed for the installation.
- How to get and unpack the legitimate copies of the software packages
- How to install Oracle 11g and create a database for Informatica repository and domain (see Part 2)
- How to install Informatica 9.6.1 server software (see Part 3)
- How to install Informatica 9.6.1 client software (see Part 4)
- How to create Informatica repository and integration services(see Part5)
- How to test whether the setup is working (see Part 6)
So we start with the first step
How to get and unpack the legitimate copies of the software packages for free
STEP1:- Head over to the Oracle cloud delivery link:- Oracle Coud Delivery
STEP2:- Sign In if you already have an account or register for free if you don’t have one
STEP3:- After logging in accept the terms and conditions then select the following options in the subsequent screen
STEP4:- Download Oracle 11g by selecting options as shown in the screenshot below. Use 32 bit software if you have a 32 bit windows
Press Go and you will get following options, select the one highlighted below
Download the below two packages from the next screen
It will take a while to download, meanwhile follow next steps to get the Informatica package 9.6.1.
STEP5:- Download Informatica 9.6.1 package from the same Oracle Cloud delivery portal as in step 1
STEP6:- Select the options as shown in the following screenshots to get the PowerCenter 9.6.1 package
Press Go and select following from subsequent screen
Then download the following four files from the list in subsequent screen
This is an even bigger download than the Oracle package and it may take a while before you are ready for the unpacking of the software
STEP7:- After the Oracle 11g files are download unpack the package. You will have two files which you need to select together and unzip into the same folder. Ignore if there are any errors and just skip to next file.
Select both the files and unzip into same folder
You will get a folder named database in the directory containing the zip files. Go inside the database folder and you will see the setup file
You can run the setup file now and follow the instructions in the Part 2 of this post. Remainder of this post will describe unpacking the Informatica 9.6.1 package which is bit more involved process than the Oracle unpacking
STEP8:- Unpacking Informatica PowerCenter 9.6.1 package. You would have downloaded following four files as part of Step6 above
Select all four files and unzip into the same folder. You will get following four files after unzipping. There will be one more zip and three accompanying files
Unzip the zipped file into the same folder. This will use the other three files during the unzipping process. Ignore and skip if there are any errors during unzipping. You will get the following 5 files in your directory
Oracle_All_OS_Prod.key – This is the never expiring license file for the Informatica PowerCenter 9.6.1 package. We will need this while installing the server file
961_Server_Installer_winem-64t – This zip file contains the server software which we need to install to run the Informatica PowerCenter Server. Unzip the file into a subdirectory named InfaServer (create new) to get the following files in it. We will use the install file in this directory to install the server. Please refer Part 3 of this post to find instruction for installing the server.
961_Client_Installer_win32-x86 – This zip file contains the client software (Designer, Monitor, Workflow Manager etc). We will install this after installing the server software. Unzip the file into a subdirectory named InfaClient (create new) to get the following files in it. We will use the install file in this directory to install the Informatica clients. Please refer to Part 4 of this post to find instructions for installing the clients.
This concludes Part 1 of this Post. We are ready with all the installer files to install PowerCenter 9.6.1 on our windows 7 machine.
Please follow Part 2 of this post to start the Oracle 11g installation and configure the database to be used as Informatica Repository.
You can write to me at raghavatalblog@gmail.com or follow me on twitter @atalraghav
See you there!!
This is the most complete and accurate guide on how to download the Informatica v9.6.1 PowerCenter on Windows 7 64 bit machine and how to unzip it and prepare it for an installation.
Helped me tremendously.
Thank you.
Great to hear that it helped!! thanks
Hi,
Can you send me the license key alone.
Thanks in advance.
-Shibin
Hi,
Thanks for the tutorial. But I got stuck at Step 8. while unzipping the last folder as shown above that use other .z files it gives me error ” the same volume cannot be used as both the source and destination”, Error 0x80004005. this error is for server and after skipping it, I am able to unzip client only.
Else if I am unzipping it into some other drive then its giving “please insert disk 2”
Thus I am unable to unzip all the files.
Kindly let me know where I am getting wrong.
Thanks,
Apeksha Agarwal
Please can you provide me more details on what exact steps you are taking while unzipping in step8. You can reach me out on my twitter account @atalraghav
Try using iZarc unzipper instead of Windows default unzipper.
Hello Raghav,
Thanks for the detailed explanation on Informatica Installation. I am facing exactly the same issue as Apeksha.
Please let me know if there is a solution.
Thanks
Gauri
Hi Raghav… I tried installing informatica PC9.6 on win10 but unable to get through. Would you please help me out
Hi Anil. Informatica 9.6.1 is yet not compatible with win10. Please try installing on win7. These instructions are for installing on win7 machine
Hello Raghav,
I succeeded in installing infa9.6.1 on windows 10 🙂 🙂
Thats great. Njoy 🙂
is 9.6 compatible with win 10? or did you follow any other steps.. please update
Can you help me install. I am facing some problems
Hello Anil, I am not able to install on Windows 10. Can you help me
Hi ragava,
I have done the installation of informatica power 9.6.1 for the first time during installation in windows 7. I got an error during 7th step in informatica server installation informatica administrator is not available. The domain was created successfully but the informatica administrator is not accessible. I have click continue once installation done I am not able to login admin page it shows like:
http status 404 -/administrator/
Can anyone help on this issue to get it resolved?
thanks
I have the same problem … anyone may help ?
Please check if Informatica service is running in the services.msc console. If not start the service before accessing the Admin Console page.
Please check if Informatica service is running in the services.msc console. If not start the service before accessing the Admin Console page.
Hi Narendra,
Pls check if you have WinHTTP service running.
If not, Go to Programs and Features->Turn on or off Windows features. Check the Internet Information Services. Under that the WorldWideWeb service is what you need.
Hi Narendra
Can you pls pind me the link from where u have downloaded powerCenter 9.6.1 for windows 7.
We are currently not been able to access it from the Oracle cloud delivery portal.When searching with ” Oracle Business Intelligence” we are not getting anything.
Any help wud be appreciated.
Hi Raghav,
You tutorial has been extremely helpful.
However I am stuck at this point where I am not able to connect to the oracle db repository from informatica.
I can see the following error in the log which says:
ora-12154 tns could not resolve the connect identifier specified
Any assistance would be highly appreciated.
Regards
Zubair
https://edelivery.oracle.com/EPD/WelcomePage/get_form – This link for oracle cloud delivery do not have the oracle 11g or i might be missing something. The screen shown in step 6 is not coming up for me. Have things changed at oracle website.. how to get the oracle 11g as showed above?? pls help
hi raghav ,
i clicked the accept in the edelivery but i am seeing a different screen from what u have posted i am not able to see oracle businees intelligence media but i am seeing a list of oracle programs like
“oracle business mobile
Oracle Business Intelligence Server Administrator etc
“there are so many like this which edition do i need to download
thank you
Hi Bhargav,
Even I faced the same issue. Things have changed a bit on the Oracle website. One can now download the Informatica files by selecting “Oracle Informatica PowerCenter and PowerConnect Adapters”. Rest of the things are same as Mr.Raghav explained.
You can also go through the following video as well.
https://www.youtube.com/watch?v=_cTMFvPZvp8
Thanks
Sukanya
Yes, Raghav. I am also facing the same issue.We are not able to find Oracle Business Intelligence Media Pack for Informatica.
pls help on on finding ” oracle business intelligence Data Warehouse Administration Console 11g for Microsoft Windows and Informatica PowerCenter
and PowerConnect Adapters 9.1 for Windows x86 (32-bit)”
Many Thanks.
Hello Raghav,
I am looking to install Informatica PC 9.6.1 on Windows 10 platform. As in Bhargav Chowdary’s case, even I am facing the same issue. I could see many things like OBI Foundation Suite, Standard Edition etc., but not able to figure out Oracle Business Intelligence as in the screenshot posted. . Could you help out, please?
Thanks
Sukanya
Thank You Raghav. This post was really very helpful!
Cheers,
Sukanya
Search for “Oracle Informatica PowerCenter and PowerConnect Adapters” and then select ‘Microsoft Windows x64 (64-bit)’ under platform section. Click ‘Continue’ you will get as show below.
Oracle Business Intelligence 11.1.1.7.0 for Microsoft Windows x64 (64-bit), 4 files
Oracle Informatica PowerCenter and PowerConnect Adapters Oracle Standard Terms and Restrictions 6.5 GB May 19, 2015
Hi,
Recently Informatica 64bit version stopped working on my Windows 10 machine. I un-installed the package and was able to successfully install the Client Tool. But when I tried to re-install the Server, it just extracts the package but fails to display the per-requisite page to start the server installation. What could be the problem? Any help would be really appreciated.
Did you ever get this to work ? If so how ? Thank you.
Hi Raghav,
Thanks for this so much helpful post.
I am trying to download Informatica from oracle cloud delivery portal.I am not able to find by ” Oracle Business Intelligence”.
They might have changed something over there. Also, oracle business intelligence Data Warehouse Administration Console 11g for Microsoft Windows and Informatica PowerCenter
and PowerConnect Adapters 9.1 for Windows x86 (32-bit) is unavailable.
Your help on this wud be highly appreciated.
Here’s an easier way on the new website –
(BTW, I wish I could share a screenshot) – but anyways – even before you type anything in the search box select the Release options in the drop down and Enter “Oracle Business Intelligence” The search should show up 199 results – and precisely 11th in the drop down is what we need to download.
Search Informatica then you will find
Hi Raghav,
I encountered an error while unpacking the Informatica software detailed in Step 8. I encountered the error “Invalid compressed data to extract”. The error occured while extracting the file “dac_win_11g_infa_win_64bit_961.z01”.
I am using Winzip 17.
Kindly help.
Thanks & Regards,
Thiyagarajan
Guys,
I’ve just started learning Informatica and thanks to Raghav, I’m half way thru with installing the software on my VM…so far so good but to start off with – due to a few changes in the website (oracle) – i presume and noticed a few messages here from people finding it difficult to locate the exact file to download.
Here’s an easier way on the new website –
(BTW, I wish I could share a screenshot) – but anyways – even before you type anything in the search box select the Release options in the drop down and Enter “Oracle Business Intelligence” The search should show up 199 results – and precisely 11th in the drop down is what we need to download.
hope this helps. I’m thinking to prepare a short documents on how I’ve been able to achieve the installation process…but all thanks to Raghav – my dream to self learn Informatica would’ve just been a dream forever. Cheers. Murali.
Can Informatica 9.5.1 works with Windows 10 64-bit.
Please share updates.
Hi Raghav,
My laptop is Windows 8 64bit configuration.
I downloaded the Oracle 11g and Informatica files as mentioned.
Unzipped the Oracle 11g files, and while trying to run the setup, I get an error in the first step itself:
“INS-13001 environment does not meet minimum requirements”.
Kindly suggest what to do.