We use Salesforce.com extensively, and we have found Jitterbit to be a much easier tool to use than the standard data loader. We use it to mass update all objects in Salesforce (mainly opportunities and accounts) directly from CSV files. Any department that requests data changes in our database technically has use for it, but operations and finance folks are the ones who actually put the program to use. Simply having the object ID gives you the power to automatically update tons of SFDC objects, which saves us a lot of valuable time.
- Mapping spreadsheet columns to object fields is very intuitive and easy to figure out
- Very speedy, considering the amount of information I am inputting. Pushes a list of failures with detailed reasons, which allows me to go back and fix as needed
- I felt extremely comfortable using the software within about 2 days... It was very easy to learn
- Infinitely easier to understand than the stock Salesforce data loader
- Mapping fields could provide a link to explain what the field is in more detail
- Hard to visualize the impact that your mapping will have, might be helpful to load in object IDs and lay out the old value and what the new value stands to be
- Jitterbit and other data loaders increase my productivity immensely. Without data loaders, most of my time would be filled with manual data entry instead of data interpretation and analysis
- Co workers appreciate the quick turnaround on data tasks, they are always impressed at the large changes of data in small amounts of time
Jitterbit works flawlessly for simple data loading tasks. Anything more complicated, such as deduping objects or cleaning data on a grid would require a more substantial program such DemandTools, but for small, ad-hoc tasks Jitterbit is hard to beat.
Without Jitterbit I would spend a TON more time on manual data entry. It is a simple fact that this frees up a lot of time to focus on more involved tasks like analysis or interacting with co-workers/customers.
I have used DemandTools and Jitterbit, and I would always recommend Jitterbit for the more straightforward, lightweight jobs. The simplicity makes changing 1 or 2 fields a breeze.