Tools for loading data into Salesforce
Tools are just that, tools, and there are a number of them that can be used to get the job done. Having the right tool for the job will make it smoother and easier to get the job done whereas using the wrong tool will lead to issues and will prolong the job. For example, using the standard Data Import Wizard (DIW), which is part of the standard CRM, for a complex data migration job that requires extensive transformation and error handling will not work and you will hit the limits of DIW very quickly.
These days, many third-party tools are available that have advanced capabilities such as a retry mechanism, error logging, and others. Modern middleware products usually have an Extract, Transform, Load (ETL) component to them and can be used to migrate data. In this section, however, we will discuss the standard DIW and the Data loader.
Data Import Wizard (DIW)
Salesforce provides a user interface-based tool called Data Import Wizard to...