ETL · Salesforce

HOW TO IMPORT SALESFORCE OBJECT AS SOURCE IN INFORMATIC POWER CENTER

There are many scenario where we need to use ETL tool. I am using infromatica to bring data from salesforce for transformation. Here I am talking - how to import salesforce objects in informatica? Step:1 In source analyzer click Sources > Import from Salesforce. step:2 Enter Username of the salesforce and password of the salesforce… Continue reading HOW TO IMPORT SALESFORCE OBJECT AS SOURCE IN INFORMATIC POWER CENTER

ETL · Integration · Salesforce

UPDATE DATE FIELD IN SALESFORCE USING INFORMATICA WORKFLOW

Flat file to Salesforce date problems -Informatica Network step 1: Close date format is “2020-10-31” in source file. step 2: Select “string” datatype instead of “date/time”. Step 3: Next step select the expression transformation from transformation tool and pass all fields into expression transformation. Step 4: 1) Input “Date” is always in string format             … Continue reading UPDATE DATE FIELD IN SALESFORCE USING INFORMATICA WORKFLOW

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… Continue reading CONNECT SALESFORCE FROM INFORMATICA POWER CENTER 10.0