• #39206
     Anjali #8
    Forcetalks

    When do we use the data loader in Salesforce?

    When do we use the data loader in Salesforce?

     

    #39215
    Salesforce | Pavan Pavan #45
    Forcetalks

    Based on the records count  , Dataloader will be used

    Dataloader is an application for Bulk import or export of data

    In which cases it will be used?(Below are the answers)

    1.If your requirement is to insert more than 50,000 then in such cases dataloader will be used. (Maximum 5million records it will be allowed)

    2.If you want to export your data for backup purpose it will be used

    3.It will be helpful in scheduling regular data loads such as nightly imports

     

    #39296
    Forcetalks

    Hi,

    Use Data Loader when:

    • You need to load 50,000 to 5,000,000 records. 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 AppExchangefor a suitable partner product.
    • You need to load into an object that is not yet supported by the import wizards.
    • You want to schedule regular data loads, such as nightly imports.
    • You want to export your data for backup purposes.
    #39319
    Forcetalks

    The data loader allows you to insert, update, upsert and delete data. What is upserting you ask? Upsert is a combination of updating and inserting. It means that if a record in your file matches an existing record in your CRM the existing record will be updated with the information that the file contains, if there is no existing record a new record will be created. In other words this means you can add new records or modify or delete existing records. Once you start using the data loader you can define which of these operations you want to perform.

    #39610
    Salesforce | Parul Parul #2
    Forcetalks

    Adding some points:

    Data Loader offers the following key features:An easy-to-use wizard interface for interactive use
    An alternate command-line interface for automated batch operations (Windows only)
    Support for large files with up to 5 million records
    Drag-and-drop field mapping
    Support for all objects, including custom objects
    Can be used to process data in both Salesforce and Database.com
    Detailed success and error log files in CSV format
    A built-in CSV file viewer
    Support for Windows and Mac

     

    Thanks

    #39618
    Salesforce | shariq shariq #1
    Forcetalks

    If you need to load more than 5 million records, we recommend you work with a Salesforce partner or visit the AppExchangefor a suitable partner product.
    You need to load into an object that is not yet supported by the import wizards.
    You want to schedule regular data loads, such as nightly imports.
    You want to export your data for backup purposes.

    You need to load 50,000 to 5,000,000 records. 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 AppExchangefor a suitable partner product.
    You need to load into an object that is not yet supported by the import wizards.
    You want to schedule regular data loads, such as nightly imports.
    You want to export your data for backup purposes.

    hope this helps

Viewing 6 posts - 1 through 6 (of 6 total)

Please to reply to this topic.

CONTACT US

We're not around right now. But you can send us an email and we'll get back to you, asap.

Sending

About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials

or    

Forgot your details?