Informatica Installation In 9 Easy Steps

Recommended by 58 users

Dec 6, 2016
Informatica Installation In 9 Easy Steps
Add to Bookmark Email this Post 17.6K    0

Informatica provides the market’s leading data integration platform. Tested on nearly 500,000 combinations of platforms and applications, the data integration platform interoperates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today’s market as a leader in the data integration platform. In this blog, I will help you with Informatica installation and configuration of its services.

Let’s begin by setting up of Oracle database as our primary database on your system. In case you have already installed and configured the Oracle Database and SQL Developer, you can proceed directly to Informatica Installation.

Oracle Database Installation

To commence with the Oracle installation, begin by downloading the setup zip file from the link below.

Step 1: Download Oracle Database Express Edition from the below link (I am installing on a Windows 64 bit OS, so I have selected windows 64):

Step 2 : Once the file download is complete, extract the file:

downloaded setup file-Informatica Installation

extracting-the-file-Informatica Installation

Step 3 : After extracting the file you will get DISK1 folder, Open the folder.

folder-open-Informatica Installation

Step 4: Double click on setup to start installation:

launch-setup-Informatica Installation

Click on Next.

oracle-setup-1- Informatica Installation

Step 5: Accept the terms and click on Next.

oracle-setup-2- Informatica Installation

Click on Next.

oracle-setup-3- Informatica Installation

Step 6: Specify the Database Password.

  • Enter Password: oracle123

Note: If you are choosing your own password so please make a note, we will need this password again.

 

oracle-setup-4- Informatica Installation

Note: The Default port in which Oracle listens is 1521.

Click on Install.

oracle-setup-5- Informatica Installation

This may take a while.

oracle-setup-6- Informatica Installation- Edureka

Step 7: Click on finish to complete the installation.

oracle-setup-6- Informatica Installation- Edureka

Configuration of  Oracle SQL Developer

Before beginning the SQL developer installation, make sure you have started the database. If the database isn’t started, the connection between the SQL developer and database will fail.

To start the database: Go to Start -> Oracle Database 11g Express Edition -> Click on Start database.

Starting databasel- Informatica Installation- Edureka

Now we can begin the Configuration of Oracle SQL Developer:

Step 1: Begin by downloading Oracle SQL Developer zip file. I recommend you use SQL Developer 3.2.20 as the later versions require you to install Java 1.8 and manually set the path. You can download the file from the link below:

Step 2: Once the download is complete, extract the downloaded file.

sql-developer-file- Informatica Installation- Edureka

extract-sql-developersql- Informatica Installation- Edureka

Step 3: After the extraction is complete, you will get sqldeveloper – 3.2.20.09.87 folder. Enter the sqldeveloper – 3.2.20.09.87 folder and double click on click on sqldeveloper to start configuration.sql-folderl- Informatica Installation- Edureka

sqldeveloper-launchingl- Informatica -Installation- Edureka

Note: If we go for the version 4.0 or higher of SQL Developer we need to install JDK 1.8 and we have to manually configure the complete path so we will recommend to go with version 3.2 itself.

Step 4: Once the initialization is completed, you will get to the home screen below. Do not select any configure file type association, directly click on cancel.

sql-developer-homepagel- Informatica Installation- Edureka

Step 5: To establish the connection, start by right clicking on connections and Click on New Connections.

new connection- Informatica Installation- Edureka

Step 6: We will now connect to the Oracle Database. Enter the following details as below :

  • Connection Name: ORACLEXE
  • Username: sys
  • Password: oracle123 (here we have to specify the same password that was set while database installation)
  • Role: SYSDBA

Click on Save -> Test -> Connect

new-connection- Informatica Installation- Edureka

Once we will click on connect we can see the Connection is added in the list.

oracle-connection-sucessful - Informatica Installation- Edureka

Step 7: Now click on the Plus icon next to ORACLEXE to get the screen below:

