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.
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.
Step 2: Installation will start like this.
Step 3: Select installation type as "Install Informatica" and click "Next" button.
Step 4: It will display the pre-requisites window. Click "Next" to continue.
Step 5: Select Informatica licence file and give installation path. Try to avoid spaces in the installation path.
Step 6: Installation summary page will be displayed. Click "Install to start installation.
Step 7: Installation continues like below. Let it complete it.
Step 8: Select "Create a domain" check box and uncheck "Enable HTTPS for Informatica Administrator". then click "Next" to continue.
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
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.
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.
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.
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