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."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."
"It is a scalable solution."
"The fluid user interface (probably the most user friendly interface, when compared to its competitors)."
"It runs like an appliance and has tremendous throughput."
"Jitterbit handles the most lines of data in a .csv and loads the quickest of any data loader I have tried."
"Easy integration with Salesforce"
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"It is easy to set up. The deployment is also very quick."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"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 initial setup was easy."
"The technical support is very good."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"The initial setup can be a little bit difficult."
"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."
"You need to have some development skills or hire a Jitterbit engineer to make changes."
"In the past few months, there have been some server downtimes during work hours that have affected some critical scheduled integrations."
"Its API management capabilities need improvement."
"I know with Salesforce updating the UI like they did, it slowed it down a lot."
"Sometimes additional connectors are needed."
"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."
"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."
"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."
"The security could be improved, as it is more important in our context."
"We have issues with SSIS connectors while extracting data from Excel sources."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"The high prices attached to the product can be an area of concern where improvements are required."
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.