The Data Loader is a downloadable module for the bulk import or export of data. It is used to delete and update records. It offers support for all the objects (and even more: record types, permission sets …) and enables to obtain Salesforce Ids. It is supported for loads of up to 5,000,000 records.
Depending on the security of the connection, the Data Loader will request an additional security token for the user’s identification. Because the Data Loader is an external application to Salesforce, the security level is higher.
++: All objects are supported in this application, automation is possible and actions are multiple: delete, update, export, import, save field mapping, detailed success and error log files.
—: Additional module to download, complex user identification, inevitably triggers workflows, does not manage duplicates.