Jitterbit

Ease your Integration

Vorteile:

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.

Nachteile:

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

Fantastic Salesforce ETL Integration Application

Kommentare: We have several scheduled integrations between an internal SQL database and Salesforce and have been very happy with the Jitterbit application.

Vorteile:

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.

Nachteile:

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.

Best for simple integrations; not recommended for complex ones

Kommentare: Note that we decided to exclusively use Cloud Studio as Jitterbit plans to decommission the desktop studio application eventually. Jitterbit is a clever idea for a product which could make simple, 1:1 file integrations graphical and easy to understand, but for our integrations it is not as reliable or as efficient as simply using an established programming language. We had hoped that it could replace all of our existing integrations and even be turned over to users outside of IT, but what we discovered was that all of our integrations require programming experience and are not maintainable by users.

Vorteile:

It is fairly easy to make initial connections to other systems using Connectors. Variables can be used in connection setup to easily swap out configuration. Entire JSON data structures can be stored to a single variable and passed into other components.

Nachteile:

None of our integrations could be created without using the proprietary scripting language on some level, which sometimes suffers from data type conversion problems. Complex integrations require large amounts of esoteric scripting and managing large amounts of global variables. Lack of appropriate variable scoping often introduces bugs. Error/exception handling must be done manually--there is no try/catch feature. Notification queue type integrations are especially difficult to create. Jitterbit professional services advised against letting projects grow too large as they can become corrupted.The Cloud Studio interface will often silently time out leading to strange behavior or sudden return to the login screen. Projects cannot be tracked by git or other source control. Some changes to project components save automatically making it easy to accidentally break something. JSON schemas cannot be built with the GUI from scratch; you must instead past in a sample, and then you can edit them.The management interface for viewing logs is currently awkward and buggy, requiring manual typing out of filters. Filter wildcards behave inconsistently. A big update to this interface is said to be on the way.

Great Product, Great Service!

Kommentare: We are using Jitterbit in a plethora of ways... To sync and move data between Oracle and Salesforce (both ways), to connect to another systems API interface and pull data into our data lake, to pickup files dropped off from various vendors for us to ingest, and to stock our Data Lake with data from various places. We have realized 50% faster load times, 75% less time spent on maintenance process changes, and wide adoption across our institution.

Vorteile:

It works! We've been using Jitterbit about 3 years now and I still thoroughly enjoy the product. I think what I like best is the modular approach which has saved me tons of time with maintenance and process changes we've needed to make over the years. The service has been great too. Has always been responsive and knowledgeable.

Nachteile:

I honestly can't come up with something I dislike. Documentation was helpful and I referred to it quite often to learn the Jitterbit scripting language and the on-boarding training classes helped us get up and running quite quickly. Licensing by endpoint can get tricky, but Jitterbit has proved to be very accommodating and understanding of our needs and business practices.

JItterbit

Kommentare: Connectivity of our accounting system to our CRM.

Vorteile:

The support we received was very good during the integration process. We started out with a major integration and while there were challenges (there always are), the Jitterbit team was responsive and supported us throughout.

Nachteile:

They did not have anyone who really knew the inner workings of Great Plains. We got there eventually with the help of another supporting third party, but there was a learning curve which led to additional integration time.