What is Informatica Powercenter?
PowerCenter Enterprise forms the foundation for all your data and enterprise integration initiatives—including data governance, data migration, and enterprise data warehousing—setting the standard for high-performance enterprise data integration and quality software. It scales to support large volumes of disparate data sources and meets demands for security and performance.
http://www.informatica.com/us/products/data-integration/enterprise/powercenter
Client Applications:
Informatica client applications are desktop tools used to create transformations, manage metadata, execute ETL processes and monitor them.
Designer – Tool for creating ETL mappings.
Workflow Manager – Tool to create and start workflows (sequences of mappings)
Workflow Monitor – Tool to monitor the workflows
Repository Manager – Tool to manage source/targets connections, folders, objects, users, etc.
Administrator console – Tool to perform domain and repository service tasks (configure services, nodes, perform backups, etc.)
How to install Informatica 8.6 server?
Things to be done before installation:
Create DB users:
At least two database user accounts are required to host INFORMATICA repository :
POW_REP for the repository Database
POW_DOM fro the domain Configuration Database
For Oracle, you must perform the following instruction :
1. Create the below user.
CREATE USER POW_REP IDENTIFIED BY POW_REP
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
2. Grant access to the user.
GRANT CONNECT, resource, CREATE VIEW TO POW_REP;
3. Create the below user.
CREATE USER POW_DOM IDENTIFIED BY POW_DOM
DEFAULT tablespace users
TEMPORARY tablespace temp
quota unlimited ON users;
4. Grant access to the user.
GRANT CONNECT, resource, CREATE VIEW TO POW_DOM;
set the Environment Variables:
Kindly mention the path where you are going to install the server in the environment variables.
INFA_JAVA_OPTS – C:\Informatica\PowerCenter8.6.0\java\bin
PATH – C:\Informatica\PowerCenter8.6.0\server\bin
PowerCenter Workflow Manager:
1. Connection –> Application Connection.
2. Select Salesforce.com.
3. Click “New”.
4. Enter the username and password(security token is must if you are accessging out of IP ranges)
5. Task –> Create Task.
6. Select Session.
7. Tools –> Workflow designer.
8. Drag and drop Task.
9. Point Start to Task
10. Workflows –> Start Workflow
Cheers!!!!