AutoRABIT Knowledge Base
Ask or search…
⌃K
Comment on page

Dataloader

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. 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. 2.
    You need to load into an object that the import wizards do not support yet.
  3. 3.
    You want to schedule regular data loads, such as nightly imports.
  4. 4.
    You want to export your data for backup purposes.

Features of Single Dataloader

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 use
Wizard interface
Simple, easy steps to create a Dataloader job
Simple, easy steps to create a Dataloader 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 dataloader jobs
The user can group sets of dataloader 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