Jitterbit

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.

Reviews

25 Reviews

Jitterbit iPaaS Review

Rating: 7 out of 10

Incentivized

May 7, 2024

Use Cases and Deployment Scope

We use Jitterbit for integration projects. Mainly to integrate different systems with each other such as NetSuite, Shopify, MYOB, Database, APIs. The use cases varies from data synchronisation, to exposing the organisation's business entities as APIs. Also, lately, EDI capabilities has been added to perform B2B integrations. The platform is able to perform all these types of integrations admirably. Also, since it can be hosted on premise, the platform can easily integrate onpremise and cloud-based systems with no issues

Pros

General purpose integration
Transformations
Integration with behind-the-firewall systems

Cons

User experience
Logical operators connectors
Stability of the platform

Likelihood to Recommend

General purpose integration among different systems where investment in more expensive options is not an option. For example, the platform can integrate with APIs, Databases, FTP, SFTP folders as general connectivity protocols, but also Jitterbit exposes a wide range of specific 3rd party connectors as such NetSuite, Shopify, Microsoft, AWS, and Google connectors. Scenarios where clients require advanced API features might not be well suited to Jitterbit as their API Manager is very basic.

Fadi Dagher

Solutions Architect in Information Technology at United Techno (51-200 employees)

Vetted Review

2 years of experience

View profile

Jitterbit - Jack of all Trades, Master of ETL

Rating: 10 out of 10

Incentivized

April 9, 2019

Use Cases and Deployment Scope

We have 15 Jitterbit projects in production right now (housing about 5 times as many jobs/operations that run at various times of the day/night) and QA/DEV environments that mirror those projects. Currently, these jobs primarily move business data to and from our Salesforce org. We are currently also looking at Jitterbit's API creation and management capabilities for real-time data needs, but have not put anything info production yet... only QA.

Integrations we currently have (Source/Targets):
Oracle ↔️ Salesforce
SQL ↔️ Salesforce
FTP ↔️ Salesforce
Salesforce ↔️ Salesforce
Local File ↔️ Salesforce (Used in Jitterbit Cloud Dataloader for one time import/exports)

Jitterbit Features we Use: *Including, but not limited to the list below*
Operation Chaining
Email Notifications (success or failure)
Logging (WriteToOperationLog)
Scripting
Operation Chunking
Project Variables for source/target credentials
Conditional Mapping
StringToHex/Base64Decode for creation of varBinary SQL data
Get/Set Last Run Time – for pulling only modified records since last successful run
SQL Target Db Pre-script - Include Null Updates
Temporary Storage (for csv files to use further down Operation chain)

Pros

Logging - totally configurable by the user, you can log any details about your running jobs, online (WriteToOperationLog) or to an email.
Cloud management environment. Can manage users and/or the running of operations from the website and do not need a client application to do so.
Client application is full featured and allows for greater control than our last "EDI"-type product we owned.
Operation-chaining -- a necessity! And it works well.

Cons

Migrating operations from QA to Production work well for initial deployment, however, when migrating an update to an existing job to production, sometimes certain project items are duplicated. This is not the end of the world... the duplicates can be removed, but would be nice if it was not required.
I have not found a way to trap under-the-covers SOAP errors (for example, when a query you are running against Salesforce takes too long). You get a warning error in the operation log that the job only pulled a "partial" file, but it does not fail.

Likelihood to Recommend

Salesforce ETL needs, DB-to-DB ETL needs, RESTful API needs, etc.

Laura Sponaas

IT Developer Architect in Information Technology at Herman Miller (5001-10,000 employees)

Vetted Review

3 years of experience

View profile

Flexibility and ability for non-technical users to manage

Rating: 9 out of 10

Incentivized

April 8, 2019

Use Cases and Deployment Scope

We use Jitterbit to manage the flow of data between multiple systems. While managed by one department, it synchronizes data and transformations to support processes across multiple departments. Our main objective is to create a clear flow of data, ensure the system of record is that data is accurate and consistent across platforms.

Pros

Ease of use - while being more technical is useful, you don't need to be a developer to use many of JItterbit's capabilities
Customer Support - we have always had great responsiveness to any questions or issues encountered
Reliability - Jitterbit has been extremely reliable with no major outages in the recent past

Cons

Integration recipes for more platforms - e.g. JIRA
Fewer upgrades - there are upgrades every couple of weeks so if you are not using the cloud version, you need to manually "keep up"

Likelihood to Recommend

