Selecting your data-loading tool
There are a range of tools available that you can use to load data into Salesforce. Salesforce provides two tools: Salesforce Data Import Wizard and Salesforce Data Loader. There are also several third-party tools ranging from free basic data-loading tools to enterprise ETL tools and integration platforms. These have different strengths, which we will explore.
It is worth noting that the tools that you choose determine the loading template you use, which defines the format and structure you need your data in. This defines the amount of transformation required on your source data. For example, the Salesforce Data Import Wizard loads Account and Contact records from one template. With all other tools this data will need to be added to two separate templates.
Some third-party tools allow you to use a database or SFTP site as the source.
Salesforce-supported tools
In the following sections, we explore the capabilities and characteristics of...