Data Loader

Single Data Loader: Overview

ARM Data Loader allows you to configure your data loading operations in convenient, user-friendly GUI wizards. It also allows you to import, export, and delete unlimited amounts of Salesforce data without typing a single line of code. Its powerful yet easy-to-understand scheduling settings enable you to specify almost any schedule quickly. You can schedule any data-loading operation for automatic execution.

When to use Single Data Loader

1. You need to load 50,000 to 5,000,000 records. Data Loader is supported for loads of up to 5 million records. If you need to load more than 5 million records, we recommend you work with a Salesforce partner or visit the AppExchange for a suitable partner product.

2. You need to load into an object that the import wizards do not support yet.

3. You want to schedule regular data loads, such as nightly imports.

4. You want to export your data for backup purposes.

Features of Single Data Loader

1. Extracting Data from Salesforce

2. Importing Data into Salesforce

3. Deleting Data from Salesforce

4. Updating Data in Salesforce

5. Upserting Data into Salesforce

Data Loader Pro: Overview

Data Loader Pro is an advanced feature ARM provides for transferring data from the source sandbox to the destination sandbox more conveniently while automatically handling the parent-child relationship. Migrating the Salesforce data/objects to more than one object-supporting hierarchy can easily be achieved using the Data Loader Pro feature in ARM.

Features of Data Loader Pro

• Cloud-based data loader with scheduling capabilities

• Supports circular references

• Objects are extracted from the source sandbox and transferred to the destination in one step.

• Data integrity check: Checks for data integrity between the source and the destination.

• Error reporting: Detailed reporting of any failure during data-loading operations.

• History of data-loading operations: The results are retained for future reference.

• Supports owner ID transfer

• Supports user lookup transfer

• Supports chatter data migration

• Preserves the parent-child relationship

Salesforce/ARM Data Loader Comparison Matrix

Salesforce Dataloader vs. ARM Data Loader vs. ARM Data Loader Pro

Category	SFDC Dataloader	AR Data Loader	AR Data Loader Pro
Ease of use	Wizard interface	Simple, easy steps to create a Data loader job	Simple, easy steps to create a Data Loader Pro job
Data/records Supported	Supports up to 5 million records	Supports unlimited data	Supports unlimited data
Field mapping	Drag-and-drop field mapping	Auto field mapping	Auto field mapping
Schedule	Does not support scheduling	Supports scheduling	Supports scheduling
Pre/post-migration operations	No built-in mechanism	Built-in handling mechanism for validation and workflow rules while migrating data	Built-in handling mechanism for validation and workflow rules while migrating data
Dataloader operations supported	Supports export, insert, update, upsert, and delete operations	Supports export, insert, update, upsert, and delete operations	Automatically and dynamically supports insert, update, and upsert operations, based on destination org data, for multiple objects, while preserving parent/child relationships
Multi-object migration support	Does not support multi-object migration	Does not support multi-object migration	Supports multiple object data migration
Ease of admin	Supports results download	User-friendly results data, downloadable in CSV format	User-friendly Object and results data, downloadable in CSV format
Grouping of jobs	Does not support job grouping	The user can group sets of Data Loader jobs	The user can group sets of Data Loader jobs
Masking rules	Limited masking rules	Multiple masking rules	Multiple masking rules
Data migration	Slower data migration	Much faster data migration using ARM external ID, which also helps eliminate duplicates	Much faster data migration using ARM external ID, which also helps eliminate duplicate