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

    Dataloader

    • Updated on 29 Mar 2023
    • 2 Minutes to read
    • Contributors
    • 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

    What's Next
    Copyright © 2023 AutoRABIT Holding Inc. All Rights Reserved.

    The information herein is the property of AutoRABIT Holdings Inc., and any misuse or abuse will result in economic loss. All product and company names mentioned herein may be trademarks or registered trademarks of AutoRABIT Holdings Inc. or their respective owners.