ocraclexe- Informatica Installation- Edureka

Step 8: Now we have to create 2 users.

  1. INFA_DOM (For Domain)
  2. INFA_REP (For Repository)

Right click on Other Users to create user.

adding-user-1 - Informatica Installation- Edureka

Click on Create User.

creating-user - Informatica Installation- Edureka

Step 9: We will now be creating the user for domain. Enter the following User details :

  • User Name: INFA_DOM
  • Password: INFA_DOM
  • Default Tablespace: USERS
  • Temporary Tablespace: TEMP

dom-user-details- Informatica Installation- Edureka

Note: After specifying all the details do not click on Apply

Step 10: Click on roles tab to define the roles of the user.

Roles - Informatica Installation- Edureka

Step 11: We have to assign the Domain user complete permissions for :

  • DBA
  • CONNECT
  • RESOURCE

DBA- Connect - Informatica Installation- Edureka

Scroll down for to find resources role :

Resources- Informatica Installation- Edureka

Step 12: Now Click on Quotas tab to assign tablespace area:

Quotas - Informatica Installation- Edureka

Step 13:  Select USERS and assign the unlimited option. Click on Apply

assigning-quotas

Click on Close.

user creation close- Informatica Installation- Edureka

User INFA_DOM  has successfully been created.

Step 14: Now we will click on Connection and New Connection to connect to Domain user.

dom-connection-1- Informatica Installation- Edureka

Step 15: Enter the following user details :

  • Connection Name: INFA_DOM
  • Username: INFA_DOM
  • Password: INFA_DOM
  • Connection Type: Basic
  • Role: Default

Click on Save -> Test -> Connect

dom-user- Informatica Installation- Edureka

Once we will click on connect we can see the User is added in the list

connection successful- Informatica Installation- Edureka

Step 16: We will now add Repository user in the similar manner. Click on other user and add users under ORACLEXE.

adding-user-2r- Informatica Installation- Edureka

Step 17: Enter the following details for Repository user:

Username: INFA_REP

Password: INFA_REP

Default Tablespace: USERS

Temporary Tablespace: TEMP

rep-user-details- Informatica Installation- Edureka

Step 18: As in Domain user, provide the Repository user with complete permission for following roles under Roles tab:

  • DBA
  • CONNECT
  • RESOURCE

DBA- Connect - Informatica Installation- Edureka

Step 19: Click on Quotas tab and select unlimited option for Users as seen below:

finishing-rep-access

Click on Close.

Finish- rep-Informatica Installation- Edureka

User INFA_REO  has successfully been created.

Step 20: Now we will click on Connection and New Connection to connect to Repository user.

dom-connection-1- Informatica Installation- Edureka

Step 21:  Enter the following user details :

  • Connection Name: INFA_REP
  • Username: INFA_REP
  • Password: INFA_REP
  • Connection Type: Basic Role: Default

Click on Save -> Test -> Connect

rep-user- Informatica Installation- Edureka

Now you can see New user INFA_REP is created and connected successfully.

SQl Final- Informatica Installation- Edureka


Now we are done with the Installation of Oracle and SQL now we have to download the Informatica tool and install them.

Informatica Installation

 The Informatica installation will follow the steps below:

  1. Downloading the Installation Packs.
  2. Unpacking the Installation Packages.
  3. Informatica PowerCenter Pre-Installation check.
  4. Installing Informatica PowerCenter.
  5. Domain Configure.
  6. Configure Repository Service.
  7. Configure Integration Service.
  8. Client Installation.
  9. PowerCenter Designer Configuration.


Lets begin the installation process now :

Step 1: Downloading Installation Packs

To begin with the Informatica installation, we start off by downloading the free version of the Informatica PoweCenter provided by oracle.

Step 1.1: Download Informatica 9.6.1 using below link

Step 1.2: Sign in to your account, If you do not have Oracle account use New User option to create account.

 

