Activity Forums Salesforce® Discussions How would you suggest to load 7 million records in Salesforce?

  • Ashley

    October 23, 2016 at 7:37 pm

    A customer has 7 million records that need to be loaded into Salesforce. How would you suggest to load these records?

    1. Data Loader
    2. Use a third party data loading tool
    3. Data Import Wizard
    4. It is not possible to load 7 million records.
  • Vikas Kumar

    January 23, 2017 at 10:38 am

    Hi Ashley,

    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 App Exchange for 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.

    Use the import wizards when:
    You are loading less than 50,000 records.
    The object you need to import is supported by import wizards. To see what import wizards are available and thus what objects they support, from Setup, enter Data Management in the Quick Find box, then select Data Management.
    You want to prevent duplicates by uploading records according to account name and site, contact email address, or lead email address.

    For this Scenario you need to use Third Party tool


Viewing 1 - 2 of 2 posts

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos