How to connect to Sales Force (SFDC) From Informatica

 

In order to connect to Sales Force.com. Power Exchange SFDC  needs to be installed and  sfdc plug-in needs to be registered in Informatica Repository.Below are the steps for the same.

1. Log on to server as Informatica functional account.
2. Change directory to Informatica PowerCenter install binaries directory.
3. Ftp/Sftp sfdc_81102_sol32.tar from either local workstation or Informatica server to server where install is taking place
4. Decompress install binaries  (tar xvf sfdc_81102_sol32.tar).
5. At this point, stop integration service and repository service in the environment using admin console.
6. Execute installSFDCserver.
7. Enter Informatica home directory absolute path ($INFA_HOME).
8. Once installation has completed, return to admin console.
9. Add license key to environment using admin console.
10. Select the respective Unicode integration service, modify the HTTP Proxy Properties as follows: HttpProxyServer  ,HttpProxyPort , HttpProxyUser, HttpProxyPassword, HttpProxyDomain.

• Start repository service.
• Start integration service.
• Log into repository using Workflow manager.
• Validate that salesforce.com connection is now an option under application type connections in workflow manager.
• Log into repository using Designer.
• Validate that you can import a source from salesforce.com, and that it is now an option in source analyzer.
• If both workflow manager and designer allow these options, installation is complete.

 Below Is the Installation Output :

$INFA_HOME/server/tomcat/bin/SFDC_81102_Sol32

Stop all the Powercenter processes/Services before running this script ....

Enter absolute path of Powercenter server installation directory{/home/powercenter8.1.1}

$INFA_HOME

server location:$INFA_HOME

backing up $INFA_HOMEserver/bin/native/pmsfdc.xml as $INFA_HOME/server/bin/native/pmsfdc.xml.bak

copying files to $INFA_HOMEserver/bin/native folder

backing up $INFA_HOMEserver/bin/libpmsfdccmn.so as $INFA_HOME/server/bin/libpmsfdccmn.so.bak

backing up $INFA_HOMEserver/bin/libpmsfdclkp.so as $INFA_HOME/server/bin/libpmsfdclkp.so.bak

backing up $INFA_HOMEserver/bin/libpmsfdcrdr.so as $INFA_HOME/server/bin/libpmsfdcrdr.so.bak

backing up $INFA_HOMEserver/bin/libpmsfdcwrt.so as $INFA_HOME/server/bin/libpmsfdcwrt.so.bak

backing up $INFA_HOMEserver/bin/pmsfdc_EN.cat as $INFA_HOME/server/bin/pmsfdc_EN.cat.bak

backing up $INFA_HOMEserver/bin/pmsfdc_JA.cat as $INFA_HOME/server/bin/pmsfdc_JA.cat.bak

copying files to $INFA_HOMEserver/bin folder

cp: server/bin/native: is a directory

Installation completed successfully.

IMPORTANT: If you are upgrading from 8.1.1 please re-register the Salesforce.com plug-in pmsfdc.xml for changes to take effect.

 

 Below are the steps to register the sfdc plugin to Repository :

• Get the pmsfdc.xml from Informatica Vendor.

• FTP the pmsfdc.xml file in binary mode and place it to Informatica server $INFA_HOME/server/bin/native/ path. (Make sure to FTP the sfdc plug in binary mode).

• Bring down the Integration Service.

• Bring the repository service to Exclusive mode from Normal mode. 

• Connect to the repository using the pmrep connect command.

              pmrep>connect -r "LAB_INFA_REP" -d "LAB_INFA_DOMAIN" -n Administrator -x password

• Now register the plugin using the registerplugin command.

             pmrep>registerplugin -i $INFA_HOME\server\bin\native\pmsfdc.xml -e -N 

(Note : Give the fully qualified path otherwise will get the above error Failed to execute registerplugin )

Register Plug-in operation on repository [LAB_INFA_REP] started at **/**/**** 00:00:00.

Importing plugin: SalesforcePlugin ...
Importing dbtype: Salesforce ...
Importing keytype: SOURCEID ...
Importing keytype: TARGETID ...
Importing keytype: SOURCEREFERENCE ...
Importing keytype: TARGETREFERENCE ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...
Importing datatype: id ...

Post validation on imported plug-ins...
The number of plug-ins that registered successfully is 1.
The number of plug-ins that failed to register is 0.
Register Plug-in operation on repository [LAB_INFA_REP] ended at **/**/**** 00:00:00. Elapsed time is 0:00:03.
registerplugin completed successfully.
pmrep>exit