Jitterbit Harmony Reviews

• The ease of use and the admin friendly UI for setting up integration.
• The Cloud Console for monitoring and troubleshooting data operations.
• The pre-built Salesforce connectors.

As a Salesforce implementation partner, Jitterbit is our go to recommendation when it comes to Salesforce integration with other systems because of its streamlined, easy UI and wizard-based configuration. Since Jitterbit is built to handle these types of integrations, we have the utmost confidence in recommending it to our customers.

Sometimes additional connectors are needed.

There is also need for:

• Temporary/lookup tables that can be referenced for data, without having to use additional servers.
• Salesforce connectors that work with the Salesforce Streaming API.
• Additional data transformation capabilities like de-duping, denormalization, and normalization.

I have used this solution for three years.

There were no stability issues.

We have experienced some scalability issues, i.e., notably around advanced data transformation, manipulations, and cleansing, which Jitterbit can't do.

The technical support is very good.

The setup is very straightforward.

We have noted that the base level with 3 connections is $2000, but the added bonus is that Jitterbit doesn't charge for any data volume/traffic, which is a good feature.

When providing recommendations, we suggest Jitterbit and Scribe Online as the cloud-based tool options and CloverETL as the on-premise system.

Start simple and build on the complexity.

If you need complex data cleansing, de-duping, denormalization, and/or normalization, then consider a tool such as CloverETL.

For both Jitterbit Harmony ETL and Jitterbit Salesforce Data Loader, I value the following:

• The fluid user interface (probably the most user friendly interface, when compared to its competitors).
• The drag-and-drop functionality used for data mapping.
• The web console that allows you to monitor your integrations remotely from anywhere in the world.

The Jitterbit Salesforce Data Loader has allowed my team to be creative with the cost effective solutions that we propose to clients, since the Data Loader solution is free.

The Jitterbit Harmony ETL tool has allowed my team to architect more centralized integration solutions. Jitterbit is solely used as the middleware technology across multiple end-points.

In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations. Jitterbit can improve in this area.

I have used both versions (Jitterbit Harmony ETL and Jitterbit Salesforce Data Loader) for three years.

We’ve periodically experienced downtime with this tool, although not too often. I would estimate it to be about twice in three months.

We get email notifications stating downtime with one of the regional servers on which the integration cloud agent runs. This is usually disruptive, if it happens during work hours.

There are no scalability issues with the full Jitterbit Harmony ETL version. We experienced some scalability issues with the Jitterbit Harmony Salesforce Data Loader, usually when processing records greater than 50 thousand in a scheduled process.

I would give technical support a rating of 8/10.

• For full integration needs, we used IBM Cast Iron.
• For quick data migration, we used the Apex Data Loader.

We switched primarily because of cost.

The initial setup was straightforward.

I do believe Jitterbit has one of the better pricing and licensing options out there compared to its competitors. However, you can get better pricing from its competitors, if you do a bulk purchase (ETL tool and other applications).

We evaluated the following alternatives:

• Dell Boomi
• IBM Cast Iron
• IBM WebSphere
• Informatica
• Pentaho data integration (Kettle)

Most of the ETL tools can achieve the base function of data integration.

When selecting a product, pick the one that is:

• Easy to implement and manage
• Cost effective
• Able to scale
• Able to get the job done

You do not need the finest with all the bells and whistles. Just get the one that gets the job done.

• Easy integration with Salesforce
• Point and click
• Wizards

We use this product for our clients.

There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data.

We have used this product for eight months.

The product is stable.

We haven't encountered any scalability issues, although it was tested with only a few thousand records.

I have not used technical support.

We previously used Talend.

The setup was straightforward for me.

I was not involved in the pricing/licensing considerations.

We evaluated Talend and Dell Boomi.

• Connects to Salesforce
• Adds scripts

• Better error handling and monitoring of all interfaces
• The ability to add new interfaces: It really simplifies integrations, especially Salesforce related integrations
• The ability to quickly set a basic interface with error handling

• Debugging: There should be a better way to track variable values during debugging. The need to print each log is frustrating when you encounter issues.
• There should be a way to inspect the files going to 'temp storage' on the studio.
• The variable search should be improved with the ability to click and go to the results in the search.
• The console monitor should be easier to filter. There are better ways to filter data than typing in the filters in the search bar.

We have been using this product for two years.

We did not encounter any issues with stability.

We did not encounter any issues with scalability.

When I needed the technical support, the response was quick and professional.

I am not aware of any previous solutions.

I was not involved with the installation process.

I was not involved with the client sale process.

I am not aware of any other evaluated solutions.

In descending order:

• Data manipulation and mapping
• Connection possibilities to HTTP (authenticated calls)
• Connection and transaction management for the SQL server
• Communication possibilities (email)

Jitterbit allows us to:

• Query databases and web services
• Manipulate and organize data
• Track the flow and the states of different processes

At the time, the scheduling and error handling left room for improvement. The execution of scheduled tasks was less reliable than it could be.

I am not sure how long the solution has been in use.

Tasks would fail to start or error out and fail to track exceptions.

I am not aware of any scalability issues.

We did not use technical support.

We used an in-house application. The maintenance required highly trained developers. Even so, we went back to that solution eventually.

The setup was straightforward.

I was not involved in the licensing and pricing.

We did not evaluate any other products beforehand.

Get the latest version and train the personnel.