ETL · Salesforce

CONNECT SALESFORCE FROM INFORMATICA POWER CENTER 10.0

Here is a article about ETL integration with Salesforce. I have started learning Informatica Powercenter 10.

In the workflow manager click Connections > FTP. The FTP Connection Browser dialog box appears. Click NEW in the FTP connection browser dialog box.

      Name field need to provide Name of the Salesforce connection, Type Username for the salesforce account and Password for the salesforce account. Enable the SFTP also set hostname“https://test.salesforce.com/services/Soap/u/41.0 “

Click OK , FTP connection object appears in the list of FTP connections in the FTP Connection Browser dialog box. click Close.

After create the FTP workflow connection configure the salesforce connection ,

Step 1: In the workflow manager, click Connections >Application. Application connection browser dialog box appears.

Step2: From select type select salesforce connection, click New the connection object definition dialog box appears.

Step 3: Name field need to provide Name of the Salesforce connection ,Type Username for the salesforce account and Password for the salesforce account. Make sure connection type as Standard or OAuth, initially that is in standard connection only which connection no need to change in the Service URL.

Step4: Click OK, the new application connection appears in the Application Object Browser.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s