Oracle-home-page - Informatica installation - Edureka

                                           Fig: Oracle Home page

 

Oracle-signin - Informatica installation - Edureka

                                          Fig: Oracle Sign In page

 

Step 1.3: In search Box type PowerCenter.

Step 1.4: Select Oracle Informatica PowerCenter and PowerConnect Adapters.

Step 1.5: Select Platform (I am installing on a Windows 64 bit OS, so I have selected windows 64 ).

 

Product-selection- Informatica installation - Edureka

                                 Fig: Product Selection in Oracle Cloud

Step 1.6: Click on Continue.

 

Download-queue- Informatica installation - Edureka

                                             Fig: Product Selection in Oracle Cloud

 

Step 1.7: Accept the Oracle license.

 

Oracle Licence- Informatica installation - Edureka

                                  Fig: Product Selection in Oracle Cloud

 

Step 1.8: Now as in below screenshot, you have to select last four files from the list.

Step 1.9: After selecting files click on Download.

 

package-list- Informatica installation - Edureka

                                         Fig: Setting Download Queue

 

Step 1.10: You will get a pop up asking you to download installer.

 

Informatica-installation-Installer-downloader

                  Fig: Click on the Download manager to download the required files

Step 1.11: Download the installer and install it in your system. Once installer is launched it will automatically download all the four files in specified directory.

Since the required files are now downloaded,  we will proceed ahead with the Informatica installation by unpacking the downloaded files. 

Step 2: Unpacking the Installation Packages

Note : Use WinRAR for extraction of the files as any other file explorer may cause an error while extracting the dac_win_11g_infa_win_64bit_961

Step 2.1: Now extract all the four files one by one.

Step 2.2: Extract it in the same directory using option as suggested in below screenshot.

 

unzip - 1- Informatica installation - Edureka

unzip - 2- Informatica installation - Edureka

        Fig: Extracting the downloaded files

 

Step 2.3: After extracting, you will get four files :

  • V76290-01_1of4.
  • V76290-01_2of4.
  • V76290-01_3of4.
  • V76290-01_4of4.

 

extracted-files- Informatica installation - Edureka

                                                              Fig: Extracted files

 

Step 2.4: Now enter into fourth file V76290-01_4of4, and extract the file named dac_win_11g_infa_win_64bit_961.

 

file-extraction-1- Informatica installation - Edureka

                                            Fig: File located in V76290-01_4of4

 

Step 2.5: While extracting this file, you have to enter the path of all the 4 extracted files one by one as suggested in below screenshot :

 

unzip-3 - Informatica installation - Edureka

 

Step 2.6: When you get above window, browse to the location of first extracted file and click OK as suggested below :

 

file-extraction-3- Informatica installation - Edureka

                                       Fig: Specifying Extraction location

 

Step 2.7: In the same way browse and extract the second, third and fourth file.

 

Informatica-installation-file-extraction-4 -Informatica installation - Edureka

   Fig: Selecting location to extract the remaining files

 

Step 2.8: Now enter into extracted file dac_win_11g_infa_win_64bit_961 and extract server and client installer using option as suggested in below screenshots.

 

Informatica-installation-client-extract

Informatica-installation-server-extract

                           Fig: Extracting Server and client installer

Step 3: Informatica PowerCenter Pre-Installation Check.

From this point onward the Informatica installation process begins, however before we go ahead with the actual process we need to check whether the current system meets with the minimum requirements for Informatica installation.

Step 3.1: Enter into directory 961_Server_Installer_winem-64t and double click on install.bat file to begin the installation.

 

Informatica-installation-launch - Informatica installation - Edureka

                                 Fig: Selecting Server Installation file

 

Step 3.2: Follow below screenshot.

 

Informatica-installation-pre-install-1 - Informatica installation - Edureka

                     Fig: Selecting to launch pre-installation system check tool

 

Informatica-installation-pre-install-2 - Informatica installation - Edureka

 

Click on Next.

 

