Skip to main content
TrustRadius

Overview

What is Jitterbit?

Jitterbit is a cloud integration technology for cloud, social or mobile apps. It provides accessibility for non-technical users, including easily creating API’s and data transformation scripts within the integrations.

Read more
Recent Reviews

TrustRadius Insights

Jitterbit has been widely utilized as a middleware solution, enabling seamless integration between various systems and platforms. Users …
Continue reading

Does the job!

8 out of 10
April 05, 2019
Incentivized
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 …
Continue reading
Read all reviews

Popular Features

View all 6 features
  • Monitoring console (10)
    9.3
    93%
  • Pre-built connectors (11)
    8.9
    89%
  • Support for real-time and batch integration (11)
    8.6
    86%
  • Connector modification (11)
    7.2
    72%
Return to navigation

Pricing

View all pricing

Jitterbit

$100.00

Cloud
Starting Price Per Month

Entry-level set up fee?

  • No setup fee
For the latest information on pricing, visithttp://www.jitterbit.com/platform/prici…

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Starting price (does not include set up fee)

  • $1,000 per month
Return to navigation

Product Demos

Amplify Salesforce with Jitterbit Integration

YouTube

Jitterbit Harmony Summer Release '14 is here!

YouTube

Jitterbit Solution NetSuite-Shopify Order to Fulfilment Demo

YouTube

Jitterbit Solution Salesforce-NetSuite Quote-to-Cash Demo

YouTube

Jitterbit Speeds ServiceMax Integration with SAP Back office ERP

YouTube

NetSuite Integration - Jitterbit 5 Minute Demo

YouTube
Return to navigation

Features

Cloud Data Integration

Cloud data integration software simplifies the task of integrating data from multiple different cloud applications

8.4
Avg 8.2
Return to navigation

Product Details

What is Jitterbit?

Jitterbit combines APIs, integration and artificial intelligence. Using the Jitterbit API integration platform companies can rapidly connect SaaS, on-premise and cloud applications and instantly infuse artificial intelligence into any business process. This API creation technology enables companies to reuse business-critical applications and data to bring new offerings to market faster. Additionally, Jitterbit's industry experts work side by side with users' companies to accelerate innovation.

Jitterbit Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Jitterbit is a cloud integration technology for cloud, social or mobile apps. It provides accessibility for non-technical users, including easily creating API’s and data transformation scripts within the integrations.

Jitterbit starts at $1000.

Reviewers rate Monitoring console highest, with a score of 9.3.

The most common users of Jitterbit are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(44)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Jitterbit has been widely utilized as a middleware solution, enabling seamless integration between various systems and platforms. Users have leveraged Jitterbit to move data between systems such as Oracle DB and Salesforce, NetSuite and Salesforce, and legacy ERP systems and Salesforce. The software has eliminated the need for extensive development in Java or Net, allowing users to efficiently transfer data without writing code. It has proven to be invaluable in managing data flow between multiple systems, ensuring accurate and consistent data across platforms. Users have praised Jitterbit's features such as operation chaining, email notifications for success or failure, logging, scripting, and conditional mapping. Additionally, the user-friendly UI and field mapping tool have been commended for their ease of use and ability to streamline complex integration processes. Jitterbit's capabilities have been particularly beneficial in implementing Salesforce solutions, integrating HR systems with other departments for improved data management, and facilitating seamless sales order and shipping integration for eCommerce sites.

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.

  1. Migration Issues: Some users have encountered difficulties with migrating updates to existing jobs in production, resulting in duplicated project items that need to be manually removed.
  2. Lack of Error Trapping: Reviewers have expressed frustration with the lack of trapping under-the-covers SOAP errors, such as when a query takes too long in Salesforce. This can lead to partial file pulls without proper failure notifications.
  3. Limited Debugging Capabilities: Several users have mentioned that the software's debugging capabilities are lacking. They suggested improvements such as adding checkpoints to track variables and a debugger, as well as enhancing logging options for better post-runtime review of integrations.

Users of Jitterbit have made several recommendations based on their experiences with the software. The most common recommendations include utilizing Jitterbit for integration needs, having a trained administrator to fully utilize its flexibility, and investing time in understanding the data flow between endpoints. Overall, users highly recommend Jitterbit for mid-size organizations aiming to scale at the enterprise level. They find it simple yet secure, with no hidden gaps or pricing surprises. Users suggest exploring Jitterbit's product offerings by reaching out to their team while taking into consideration the depth of scripting expertise required for Jitterbit developers.

Attribute Ratings

Reviews

(1-12 of 12)
Companies can't remove reviews or game the system. Here's why
Laura Sponaas | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized

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)


  • 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.
  • 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.
