Toggle Side Panel
Close search

Activity › Forums › Salesforce® Discussions › what is the difference between Data loader and Jitter bit data loader in salesforce?

Tagged: , , , ,

  • Manpreet

    Member
    April 6, 2017 at 4:10 PM

    Hi saurabh,

    As such I would point you to the AppExchange to read user reviews comparing JB Data Loader to Apex:  http://appexchange.salesforce.com/listingDetail?listingId=a0N300000016ZoVEAU

    Jitterbit Data Loader offers a subset of features and functionality from our core Cloud integration platform.  Included are the same performance features, including complete support for  the Bulk API.

    You can also edit batch sizes on a per-operation basis.   Each operation runs against a specific SFDC object.

    I’d highly recommend that you try Jitterbit Data Loader for yourself — it is easy to install and configure and we offer a number of Youtube videos to help get you started — plus it’s free, so there isn’t much risk, only upside when you realize how much easier it will make your job 🙂

    Thanks.

  • [adinserter block='9']

  • shariq

    Member
    September 18, 2018 at 7:23 AM

    Hi,

    Pros of DataLoader

    Extracting Salesforce attachments in original file format! I do not know of a tool that can do this better, or more efficiently! This is a huge benefit to companies that would like to extract attachments from Salesforce for tasks like data migrations.
    Cross-object data extract within one file. You can pull data from related objects as long as there is a populated lookup from the object you are extracting, to another object (Child or Parent).
    UI is simple and requires very little to no training. Given the acquisition of Mulesoft by Salesforce, I would not be surprised if DataLoader.IO is rolled out as the new global data loading tool for Salesforce.
    Cons of DataLoader
    Since Dataloader.IO is cloud-based, you will find that some objects require you to extract in batches of 100,000. Regardless of the number of fields, 2 or 50, you will need to batch into groups of 100,000 which requires you to use criteria such as data ranges, owners, etc.
    You will need to conform to the date/time formatting within Dataloader.IO, which differs from Dataloader and other similar tools. This is a very minor inconvenience; however, you will need to know the different formats and when to use them.

    Pros of jitterbit :

    Data Transformation – updating multiple sources to use our data dictionary
    Picking up files from our sftp site – removes manual intervention
    Move data from one org to another through Salesforce

    Cons of jitterbit :
    It was difficult to figure out how to export file sources
    We have to pay per integration site so that can be costly if we are using it for multiple sources
    Some of the icons are difficult to determine their functionality

    Thanks

Log In to reply.