TrustRadius: an HG Insights company

Jitterbit Professional, Scientific, and Technical Services Reviews & Insights

Score7 out of 10

44 Reviews and Ratings

Community insights

TrustRadius Insights for Jitterbit are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Pros

Versatile Data Integration: Users have found Jitterbit to be a highly versatile tool for data loading, mapping, and integration between different systems. Several reviewers mentioned that it allowed them to streamline their data processes without the need for coding, making it much easier to manage and connect SalesForce and NetSuite.

Configurable Logging and Notifications: The configurable logging feature in Jitterbit has been highly valued by users. Many reviewers have mentioned that it provides clear visibility of the progress and any potential issues in running jobs. Additionally, the ability to receive notifications online or via email has helped users stay informed even when they are not actively monitoring the system.

User-Friendly Interface: Reviewers appreciate Jitterbit's user-friendly interface compared to other similar products. Multiple users have stated that it does not require developer skills to utilize its capabilities effectively, empowering non-technical users to take ownership of the integration process. This ease-of-use aspect is seen as a significant advantage by many customers.

Jitterbit Reviews

8 Reviews
Professional, Scientific, and Technical ServicesInformation Technology & Services5Management Consulting2Marketing & Advertising1

Jitterbit, Easy to use yet effective and powerful

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We at Uptima are experts in Field Service and Quote to Cash Implementation. When building an end-to-end solution, a reliable integration is a key component.

Jitterbit helps us complete our complete solution delivery with their ability to integrate with various systems (cloud or on-premise), databases and machines. Their strong Salesforce integration capabilities and easy to use wizards are key when implementing Salesforce solutions.

Pros

  • Built-in Salesforce wizard - for Salesforce projects, the wizard enables you to achieve the basic integration structure with easy to use wizards for all DML operations: Query, Upsert, Insert, Update and Delete.
  • Scripting - when you need something more complex in your integrations, the script option will give you extended capabilities to handle those tough spots with a lot of built-in functions.
  • Migration - while doing migrations is usually hard and painful, Jitterbit migrations are simple and fast. Using their migration tool, going from Dev -> QA -> Prod is a very simple process.

Cons

  • Debug - integration can get complicated and sometimes strong debug capabilities are needed. adding checkpoints to track variables and a debugger can be big improvement.
  • Logging can be improved, adding rich text options and other logging formats can assist when reviewing integration after run time.
  • Version control - they should have the option to hold revisions on any object.

Likelihood to Recommend

Suited for any integration project, especially Salesforce integrations. I did not encounter any project we did in the past where Jitterbit could not handle the requirement. It has all the capabilities and options you need, and yet it is still easy to use, easy to install and easy to maintain.

Great program that is easy to use and free for data integrations with Salesforce

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

We use Jitterbit to integrate data between our payroll system, HR Pyramid/PRISM HR, and Salesforce to maintain contact records, accounts records, prospect records, and a few custom objects like benefit records. This is currently a one-way feed into Salesforce, but we are investigating using it to transfer data out from Salesforce to third-party insurance carriers, vendors, and our payroll system. It was originally set up by a consulting firm that helped stand up Salesforce. The UI is extremely user-friendly so that when we need to modify field mappings I can go in as a superuser/admin and confidently make the changes. This is a great program since it's free and has a fairly low learning curve. I'd recommend it for small to medium-sized companies that have limited resources and budget restrictions.

Pros

  • UI is super easy to understand with a low learning curve so admins can figure it out and maintain it without breaking anything.
  • It's FREE! There's a paid version too but I like that you can use most of the features for free and they're not pushy with buying.
  • There's a great user community that you can google and ask any questions. Most problems I've encountered have been posted and answered already.

Cons

  • It's not very easy to create backups of your field mappings so if you break something you can't just "rewind" the clock and unbreak it. The paid version offers a backup feature but even that is not super user-friendly.
  • Larger companies probably don't have much use for this. I'm at a much larger company now and we handle such system integrations with more advanced tools.
  • Sometimes we've had downtime from Jitterbit just due to the nature that it has to be hosted on a remote server. Our server was aging and had down times which affected Jitterbit.

Likelihood to Recommend

Small to medium sized companies are great prospects for this product. It's pretty easy to set up, learn and maintain. You can scale it too, so start with an easy integration, learn the ropes and expand your usage. If you have fairly simply needs for a handful of fields and just one or two external systems to feed into Salesforce, this is the go-to product.

If you're a larger company needing more complex integrations where extremely high reliability is needed and any downtime means revenue loss, you probably already have a different product in mind. Then again, you probably have an entire team that handles integrations and a data warehouse to support it!
Vetted Review
Jitterbit
2 years of experience

Great solution for salesforce admin

Rating: 8 out of 10
Incentivized

Use Cases and Deployment Scope

We use it for salesforce [administration] to try and import/update/amend data en mass.

Pros

  • Viewing data mappings
  • Having lists of historic maps
  • Getting granular in the way you update records

Cons

  • It can't handle some characters like : ; ) etc., in the field name which is really annoying as you don't realise it until you try to run the load.
  • Sometimes the process can be flaky and just not work for any good reason but that is rare.

Likelihood to Recommend

For general salesforce updates, I use it all the time over and above Salesforce Data Loader or dataloader.IO.

Jitterbit Data Loader - The best solution for Salesforce data operations

Rating: 9 out of 10
Incentivized

Use Cases and Deployment Scope