Salesforce ETL needs, DB-to-DB ETL needs, RESTful API needs, etc.
Laura McDonough, PMP | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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
  • 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"
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • Easy to connect systems without the use of developers
  • Provides a single management interface for all integrations
  • Highly stable and reliable
  • 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
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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.
  • 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.
  • 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.
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!
Score 8 out of 10
Vetted Review
Verified User
Incentivized
It is being used by out Engineering department to push data from Fusion Life Cycle to NetSuite.
  • Automating the push of data has been a Godsend -- We were doing this entire process manually
  • Adding or making a edit has been a fairly easy process
  • The time it has saved us allowed us to not hire another person
  • Would be nice to see more examples how to do some things -- Would like to see how to go from NetSuite Data base to Excel.
If you are having to do manual work for this type of process this is the only way to go
Score 8 out of 10
Vetted Review
Verified User
Incentivized
Jitterbit was used to process royalty statements from multiple licensees. And Jitterbit was used to streamline the data from multiple sources into our database.
  • It handles different sources very efficiently.
  • Programming in Jitterbit and the available plugins is simple and very effective.
  • User administration permissions provisioning is easy.
  • I would expect more math functions to be added as we had few issues while rounding the numbers.
  • Currently I believe the rows are getting processed one by one, it would be beneficial if we could do a bulk insert options into SQL too.
Jitterbit is well suited for handling multiple files. Where company policies have multiple dev environments, it would require the purchase multiple licenses.
Travis Terry | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
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.
  • 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.
  • 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
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.
Don Waters | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
We used Jitterbit Standard Edition for our client to integrate two 2 endpoints. One was Salesforce, a SaaS-based CRM system and the other was Sage MAS 200 ERP (formerly MAS 90). Sales Orders are entered to Salesforce and then upon update are sent to Sage MAS 200 ERP as an import process via the Visual Integrator module. We also have bidirectional update of Ship to Addresses , Customer records, and Item records.
  • Great for endpoint to endpoint integration where data transformation is an important component of the process.
  • Visual nature of the mapping is very good and the general visual layout of the processes employing these mappings is also very good.
  • Copying of process and mappings make the integration a lot easier than it would otherwise be.
  • Scripting language takes some getting used to depending on your programming background.
  • There is a lack of some standard template procedures that could be used to create variations from the template. This would be very beneficial.
  • Logging utility needs a re-write since the filtering is not very intuitive and sometimes is not very effective.
If you are looking at standard integration with an existing Enterprise Connector like Salesforce, SAP or Oracle, then this is a great tool. It is a little more difficult when one of the endpoints has some limitations. Our MAS endpoint was problematic, at best. The lack of ODBC updates on that end made for some serious issues. This is not due to Jitterbit, but the MAS product itself, so this is a word to the wise to be sure that all of your endpoints have what you need to get the job done in a reliable and verifiable way. You will need the ability for both endpoints to report back the status of all updates. Without that capability, the job can quickly become difficult. Again, this is more about the endpoints than about Jitterbit, which is a robust SaaS integration platform.
Crystal Steinbach, MBA | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
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.
  • Data Export
  • Field Mapping
  • Mass Delete
  • Salesforce ID lookup too
  • Ease of use
  • Better error reporting
I can only say that Jitterbit integrates well with Salesforce.com as I have yet to use Jitterbit for any other integrations.
Score 6 out of 10
Vetted Review
Verified User
We have Veeva which is an application on SFDC which is our CRM system. Jitterbit us used as an application for pulling the data to our data warehouse and pushing our updates/data to the Veeva cloud. It is mostly used in the Pharma Healthcare business of Bayer. We migrated to Veeva from Siebel in Jan 2013 and since then we have been using Jitterbit. I have been supporting Jitterbit since 9 months. We have come across many data related issues along with some process related. I can mention the ones which I faced myself and how i interacted with the Jitterbit Support Team. There are issues with pulling the long/free text fields. Also, there was one scenario where null values were being populated instead the actual value. These are all dbUpdate Plugin related issue. The log which Jitterbit creates is not self sufficient neither self explanatory. I think it could give more detailed log for troubleshooting the issue. If the plugin was updated by the Jitterbit team, it was not properly tested and was provided for us to migrate it to our Production environment and it disturbed the whole environment. I think there should be a process in place for validation and verification of any updates given to the customer.
I did work closely with the Jitterbit support team . They are very helpful and prompt.
  • Good support team
  • Does not use complicated code
  • Users can easily understand the structure
  • Need better performance with SFDC cloud
  • Need to have a better process aligned
  • Need to improve the log so that it is self ecplanatory to troubleshooting an issue
According to my experience, I think it has to come up with much compatability with SFDC cloud.
Jules Clement | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
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.
  • 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.
  • 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.
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.
Return to navigation