Connect Informatica PowerCenter to Salesforce on Windows

You can connect Informatica PowerCenter to Salesforce through the ODBC driver on Windows to unify and manage data across these systems.

Prerequisites

Configure the Informatica services.
Install the PowerCenter Client tools.
Create a repository folder in PowerCenter Repository Manager.
Install Devart ODBC Driver for Salesforce. For instructions, see Install the driver on Windows.
Configure a data source name (DSN). For instructions, see Configure a Windows DSN for Salesforce.

Add a data source in Informatica PowerCenter

Note

Before you proceed, make sure PowerCenter Designer isn’t running.

1. Open the C:\Informatica\10.4.1\clients\PowerCenterClient\client\bin\powrmart.ini file in a text editor.

2. In the [ODBCDLL] section, add Salesforce=EXTODBC.DLL, then save the changes.

[ODBCDLL]
Salesforce=EXTODBC.DLL
SQL Server=SYBODBC.DLL
Oracle=ORAODBC.DLL
...

3. Open PowerCenter Designer.

4. Double-click the repository name (in this example, PCRS), enter your Informatica credentials, then click Connect.

The Connect to Repository dialog in PowerCenter Designer

5. Double-click the repository folder (in this example, ODBC connections), then select Sources > Import from Database.

Expanded Sources menu in PowerCenter Designer

The Import Tables dialog appears.

6. From the ODBC data source menu, select the needed DSN.

7. In the Username and Password fields, enter your Salesforce credentials.

8. Under Show owners, select All.

9. Click Connect.

The Import Tables dialog with a selected data source and entered credentials

10. In the Select tables section, expand the tree and select the tables you want to import.

11. Click OK.

The Import Tables dialog with selected tables

The table schemas appear in the Source Analyzer, and the data source is added to the Sources subfolder of the repository folder. You can now create mappings and work with Salesforce data in Informatica PowerCenter.

The new source and imported tables in PowerCenter Designer