Informatica-installation-pre-install-3 - Informatica installation - Edureka

                                Fig: Selecting Installation Directory

 

Step 3.3: Enter the domain configuration as below :

  • Host name : EDUREKA23 (this is my machine’s hostname)
  • Database Password : INFA_DOM
  • Database User ID : INFA_DOM
  • Database type : Oracle

To connect to a remote host, you would have to purchase the Licence from Informatica which costs a few thousand USD per year depending on certain parameter like Number of users, Operating System, Number of processors, etc. 

 

Informatica-installation-pre-install-4 - Informatica installation - Edureka

                                         Fig: Domain Configuration repository database information

 

  • To find the hostname of your machine, go to oracle installation directory and open tnsname.ora file, present in C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN  path

 

Informatica-installation-host-name - Informatica installation - Edureka

                                              Fig: Host name and Port number of current Host machine

 

Step 3.4: Click on Test Connection and Next.

 

Informatica-installation-pre-install-5 - Informatica installation - Edureka

                                                Fig: Domain Connection test

 

Step 3.5: Click on Done.

 

Informatica-installation-pre-install-6 - Informatica installation - Edureka

                          Fig: Informatica Pre-Installation check results 

Learn Informatica from Industry Experts

Step 4: Installing Informatica PowerCenter

Now that we have verified that the current system meets the minimum requirements, we will proceed with the actual Informatica installation. 

Step 4.1: Now again go to the extracted directory 961_Server_Installer_winem-64t and double click on install.bat file.

 

Informatica-installation-installer-1 - Informatica installation - Edureka

 

Step 4.2: Follow below steps.

 

Informatica-installation-installer-2 - Informatica installation - Edureka

                                           Fig: Click on Install or upgrade Option

Click on Next.

 

Informatica-installation-installer-3 - Informatica installation - Edureka

                                                 Fig: System Requirements

 

Step 4.3: Now in below window browse for product key Which is present under V76290-01_4of4\dac_win_11g_infa_win_64bit_961.

 

Informatica-installation-installer-4 - Informatica installation - Edureka

Informatica-installation-installer-5 - Informatica installation - Edureka

                                             Fig: Select Oracle_All_OS_Prod.key

 

Informatica-installation-installer-6 - Informatica installation - Edureka

 

Click on Next.

 

Informatica-installation-installer-7 - Informatica installation - Edureka

 

Click on Install.

  • It will take a bit time to install the software.


installer-8 - Informatica installation - Edureka

Step 5: Domain Configuration

Now that we have completed with the Informatica installation, we begin the process of configuration. The first component that needs to be configured is the operational domain.

Step 5.1: Uncheck “Enable HTTPS for Informatica Administrator” and click Next.

 

Informatica-installation-domain-1 - Informatica installation - Edureka

                                              Fig: Select Create a domain option

Step 5.2: Enter the domain configuration as below :

  • Database type : Oracle
  • Database User ID : INFA_DOM
  • User Password : INFA_DOM
  • Rest of the parameter are default.

Step 5.3: Click on Test connection and click Next.

 

Informatica-installation-domain-2 - Informatica installation - Edureka

 

Informatica-installation-domain-3 - Informatica installation - Edureka

                                                   Fig: Domain Connection test

 

You have successfully tested the domain connection.

Step 5.4: Enter the Encryption key information( I am choosing Edu@1122, you can choose as like):

  • Keyword : Edu@1122

Click on Next and  OK.

 

Informatica-installation-domain-4 - Informatica installation - Edureka

 

Informatica-installation-domain-5 - Informatica installation - Edureka

                                           Fig: Specifying encryption key to be used 

 

Step 5.5: Enter the following details as below regarding Informatica Domain :

  • Domain User Name : Administrator
  • Domain Password : Administrator

Mark check on Display advance port configuration page and click on Next.

 

Informatica-installation-domain-6 - Informatica installation - Edureka

                                                                            Fig: Informatica Domain details 

 

