function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
learn_cloudsflearn_cloudsf 

Informatica or data loader ?

which tool is better in salesforce Apex Data Loader or ETL tool Informatica ? How to get hands on on Informatica ?

Thanks
 
VineetKumarVineetKumar
Apex Data Loader is a good tool but very limited you cannot perform configural data transformation before saving the data into salesforce, whereas informatica would provide you with this facility
Check this link
http://www.arkusinc.com/archive/2013/comparing-data-loaders-for-salesforce

It depends on what is your requirement, if you just want to load data from a flat file without minimal transformation they data loader would be agood one to go, without any purchase required.
But if you have to integrate your salesforce with some other 3rd party tool to get data, and the data from other source might require high level of transformation, then Informatica would be the way to go.
Irrin MadlerIrrin Madler
Informatica is quite expensive and Data Loader is quite limited, so we chose another service - Skyvia (https://skyvia.com/). It`s a quite cool tool with wide functionality and more affordable than Informatica Data Loader