I've been using the Jitterbit data loader for all my Salesforce data needs for about 4 years. It is far superior to the standard Salesforce Apex Data Loader in so many ways. I know many other consultants in my organization and others who use it to manipulate data in Salesforce.

Pros

  • Preserves mappings so that you don't have to redo them. This was my biggest frustration with Salesforce's Apex Data Loader. I believe they may have added this functionality now but Jitterbit does this well and I'm not interested in switching back.
  • Platform independence: I recently had a customer that required consultants to use MacBook Pros. My company laptop is a PC. Since Jitterbit is cloud-based, I was able to create mappings on one computer and execute them on the other.
  • Ease of use: Jitterbit is simple to use and has a very intuitive interface. It auto-creates log files so that you can review the results of your data operations.

Cons

  • One recent complaint is that I kept getting prompted in the application to upgrade but when I clicked the upgrade button I received a cryptic error. It didn't seem to affect the application fortunately. This occurred on both the Mac and PC versions.

Likelihood to Recommend

My experience to this point is only with the free version.

Jitterbit connecting ERP and SFDC

Rating: 8 out of 10

Use Cases and Deployment Scope

We are using Jitterbit to move data from an old legacy ERP system into Salesforce.com. We are currently using it in our sales and marketing department but we are considering using it as well in our HR department to further integrate data between their systems. Because I pull information from an old ERP system, I do have to manually clean the files before import using Jitterbit. It does take a good deal of time and focus to ensure my imports are going as needed. I would like to see an automatic lookup field in Jitterbit for the Salesforce.com record ID. That would make my imports go much more quickly. I really like the field mapping tool. It's very easy to use and to add various rules and filters. It's a good solution for our needs. It's helpful to have some technical savvy before diving in.

Pros

  • Data Export
  • Field Mapping
  • Mass Delete

Cons

  • Salesforce ID lookup too
  • Ease of use
  • Better error reporting

Likelihood to Recommend

I can only say that Jitterbit integrates well with Salesforce.com as I have yet to use Jitterbit for any other integrations.

Jitters of JitterBit

Rating: 4 out of 10

Use Cases and Deployment Scope

Jitterbit was used to automate the ETL engine running across several databases to populate the data warehouse. It integrated very well with the SQL/MYSQL interface and worked seamlessly. It addressed the problem of product integration from various departments and saved company a lot of money as additional manpower was not required. Jitterbit was used only in the IT department.

Pros

  • Integration to multi platform tools
  • Pipelining a complicated workflow
  • Messaging and jogging for critical workflows

Cons

  • GUI
  • It needs to have a better API and some example codes
  • Sometimes it's pretty slow

Likelihood to Recommend

The key question would be, does my application fit into a workflow model? If Yes then Jitterbit can help. Standard interfaces such as XML and logging between the various modules would definitely help to understand the jargon given out by Jitterbit. Overall the learning curve is not so steep for Jitterbit.
Vetted Review
Jitterbit
1 year of experience

Rapid Data Integration

Rating: 8 out of 10

Use Cases and Deployment Scope

I implemented a data integration project for a client. Jitterbit was used specifically to grab data from all over the world and copy it into a staging database. It had some data transformations, but nothing very complex.

Pros

  • The time to transfer millions of rows from China or South Africa was remarkable, it was very quick.
  • We never dropped rows or lost data.
  • It was very easy to pick up and learn how to do a simple data transfer.

Cons

  • Since I was grabbing data from seven identical systems, I would prefer that I could copy and paste an operation and just change the connection. Instead, I had to remap every transformation I made. Still, it was a time saver to be able to copy it.
  • I wish the programming of more complex transformations were less code-based and more GUI-based. Without knowing java syntax it made even some simple transformations difficult.
  • It was too easy to overwrite other developers code. A merge feature would have come in handy more than once.

Likelihood to Recommend

Unless you want to do a lot of coding, it's not ideal for an ETL scenario. But it's very good with transferring large volumes of data quickly with simple transformations.

Jitterbit Great Middleware

Rating: 9 out of 10

Use Cases and Deployment Scope

We are using JitterBit on a number of projects. We use it to load data from a FTP directly into Sales Force these daily file loads give people access to the front end we developed on force.com. We also use JitterBit as a middleware for a different SalesForce projects where we load order data from an Oracle DB back up to Salesforce with all the item and tracking information. And lastly we use JitterBit as a Web Service Endpoint that we call from NetSuite do a transformation and load the data back into Salesforce. Jitterbit has taken out a large layer of development in either Java or .Net and just about anyone can move the data with out writing a line of code. Ok so there is still some basic javascript to write to do more custom things with the data but it is very basic stuff.

Pros

  • Loading data
  • The ability to easily change, map or upsert to and from SalesForce and NetSuite.
  • Creating an Endpoint Web Service without writing any code.

Cons

  • I only see a few drawbacks with Jitterbit but every time I see one they are already in the process of fixing this.
  • We ran into an issue where were were doing and If Else loop query in salesforce that was using thousands of API request during the operation and they were already working on a Map Cache for this problem.
  • Back when we first started working with JitterBit we had an issue of connecting to NetSuite but since then they have built connectors for NetSuite using their built in WSDLs

Likelihood to Recommend

We have had great luck integrating our databases here which are Oracle and SQL server with Salesforce. Anyone that is looking for a middleware with Salesforce should check this product out! We have also found that we can easily load giant million-record files into database from flat files that couldn't be done nearly as fast as we could through our developers.