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 provides the ability to quickly map data between files and databases."
"Easy integration with Salesforce"
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"The Cloud Console for monitoring and troubleshooting data operations."
"It is a scalable solution."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"It is very easy to build integrations and processes to pull and push data."
"The solution is stable."
"The performance and stability are good."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"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 most valuable features of this solution are the fast insert and fuzzy logic matching."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"The interface is very user-friendly."
"It's already very user-friendly and has a good dashboard."
"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."
"Sometimes additional connectors are needed."
"I would like the ability to offer a dedicated cloud version for security."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"Future releases should improve the data lineage, as it currently is not good."
"Sometimes when we want to publish to other types of databases it's not easy to publish to those databases. For example, the Jet Database Engine. Before the SSIS supported Jet Database Engine but nowadays it doesn't support the Jet Database Engine. We connect to many databases such as Access database, SparkPros databases and the other types of databases using Jet Database Engines now and SSIS now doesn't seem to support it in our databases."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
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 MuleSoft Composer, Azure Data Factory, Microsoft Azure Logic Apps, Mule Anypoint Platform 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.