# Data Loader

### Single Data Loader: Overview <a href="#single-dataloader-overview" id="single-dataloader-overview"></a>

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 <a href="#when-to-use-single-dataloader" id="when-to-use-single-dataloader"></a>

1. You need to load 50,000 to 5,000,000 records. [Data Loader](https://www.autorabit.com/blog/10-benefits-of-salesforce-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 <a href="#features-of-single-dataloader" id="features-of-single-dataloader"></a>

1. [Extracting Data from Salesforce](https://knowledgebase.autorabit.com/~/revisions/klh6Zdcuw9GtAWSChIhu/product-guides/arm/arm-features/dataloader/single-dataloader/extract-salesforce-data)
2. [Importing Data into Salesforce](https://knowledgebase.autorabit.com/~/revisions/klh6Zdcuw9GtAWSChIhu/product-guides/arm/arm-features/dataloader/single-dataloader/insert-salesforce-data)
3. [Deleting Data from Salesforce](https://knowledgebase.autorabit.com/~/revisions/klh6Zdcuw9GtAWSChIhu/product-guides/arm/arm-features/dataloader/single-dataloader/delete-salesforce-data)
4. [Updating Data in Salesforce](https://knowledgebase.autorabit.com/~/revisions/klh6Zdcuw9GtAWSChIhu/product-guides/arm/arm-features/dataloader/single-dataloader/update-salesforce-data)
5. [Upserting Data into Salesforce](https://knowledgebase.autorabit.com/~/revisions/klh6Zdcuw9GtAWSChIhu/product-guides/arm/arm-features/dataloader/single-dataloader/upsert-salesforce-data)

### Data Loader Pro: Overview <a href="#dataloader-pro-overview" id="dataloader-pro-overview"></a>

**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](https://knowledgebase.autorabit.com/~/revisions/klh6Zdcuw9GtAWSChIhu/product-guides/arm/arm-features/dataloader/single-dataloader/update-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 <a href="#features-of-dataloader-pro" id="features-of-dataloader-pro"></a>

* 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 <a href="#salesforcearm-dataloader-comparison-matrix" id="salesforcearm-dataloader-comparison-matrix"></a>

[Salesforce Dataloader](https://www.autorabit.com/blog/addressing-the-salesforce-data-loader-log4j-issue-with-autorabit/) 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                                                                                         |
