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."It is very easy to build integrations and processes to pull and push data."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"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."
"Integrity, ease of use, user-friendly user interface, and errorless logs are the most valuable features."
"Jitterbit provides the ability to quickly map data between files and databases."
"Easy integration with Salesforce"
"Overall, it's a good product."
"The initial setup was easy."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The initial setup of this solution is very straightforward."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The setup is straightforward. It's very easy to install."
"The most important features are it works well and provides self-service BI."
"SSIS integrates well with SQL servers and Microsoft products."
"The initial setup can be a little bit difficult."
"I would like the ability to offer a dedicated cloud version for security."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Looping through complex data structures can be difficult."
"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."
"Its API management capabilities need improvement."
"It's a legacy tool, that is nearing the end of its useful life."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"This solution needs full support for real-time processing."
"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 stable, but extensive ETL data processing can have some performance issues."
"It hangs a lot of the time."
"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."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
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.