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."Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"It runs like an appliance and has tremendous throughput."
"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."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It is a scalable solution."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"Easy integration with Salesforce"
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The initial setup was easy."
"It has good data integration and good processes."
"The solution is easy to use and developer friendly."
"It's saved time using visualization descriptions."
"It is easy to set up the product."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"Its API management capabilities need improvement."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"The initial setup can be a little bit difficult."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Looping through complex data structures can be difficult."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"This solution needs full support for real-time processing."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"Improvement as per customer requirements."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"At one point, we did have to purchase an add-on."
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.