Extract Salesforce Data
  • 10 Jun 2022
  • 3 Minutes to read
  • Contributors
  • Dark
    Light

Extract Salesforce Data

  • Dark
    Light

The following articles describe how to use Single Dataloader to extract data from Salesforce. The information is stored in CSV format.

  1. Log in to your ARM account.
  2. Hover your mouse over the DATALOADER module and select DATALOADER
    The dataloader screen is best viewed when the zoom setting is 75% on your Chrome/Firefox browser.
  3. Click EXTRACT on the right side of the screen.
  4. Choose your Salesforce Org and your org environment (Production or Development Edition, Sandbox, or Pre-Release).
  5. The corresponding URL and your Username are automatically generated based on the above selection.
  6. Click LOGIN AND FETCH OBJECTS to fetch all the objects from your Salesforce Org.
  7. Select the object from which you wish to extract the data, e.g., Account, Contact, Lead, etc. You can use the search function to search through your objects and the filter to quickly filter your standard/custom objects.
  8. Click NEXT.
  9. On the left, select the fields you wish to export from the selected object. You can select all the fields or use the Quick Find search function to search through your fields.
  10. On the right, you can add Filters to your query. Specifying the filter criteria will extract records within a specified limit. To add filters to your query: 
    1. For your object selected, choose a field.
    2. Select the operator.
    3. Enter the filter value.
    4. Click on the + icon to add the filter. 
    5. To delete a filter, click on the x icon.

  11. In the Order By section, you can assign the order in which the record is generated, i.e., ascending or descending order.
    1. Select a field to be your sorting criteria. 
    2. Select your sorting order: Ascending or Descending.
  12. You can also verify your query using the VALIDATE QUERY button to ensure it will work properly before running your task. The number of records being extracted is shown as a notification pop-up.
  13. On the Process Summary screen, you can:
    1. Give the process/job a Name.
    2. Select the Category. Categories are used to classify and group similar processes having similar functionality. In simple terms, you are assigning similar processes to a category. You can either select an existing category or create a new category by clicking the + icon.
    3. View the main object.
    4. View the operation type (extract).
    5. View the number of records being extracted.
    6. Limit the export row count. Use this option to retrieve a certain number of rows from your export results. 
    7. Use Bulk API.
      About Bulk API
      The Bulk API is based on REST principles and is optimized for inserting, updating, and deleting large sets of data. You can use the Bulk API to process jobs in serial or parallel mode. Processing batches serially means running them one after another, while processing batches in parallel means running multiple batches simultaneously. When you run a bulk API job, processing more batches in parallel means giving that job a higher degree of parallelism, providing better overall data throughput.
  14. You can schedule your tasks so they start running regularly. You can choose between Daily, Weekly, or On-demand schedules.
  15. Finally, click on SAVE to save your task and run it later.
  16. Your task is shown on top of the lists in the Dataloader Summary screen. 
  17. Click Run to start the dataloader immediately before the scheduled time.
  18. Select the configurations here:
    • Use Batch Size.
      About Batch Size
      Whenever the Bulk API checkbox is left unchecked, the Batch API is used.

      Salesforce Batch API is based on SOAP principles and is optimized for real-time client applications that update small numbers of records at a time. Although SOAP API can also be used for processing larger numbers of records, when the data sets contain hundreds of thousands of records, it becomes less practical. In such cases, Bulk API is the best option. Batch API processes data in smaller batches than bulk API, resulting in a higher API call usage per operation on large volumes of data.
    • Limit the export row count.
    • Use UTF-8 file encoding for file read and write operations.
  19. Click RUN.
  20. The number of successful or failed records extracted can be seen in the Results of Last Run section. You can view the records or download them to your local system. The records are generated in ZIP format.

More Options

  1. Edit: Modifies or updates the process details. 
  2. Abort: Aborts the process while it is still running.
  3. Schedule: Sets the schedule at which the process must run.
  4. Delete: Deletes the extract process.
  5. Clone: Creates a copy (clone) of the extract process.
  6. Log: Provides information about the execution of the extracted task.
  7. VR/WFR: ARM lists all the validations/workflow rules that were set. The UI lists all the validation rules, and users have to enable them for the disabled validation rules (if required). For more info, refer to the article: Validation/ Workflow Rules. Sample VR/WFR attached:Validation rulesWorkflow Rules

Was this article helpful?