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."Easy integration with Salesforce"
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"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."
"It is a scalable solution."
"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 runs like an appliance and has tremendous throughput."
"The initial setup was easy."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"We can connect with multiple data sources easily using an external connector in SSIS."
"The product's deployment phase is easy."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The solution is easy to use and developer friendly."
"The technical support is very good."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"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."
"Looping through complex data structures can be difficult."
"Its API management capabilities need improvement."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"There were some bugs in the product. For example if you run a delete query and test, it deletes the actual data."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"I would like the ability to offer a dedicated cloud version for security."
"We have issues with SSIS connectors while extracting data from Excel sources."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"SSIS can improve by the minimum code requirements in stored procedures and exporting data is difficult. They could make it easier, it should be as easy as it is to import data."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"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."
"I would like to see more features in terms of the integration with Azure Data Factory."
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 Azure Data Factory, Microsoft Azure Logic Apps, MuleSoft Composer, 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.