Jitterbit is suited for organizations where you need to move data from one system to another, and/or transform it while doing so. It's great for moving data between popular products in use by many enterprises today including Salesforce and NetSuite. It's also well suited for organizations who cannot afford to keep an integration developer on staff. Since Jitterbit makes available many recipes to map data between popular applications, a well-trained business user could handle many of the configurations.

Laura McDonough, PMP

Vice-President, Business Operations & PMO in Information Technology at HotSchedules (501-1000 employees)

Vetted Review

3 years of experience

View profile

Great way to integrated Cloud-to-Cloud or Cloud-to-Onprem

Rating: 9 out of 10

Incentivized

April 8, 2019

Use Cases and Deployment Scope

We use Jitterbit to sync cloud systems to on-premise systems in a bi-directional way. Specifically, we link Salesforce and Great Plains by integrating Sales Orders, Purchase Orders, and inventory transactions. We also use Jitterbit to connect cloud systems -- specifically, our eCommerce site (Magento and Spree Commerce) with Salesforce around Sales Orders, Shipping Confirmations and Inventory.

Pros

Easy to connect systems without the use of developers
Provides a single management interface for all integrations
Highly stable and reliable

Cons

Some of the more advanced transformation possibilities aren't exactly clear without a lot of digging. Very basic connections (e.g. map this field to this field) along with basic transformation scripts (e.g. multiply X * Y) are super easy. But I know there are a ton more features and functionality that I feel is somewhat buried in the product

Likelihood to Recommend

