Jitterbit

Pros

It supports data integration between multiple systems and platforms with ease. Most of the configuration is point and click, easy to set up. There are hidden features that can replace many other applications. Jitterbit also makes it easy to integrate with legacy system by directly tapping into their data source.

Cons

There needs to be better onboarding of clients to introduce some "hidden" features so that clients can get the full advantage of this powerful software

Pros

Jitterbit makes integrating with Salesforce.com easy. I have been using the product for years at various companies and have yet to find an ETL that makes the integration process as smooth.

The point click interface makes the data mapping available to non-developers and there are many built in transformation formulas that will allow you to complete necessary transformations (ex. If incoming data value = x, then 'y', etc). The success and error handling options provide confidence your scheduled operations are running smoothly and help administrators/users troubleshoot and correct errors quickly. We were able to get an integration with our SQL database completed, including testing, within a couple of hours.

Their customer service team is responsive and willing to spend time helping you solve issues as needed and the price point is competitive.

Cons

We have two Salesforce orgs and in order to integrate to both of them we would have to purchase two endpoints. It would be nice to have a little more flexibility on pricing plans. Maybe based on the number of operations that will be running rather than end point alone.

Alternatives Considered

Reasons for Choosing Jitterbit

Reasons for Switching to Jitterbit

Pros

Easy to use and deployment. Management of integrations.

Cons

Crashes and schema updates are not so robust. Cloud Studio needs a lot of work

Pros

I like that it saves the entire project, not just the mapping (like Salesforce's ETL tools). I like that I can schedule and chain actions together (e.g. do a query, then take that query and do this update). I like that is has removed 1000s of hours of manual data loads each year for us (and than is not an exageration).

Cons

It does have a bit of a learning curve to it and not as many "gaurdrails" as I would like. It would also be nice if the job progress were more transparent, currently it just says running or finished. It would be nice to get a percent complete or time estimate surfaced... or even number completed so far. But those are all minor issues.

Pros

The most important feature that got me interested in Jitterbit was the ability to communicate between multiple endpoints. It provided a means to provide an automated solution for a process that was manually done previously on a daily base. I did not find the tool difficult to learn. It provide a means to address our integration issues between standalone systems.

Cons

I do not have any complaints currently about the product because it is the first of it's kind that I have used. In my mind, I still have a lot to learn to efficiently use and master the tool so I view any encountered issues as an obstacles that I haven't mastered as yet.