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 also add the service URL, click “CONNECT”.
Designer shows list of objects available in the Salesforce User. Select Checkbox, from salesforce which object need to Import Source file for Informatica.
step:3 Click “Finish”
Finally, we import Source from Salesforce in Informatica, that salesforce object shown in the source analyzer.