If Jitterbit offers a connector for the endpoint (and it's constantly adding new connectors) then the integration is super easy and can be implemented at very low cost...possibly by in-house IT resources with no developers/specialists. Jitterbit also offers the ability to connect to more generic web SOAP services and API endpoints -- these connections require a little more technical knowledge, but are also very straightforward to set up. Jitterbit can also expose all of the transform operations as its own API endpoint. So if there's a need to execute one of the Jitterbit operations from a foreign system (web site, mobile app, or other systems) it's really easy to expose it as an API endpoint, essentially offering the ability to host an internal or external facing web service for anything that lives within Jitterbit.

Verified User

Vice-President in Information Technology (51-200 employees)

Vetted Review

3 years of experience

Does the job!

Rating: 8 out of 10

Incentivized

April 5, 2019

Use Cases and Deployment Scope

We have been using Jitterbit for a few years now and it's a well-designed product. We use it to integrate Banner with other auxiliary systems.

Pros

It has made integrating our systems easier
The customer service is great.

Cons

I would like to see some enhancements such as better logging capabilities and version control.

Likelihood to Recommend

Integrating Salesforce with Banner and other systems is well documented and easy to implement.

Ravi Agarwal

Director of Enterprise Architecture and DevOps in Information Technology at St. Norbert College (201-500 employees)

Vetted Review

5 years of experience

View profile

Jitterbit, Easy to use yet effective and powerful

Rating: 8 out of 10

Incentivized

April 3, 2019

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.

Dudu Elmaleh

Salesforce Developer in Professional Services at Uptima (11-50 employees)

Vetted Review

3 years of experience

View profile

Jitterbit is a huge timesaver

Rating: 10 out of 10

Incentivized

March 30, 2019

Use Cases and Deployment Scope

I use Jitterbit primarily for the data loading capabilities into Salesforce. Its ability to schedule jobs and store multiple logins and connections has been the big time saver for me and my department. It also allows you to easily store the connections to the files and extracts that you use frequently to make repeatable interactions even easier.

Pros

Using Jitterbit with multiple Salesforce orgs. If you have to load/query into more than one org, the ability to save your connection information and easily switch between connections is a huge time saver. You can also access the same files for multiple orgs as needed.

Cons

It took a little while to get used to remapping fields. Once you get the hang of the refreshing and remapping it works very well, but there was a bit of a learning curve to it.
Some of the UI interactions aren't super intuitive. Closing tabs or getting to the right one can be a little difficult at times.

Likelihood to Recommend

Jitterbit is excellent for extracts and loading into Salesforce. It is a great replacement for some of the standard Salesforce options, the data loader, and the data import wizard.

Verified User

Director in Sales (501-1000 employees)

Vetted Review

8 years of experience

Great tool that will have your data in the cloud within minutes.

Rating: 9 out of 10

Incentivized

March 30, 2019

Use Cases and Deployment Scope

We have always used Informatica for our data integrations—first the on-prem version for many years and recently branching out into the Cloud version as we began our journey into a Salesforce rollout. It became clear to us IICS was not the right tool for the job with Salesforce or any of our SaaS integrations, so we experimented with Mulesoft and Jitterbit. Over the last year, we have become mostly a Mulesoft shop now, with some of our smaller and less supported apps still leveraging Jitterbit. I would say we are 20% Informatica Power Center, 60% Mulesoft and 20% Jitterbit. Currently, Jitterbit is only used for the smallest portion of our Salesforce integrations, shuttling data back and forth between our internal legacy CRM system and the external Salesforce cloud.

Pros

Some of the pieces we wanted to bring into Salesforce were quite complex, but Jitterbit handled it easily. It’s like it learns from past experiences and you benefit from someone, somewhere having gone through this before.
Easy to set up and get going from the start. It was only a few minutes after going through the set-up process that we were able to migrate data over from our internal system to the cloud.
Planning ahead for some of our AI-driven analytics, I think Jitterbit should be able to handle those well, it’s got a nice interface that walks us through what we need, as long as you are starting from a position of knowledge before attempting it.

Cons

There is a bit of a different look and feel to Jitterbit than the other ETL packages we were used to. Not bad different, but took just a little getting used to.
Pricing was higher than some of the other ETL tools we looked at, and we could not really understand why. It has the same ups and downs that any other tool has, so it wasn’t a complete package to give you a one-stop-shop, so we could not see why you would pay more for the tool over others in its class.
The connections were a little less than spectacular when comparing against Mulesoft. Sometimes you need a little more flexibility and we found it harder to be flexible with Jitterbit than other tools.

Likelihood to Recommend

This is a great tool for bringing data out of your locked, internal systems and getting it into the cloud. It meshes well with Salesforce and is fairly easy to use, helping the transition from other older, more complex tools into a more modern environment. It has lots of competition in this space and some are better than others, but if your data is straight forward and you know it well, Jitterbit will get the job done. If you are not as close or comfortable with your data and need to do some wildly complex migrations, there might be better packages out there for you.

Verified User

Manager in Finance and Accounting (10,001+ employees)

Vetted Review

1 year of experience

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

Rating: 9 out of 10

Incentivized

August 21, 2018

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!

Verified User

Manager in Professional Services (51-200 employees)

Vetted Review

2 years of experience

Jitterbit for Data Loading

Rating: 9 out of 10

Incentivized

August 8, 2018

Use Cases and Deployment Scope

We are using Jitterbit to import external data sources into Salesforce. We also use it to move data from one Salesforce org to another. This has helped create a more streamlined data integration process. It has also allowed us to set up transformations within our data sources. Another use instance is picking up files from our sftp site to prevent manual intervention.

Pros

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

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

Likelihood to Recommend

Loading multiple sources, transforming data, moving date from one org to another. We also receive a non profit discount as a university which helps make the tool affordable for us. We are exploring it to move data from our customer relationship management system to our student information system or system of record.

Wendy Hamstra-Smith

Associate Dean of Admission at Saint Louis University (1001-5000 employees)

Vetted Review

1 year of experience

View profile

Loading Reviews List....

Great tool that will have your data in the cloud within minutes.

Rating: 9 out of 10

Incentivized

March 30, 2019

Use Cases and Deployment Scope

Pros

Some of the pieces we wanted to bring into Salesforce were quite complex, but Jitterbit handled it easily. It’s like it learns from past experiences and you benefit from someone, somewhere having gone through this before.
Easy to set up and get going from the start. It was only a few minutes after going through the set-up process that we were able to migrate data over from our internal system to the cloud.
Planning ahead for some of our AI-driven analytics, I think Jitterbit should be able to handle those well, it’s got a nice interface that walks us through what we need, as long as you are starting from a position of knowledge before attempting it.

Cons

There is a bit of a different look and feel to Jitterbit than the other ETL packages we were used to. Not bad different, but took just a little getting used to.
Pricing was higher than some of the other ETL tools we looked at, and we could not really understand why. It has the same ups and downs that any other tool has, so it wasn’t a complete package to give you a one-stop-shop, so we could not see why you would pay more for the tool over others in its class.
The connections were a little less than spectacular when comparing against Mulesoft. Sometimes you need a little more flexibility and we found it harder to be flexible with Jitterbit than other tools.

Likelihood to Recommend

Verified User

Manager in Finance and Accounting (10,001+ employees)

Vetted Review

1 year of experience