This article has the the complete steps to install the Informatica Powercenter product. This includes the server installation.
Below are the high-level steps:
1. Download the informatica package/zip file.
2. Unzip/Untar the file.
3. Run the installer.
a. Configure the Domain
b. Crete a Node.
c. Configure the Repository service and Integration service.
Pre- Requirements:
Before you start the Installer, make sure you check the below steps.
1. Database has to be installed.
2. Create schemas. One for Domain contents and another one for Repository contents.
3. Grant the below Roles and Privileges.
a. Roles - CONNECT, RESOURCE
b. Privileges - CREATE TABLE, CREATE VIEW, CREATE ANY INDEX
c. Also unlimited tablespace on the schemas. - GRANT UNLIMITED TABLESPACE ON <schema Name>;
Once the above requirements are verified, you can start the Installation.
Server Installation:
Step 1:
Informatica PowerCenter software can be downloaded from
https://edelivery.oracle.com
Log on to
https://edelivery.oracle.com and accept the Terms and Conditions to download the zip files.
Search and select the below product:
Oracle Informatica PowerCenter and PowerConnect Adapters.
Click on Continue. Accept the terms and conditions here and you can find the below files. Select which version you need. Here there are 2 versions 951 and 961. Click on Download to download the files.
Step 2:
Once download the below files, Unzip all the files.
Step 3:
Once the unzip done, the files will be available in extracted folders and right click on install.bat and select run the Installer as Administrator.
Step 4:
Select the "Install or Upgrade to Informatica 961 Hotfix 4" and click on Start button.
Step 5:
Select Install Informatica 961 HitFix 4 and click on Next.
Step 6:
Choose the licence file that will come with the downloaded zip file and provide the installation directory. This installation directory will be assigned to environment variable INFA_HOME. Click on Next.
Step 7:
On the next screen you will see the summary of settings for the Installation. Click on Install to begin the binary files installation.
Step 8:
The progress of the installation will be shown in the next window,
Step 9:
Once the installtion is 100% completed, it will configure the installed files. Once that is done, it will move to next screen.
Here you select "
Create a Domain".
Check the "
Enable Https for Informatica Administrator" and
Port
8443 as default. If you want you can change it to any other available port.
Select "
Use a keystore Generated by the Installer"
Click on Next.
Step 10:
In the next screen provide the values for Database connection. This is the database details for the Informatica domain.
Once you provide the DB Type, DB User and password, select JDBC URL and enter the URL like hostname:port.
Once you provide the database details, click on "
Test Connection". This should show you the successful message. If it is failing, please check the database details and enter it again.
Click on Next.
Step 11:
Enter any keyword (password) in the next screen for the "
Keyword" field and leave the Encryption key directory as default. Click on Next.
Step 12:
In the next screen enter the domain details. (Domain Name, Node host name, Node Name, Node port number, Domain user name - Administrator and Enter the Password for Administrator account. This will the superuser for the Informatica server.
Check the tick box, "
Display Advanced port configuration page" if you want to change the default ports and click on Next.
Step 13:
If Advanced Ports selected you will show you the advanced ports page. You can leave the default values and click on Next which will start defining the domain. This will start creating the domain and node.
Step 14:
Once the domain is defined, on the next screen, uncheck the "
Run Informatica under a different user account". If you want to run the process under different account you can provide that details here. it is suggested to use the same account and don't select the option.
Click on Next.
Step 15:
Once the above step is completed, on the next window you can find the summary of the Post Installation which means the installation is completed. Use the URL for
Informatica Administrator Home page to login into Admin Console.
Username -
Administrator
Password - <password you provided in the step 12.
PowerCenter Client Installation:
Once the server is Installed, you can install the client as well. Please follow the below link for client Installation.
Informatica Client Installation
Login Into Admin Console:
Once the server is installed you can try logging into Informatica Administrator Console. Follow the below link to know how to login into admin console.
Thank you.