Click on Next.

 

Informatica-installation-domain-ports - Informatica installation - Edureka

                                                   Fig: Informatica port details 

 

  • It will take time to configure settings.

 

Informatica-installation-domain-7 - Informatica installation - Edureka

 

Step 5.6: Uncheck Run Informatica under a different user account and Click on Next.

 

Informatica-installation-domain-8 - Informatica installation - Edureka

 

Step 5.7: Click on Informatica Administrator Home Page link.

Informatica-installation-domain-9 - Informatica installation - Edureka

                                     Fig: Launching Informatica Administrator home page 

Step 6: Configure Repository Service

Once the operational domain is configured, we need to configure the repository services which will connect to the repository from client applications.

Step 6.1: After clicking on above link, Informatica Administrator console will be opened in browser.

  • Username : Administrator
  • Password : Administrator

 

Informatica-installation-admin-homepage - Informatica installation - Edureka

                                                                 Fig: Informatica Administrator login page

 

Informatica-installation-admin-consol - Informatica installation - Edureka

                                                                      Fig :Informatica Administrator console 

 

Step 6.2: Create Repository  services :

  • Click on Action ->  New ->  PowerCenter Repository Service.

 

Informatica-installation-repository-2 - Informatica installation - Edureka

 

 

Informatica-installation-repository-3 - Informatica installation - Edureka

                                                                      Fig : Creating New Repository  

 

Step 6.3: Enter the following Repository service details :

  • Name : Repsvc_Edureka
  • From drop down list select License and Node and Click on Next.

 

Informatica-installation-repository-4 - Informatica installation - Edureka

                                                       Fig : Specifying repository details 

 

Click Next.

Step 6.4: Enter the following details as below for database properties :

  • Database Type : Oracle
  • Username : INFA_REP
  • Password : INFA_REP
  • Connection String : XE

 

Informatica-installation-repository-5 - Informatica installation - Edureka

                                                     Fig : Database properties 

 

Click on Finish.

Step 6.5: Now change Operating Mode from Exclusive to Normal.

 

Informatica-installation-repository-6 - Informatica installation - Edureka

 

Informatica-installation-repository-7 - Informatica installation - Edureka

 

Informatica-installation-repository-8 - Informatica installation - Edureka

                                            Fig : Changing Operating mode of Repository


Now we have successfully made the Repository available for further operations.

Step 7: Configure Integration Service

As part of configuration of the repository services, we need to configure the Integration services also which will load the workflows from the repositories and help combine data from different platforms and source types.

Step 7.1: Create Integration services

  • Click on Action ->  New ->  PowerCenter Integration Service

 

Informatica-installation-integration-1 - Informatica installation - Edureka

                                                                     Fig : Creating new integration service

 

Step 7.2: Enter the following Integration service details

  • Name : Intsvc_Edureka
  • From drop down list select License and Node and Click on Next

 

Informatica-installation-integration-2 - Informatica installation - Edureka

                                    Fig : Specifying integration service properties

 

Click on Next

Step 7.3:Enter the following Repository service details

  • PowerCenter Repository Service : Repsvc_Edureka
  • Username : Administrator
  • Password : Administrator

 

Informatica-installation-integration-3 - Informatica installation - Edureka

Informatica-installation-integration-4 - Informatica installation - Edureka

                                              Fig : Specifying repository properties

 

  • Now Integration service is created but it is disabled, so we have to enable it.

 

Step 7.4: Follow the steps below to enable the integration service

 

Informatica-installation-integration-5 - Informatica installation - Edureka

Informatica-installation-integration-6 - Informatica installation - Edureka

Informatica-installation-integration-7 - Informatica installation - Edureka

                                                                   Fig : Enabling integration services


We have now successfully made the Integration Services available for further operations.

Step 8: Client Installation

To proceed ahead with the Informatica installation, we start with the client installation.

