Dataloader
  • 29 Mar 2023
  • 2 Minutes to read
  • Contributors
  • Dark
    Light

Dataloader

  • Dark
    Light

Article Summary

Single Dataloader: Overview

ARM Dataloader 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 Dataloader

  1. You need to load 50,000 to 5,000,000 records. Dataloader 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 Dataloader

  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

Dataloader Pro: Overview

Dataloader 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 Dataloader Pro feature in ARM.

Features of Dataloader Pro

  • Cloud-based dataloader 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 dataloading operations.
  • History of dataloading 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 Dataloader Comparison Matrix

Salesforce Dataloader vs. ARM Dataloader vs. ARM Dataloader Pro

Category

SFDC Dataloader

AR Dataloader

AR Dataloader Pro

Ease of useWizard interfaceSimple, easy steps to create a Dataloader jobSimple, easy steps to create a Dataloader pro job
Data/records SupportedSupports up to 5 million recordsSupports unlimited dataSupports unlimited data
Field mappingDrag-and-drop field mappingAuto field mappingAuto field mapping
ScheduleDoes not support schedulingSupports schedulingSupports scheduling
Pre/post-migration operationsNo 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 supportDoes not support multi-object migrationDoes not support multi-object migrationSupports multiple object data migration
Ease of adminSupports results downloadUser-friendly results data, downloadable in CSV formatUser-friendly Object and results data, downloadable in CSV format
Grouping of jobsDoes not support job groupingThe user can group sets of dataloader jobsThe user can group sets of dataloader jobs
Masking rulesLimited masking rulesMultiple masking rulesMultiple masking rules
Data migrationSlower data migrationMuch 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