We performed a comparison between Jitterbit Harmony and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Easy integration with Salesforce"
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"The Cloud Console for monitoring and troubleshooting data operations."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"It is very easy to build integrations and processes to pull and push data."
"Jitterbit provides the ability to quickly map data between files and databases."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The setup is straightforward. It's very easy to install."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"It's a competent product."
"It is easy to set up the solution."
"The product's deployment phase is easy."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"Sometimes additional connectors are needed."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"I would like the ability to offer a dedicated cloud version for security."
"Looping through complex data structures can be difficult."
"Its API management capabilities need improvement."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"We'd like them to develop data exploration more."
"It hangs a lot of the time."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"The solution could improve by having quicker release updates."
"Options for scaling could be improved."
Jitterbit Harmony is ranked 35th in Data Integration with 13 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Jitterbit Harmony is rated 8.6, while SSIS is rated 7.6. The top reviewer of Jitterbit Harmony writes "An easy-to-setup solution with good stability ". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Jitterbit Harmony is most compared with Microsoft Azure Logic Apps, Azure Data Factory, Mule Anypoint Platform, MuleSoft Composer and SnapLogic, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Jitterbit Harmony vs. SSIS report.
See our list of best Data Integration vendors and best Cloud Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.