We performed a comparison between Jitterbit Harmony and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It is very easy to build integrations and processes to pull and push data."
"Easy integration with Salesforce"
"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."
"We only use small parts of the solution, however, the parts that we use are quite adequate."
"It runs like an appliance and has tremendous throughput."
"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."
"The initial setup was 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."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It is easy to set up. The deployment is also very quick."
"The performance and stability are good."
"SSIS integrates well with SQL servers and Microsoft products."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"It has good data integration and good processes."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"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."
"Its API management capabilities need improvement."
"Looping through complex data structures can be difficult."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Sometimes additional connectors are needed."
"Sometimes we experience disconnections and I have to close all Jitterbit programs."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"We have issues with SSIS connectors while extracting data from Excel sources."
"Generic processes should be used instead of custom code for each table."
"It hangs a lot of the time."
"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."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"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 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 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.