Informatica 9.0.1 Server Installation:
This post provides
complete step by step instruction for installation and configuration of
Informatica PowerCenter 9.0.1. This includes the installation of server
components, configuration of different Informatica services and client
installation and configuration.
Pre-requisites of Informatica Installation:
It is needed to create a schema in an oracle database while
installing Informatica server. This schema will be have the metadata
repository. And this data will be used by Informatica both server and client.
Metadata can include information such as mappings describing how to transform
source data, sessions indicating when you want the Informatica Server to
perform the transformations, and connect strings for sources and targets.
Script to create a tablespace in Oracle Database:
CREATE
TABLESPACE INFAREP_TS DATAFILE 'D:\app\hp\oradata\orcl\infarep_ts.dbf'
SIZE 100M AUTOEXTEND ON MAXSIZE 500M;
Note:
Datafile path should be your machine oracle installed path where the tablespace will be created after executed the above query.
SQL Syntax to create schema to hold metadata:
CREATE USER
INFAREP
IDENTIFIED BY
INFAREP
DEFAULT
TABLESPACE INFAREP_TS
TEMPORARY
TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
SQL syntax to extend password life to lifetime:
ALTER profile
DEFAULT limit password_life_time UNLIMITED;
Script to create role that will be given to user:
Create role
SSE_ROLE;
Grant connect,
resource to SSE_ROLE;
Grant select
any table to SSE_ROLE;
Grant create
session to SSE_ROLE;
Grant insert
any table, delete any table, update any table to SSE_ROLE;
SQL Script to create schema to hold metadata:
GRANT SSE_ROLE
TO infarep;
GRANT GLOBAL
QUERY REWRITE TO infarep;
GRANT CREATE
MATERIALIZED VIEW TO infarep;
GRANT CREATE
TABLE TO infarep;
GRANT CREATE
ANY VIEW, DROP ANY VIEW TO infarep;
GRANT CREATE
ANY SEQUENCE, DROP ANY SEQUENCE TO infarep;
GRANT CREATE
ANY INDEX, DROP ANY INDEX TO infarep;
GRANT UNLIMITED
TABLESPACE TO infarep WITH ADMIN OPTION;
Informatica
9.0.1 Server Installation:
Step1: Download all the necessary files and unpack and keep it in folder. Now start Installation of server from the folder by Double clicking on “install.exe”
Install Anywhere window will open and will guide through the next step
Step2: Installation
wizard starts. Click the radio button as shown in screenshot below and click on
“Next”.
Step3: Installation Pre-requisites will be
shown before the installation starts as below. Click “Next”.
Step4: Enter the license key. You can
locate the license key from the desired path where the file “Oracle_All_OS_Prod.key”
is there in your system.
Click “Next”.
Note: if the oracle key store place path have space then it won't go the next step. It will give error like below screen shot, If it is not happened to you just move to next step
Step5: Pre-installation summary will give
the items installed during the installation process based on the license key.
Click “Install”
Step6: Installation Begins. It takes
couple of minutes to finish. Soon after completion of this step, Configuring
Domain window opens. Continue the steps from Domain Configuration.
Domain
Configuration Steps:
Step7: Creating a domain
o Choose “Create
a Domain” radio button.
o Un-Check “Enable
HTTPS for Informatica Administrator”
o Leave the Port number as it is and choose “Use a keystore
file generated by the installer”
Step8: Provide the Repository database
details as below.
o Database Type: Choose
your Repository database (Oracle/SQL Server/Sybase)
o Database user
ID: Database user ID to connect database.
o User Password: Password
to connect to database.
o Schema Name: If
Schema name is not provided default schema will be used.
o Database Address
and Port: Machine on which database in installed and default port
number.
o Database Service Name: Database Name.
Below image shows the configuration using Oracle. Click “Next”.
Step9: You can give the Domain details, Admin user details now.
Step9: You can give the Domain details, Admin user details now.
o Domain Name: Name
of your Domain.
o Node Host Name: Machine
name on which Informatica Server is running.
o Node Name: Name
of the Node.
o Node Port
Number: Leave the default port Number.
o Domain user name
: This is the Administrator user
o Domain password : Administrator password
Note: Remember the Admin User ID, Password
to log on to Admin Console later in the installation.
Step10: Use the default configuration and
Click “Next”.
Step11: Installation is complete and you
get the post-installation summery. You get a link to the installation log file
and a link to Admin console. Click “Done”.
************************************************************************************************************
1. Install Oracle 32 bit client in your system . click here for Oracle 32bit Client Download Link
b. Copy the tnsnames.ora file from installed oracle server 64bit path to to the client path.
*********************************************************************************
Important Note:
with the above step we have successfully installed the server. Now in order to configure the Power Center Repository and Integration Services, there are few things we have to make sure. In my case I'm installing theInformatica Client and Server in my local machine were I have my Oracle Server database 64 bit. However in order to configure the Powercenter Repository Services we should also install Oracle Client 32 bit in the same machine. The reason is Informatica can talk to the server only through the 32 bit Client machine.
b. Copy the tnsnames.ora file from installed oracle server 64bit path to to the client path.
*********************************************************************************
Configuring / Creating Repository
Services:
Step1: Go
to Start menu and Click on “Informatica Administrator Home Page”. This will
open up the Admin Console in a web browser.
Step2: Log on to Admin console using your
Admin User ID and Password. You set your Admin User ID and Password in “Step9”
above.
Step3: Once
you Log on you will see the Screen just like shown below.
Step5: A
new screen will appear, in which you need to fill in details.
Step6: Fill
in following details.
o Repository Name:
Appropriate Repository Name.
o Description: An
optional description about the repository.
o Location: Choose
the Domain you have already created. If you have only one Domain, this value
will be pre populated.
o License: Choose
the license key from the drop down list.
o Node: Choose the node name from the drop
down list.
Click “Next”.
Step7: A new screen will appear, provide
the Repository database details.
o Database Type : Choose
your Repository database (Oracle/SQL Server/Sybase)
o Username: Database
user ID to connect database.
o Password: Database
user Password.
o Connection
String: Database Connection String.
o Code Page: Database
Code Page
o Table Space: Database
Table Space Name
o Choose “No content exists under specified connection
string. Create new content”
Click “Finish”.
Step8: It
takes couple of minutes create Repository content. After the repository
creation below screen will be seen.
Step9: The
repository service will be running in “Exclusive” mode as shown below.
This needs to be change to “Normal” before we can configure Integration
service. Click “Edit” Repository Properties.
Step10: A
pop up window appears, set the properties
o Operation Mode :
Normal
o Security Audit Trail : No
Click “OK”.
Click “OK”.
Step1: Choose
your Domain Name from “Domain Navigator”, Click on “Actions”, Choose
“New” and “PowerCenter Integration Service”.
Step2: Following screen appears.
Step3: A
new window will appear, provide the details as shown below.
o Name: Desired
Integration Service Name.
o Description: An
optional description about the repository.
o Location: Choose
the Domain you have already created. If you have only one Domain, this value
will be pre populated.
o License: Choose
the license key from the drop down list.
o Node: Choose the node name from the drop
down list.
Step4: A
new window will appear, provide the details as shown below.
o PowerCenter
Repository Service: Choose your Repository Service Name from the drop down list.
o Username: Admin
user name.
o Password: Admin
password.
o Data Movement Mode: ASCII.
Step5: A
pop up window will appear, Choose the Code Page as ANSI. Click “OK”.
Step6: Window
will be closed and you can see all the configured services in the “Domain
Navigator”.With that we are all done with the installation and configuration for Informatica PowerCenter Server 9.0.1.
we will see Complete step for Installing Informatica Client Installation in the next Post
Happy Blogging!
Bose
Hi!
ReplyDeleteThanks for your correct informations, you are posting good blog. Thanks a lot
Security Audit Chennai
Hello Could you please let me know how to Copy the tnsnames.ora file from installed oracle server 64bit path to to the client path. ?
ReplyDeletethanks, krishna