How to load data from CSV file to Salesforce.com using Informatica Powercenter?

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!!!!

Oh hi there 👋
It’s nice to meet you.

Sign up to receive awesome content in your inbox, every month.

We don’t spam! Please check your mail for confirmation.

Leave a Comment

Your email address will not be published. Required fields are marked *

Select Language »