Pages

Wednesday, March 5, 2014

Informatica Server Installation with step by step screen shots

Topic: Informatica Server Installation with step by step screenshots.


Step 1: Download Informatica software from below site.


https://edelivery.oracle.com/

You need OTN(Oracle Technology Network) login details to download it from here. Use this software from here to learning purpose only. We should not use it in any production environment.

 Informatica is client server application. So you need to install Informatica server and client separately.

First we will install Informatica server then we install Client.

Important point to remember:

a) To have a good understanding of Informatica, we should aware of Informatica architecture at high level.


b) Informatica demands to schemas(user accounts of oracle) to complete the installation. One schema will hold "Domain" information and another schema will hold "Repository" information like folders,source tables, target tables, mappings, sessions, workflows..etc.

c) While installing Informatica server only domain schema will be used.

FYI: creating schema in oracle

CREATE USER INFODOM IDENTIFIED BY Admin$1234;
Grant dba to INFODOM;

CREATE USER INFOREP IDENTIFIED BY Admin$1234;

Grant dba to INFOREP;


Step 2:  After extracting Informatica software, run "install.bat" file to start installation.

Informatica server installation batch file

Step 2: Installation will start like this.

Informatica installation starting

Step 3: Select installation type as "Install Informatica" and click "Next" button.

Select Informatica installation type

Step 4:  It will display the pre-requisites window. Click "Next" to continue.

Informatica Installation summary

Step 5:  Select Informatica licence file and give installation path. Try to avoid spaces in the installation path.

Informatica license file selection and installation path

Step 6:  Installation summary page will be displayed. Click "Install to start installation.


Informatica Installation summary 2

Step 7:  Installation continues like below. Let it complete it.

Informatica Installation progress

Step 8:  Select "Create a domain" check box and uncheck "Enable HTTPS for Informatica Administrator". then click "Next" to continue.

Informatica domain creation

Step 9:  Provide the below details specific to your environment and click "Next" to continue.

Database Type: Oracle
Database User ID: INFODOM
User Passwor: Admin$1234
Database address: localhost:1521
Database service name: ORADB

Informatica domain creation parameters

Step 10:  After giving the above credentials click "Test connection" button to test the connection. You will get "The connection is successful" message window. Click "Ok" and click "Next" to continue.

Informatica domain creation test connection

Step 11:  Don't change any other details except Domain password. In my case I am keeping the user name as "Administrator" and giving password as "Administrator". Click "Next" to continue.

Informatica Domain user name and password

Step 12:  Uncheck "Run Informatica under a different user account". Click "Next" to continue.


Step 13:  After successful installation you will see the below summary window. Click on "Done" button.

Informatica installation success summary

With this you have just completed the installation of Informatica server. 

You need to create Repository service and Integration service to complete Informatica server configuration part. I will cover the rest in next post. Keep reading.

CHEERS :)









No comments:

Post a Comment