Step 8.1: Now Install PowerCenter Client

  • Go to the directory 961_Client_Installer_win32-x86 and double click into install.bat .

 

Informatica-installation-client-1 - Informatica installation - Edureka

                                                 Fig :Launching client installer

 

Informatica-installation-client-2 - Informatica installation - Edureka

                                                Fig : Enabling integration services

 

Click on Next.

Step 8.2: Mark check on PowerCenter Client and click Next.

 

Informatica-installation-client-3 - Informatica installation - Edureka

                                             Fig : Select PowerCenter Client option

 

Step 8.3: Click Next and specify installation directory .

 

Informatica-installation-client-4 - Informatica installation - Edureka

                                           Fig : Specifying installation directory

 

Step 8.4: Click Install.

 

Informatica-installation-client-4 - Informatica installation - Edureka

 

Now this step will take some time to install the software.

 

Informatica-installation-client-6 - Informatica installation - Edureka

 

Step 8.5: Click on Done

Informatica-installation-client-6 - Informatica installation - Edureka

                                              Fig : Completing client installation

 

Step 9: Configure PowerCenter Designer

The final step of Informatica installation is the configuration of the PowerCenter Designer to connect to the domain and repositories to load the databases

Step 9.1: Now Click on Windows start button to start PowerCenter Designer.

 

Informatica-installation-launching-designer - Informatica installation - Edureka

                    Fig : Launching PowerCenter Designer

 

Informatica-installation-designer-1 - Informatica installation - Edureka

                                               Fig : PowerCenter Designer Homepage

 

Step 9.2: Click on Repository -> Configure Domains.

 

Informatica-installation-designer-2 - Informatica installation - Edureka

                                                              Fig : Configuring Domain

 

Step 9.3: Click to add domain.

 

Informatica-installation-designer-3 - Informatica installation - Edureka

 

Step 9.4: Enter the following details to add a domain :

  • Domain Name : Domain_Edureka23 (here you should type Domain_Host Name Of Your Machine)
  • Gateway Host : Edureka23 (your machine’s host name)
  • Gateway Port : 6005

 

Informatica-installation-designer-4 - Informatica installation - Edureka

                                                    Fig : Specifying Domain details

 

Click OK.

Step 9.5: Select Repsvc_Edureka and click OK.

 

Informatica-installation-designer-5 - Informatica installation - Edureka

                                                   Fig : Selecting repository

 

Step 9.6: Select Repsvc_Edureka and connect to the repository as shown below.

 

Informatica-installation-designer-6 - Informatica installation - Edureka

 

Informatica-installation-designer-7 - Informatica installation - Edureka

                                                  Fig : Connecting to repository

 

  • In below screenshot, you can see that connection is successful.

 

Informatica-installation-designer-8 - Informatica installation - Edureka

 

  • You can verify the connection in repository service in Informatica administrative console.
  • You can see the table listed in Domain Properties.

 

Informatica-installation-designer-9 - Informatica installation - Edureka

                                                                         Fig : Domain Properties

This completes the Informatica installation, hope this blog has been useful in setting up Informatica PowerCenter in your system.

If you found this blog helpful, you can also check out our Informatica Tutorial blog series What is Informatica: A Beginner Tutorial of Informatica PowerCenter and Informatica Tutorial: Understanding Informatica ‘Inside Out’ . In case if you are looking for details on Informatica Certification, you can check our blog Informatica Certification: All there is to know.

View Upcoming Informatica Batches

If you have already decided to take up Informatica as a career, I would recommend you why don’t have a look at our Informatica training course page. The Informatica Certification training at Edureka will make you an expert in Informatica through live instructor led sessions and hands-on training using real life use cases. 

Got a question for us? Please mention it in the comments section and we will get back to you.

Share on
Comments
0 Comments

24 X 7 Customer Support X

  • us flag 1-800-275-9730 (Toll Free)
  • india flag +91 88808 62004