How to extract data from salesforce in informatica powercenter

In PowerCenter Designer, connect to your repository and open your folder. Select the Source Analyzer, click the sources menu, and select Import from Database… In the drop-down menu for ODBC data source, select the DSN you previously configured (CData SalesforcePardot Sys). In this article Add Salesforce as an ODBC Data Source. Create an ETL Workflow … Read more

How to export salesforce report

From Reports, next to the report you want to export, click. | Export. Choose an Export View. … If exporting as Details Only, select Excel Format . … Click Export. If prompted by a browser dialog, select a location and save the file. How do I export reports? Export a reportOpen the report you’d like … Read more