We performed a comparison between SSIS and Unifi 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."Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"It is easy to set up the solution."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"SSIS is easy to use."
"It is easy to set up the product."
"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 UI is very user-friendly."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"The controller makes it easy to control everything from one platform. The management is easy."
"It's easy to manage and support the user, our guests, and our customers if they have a problem."
"It's a legacy tool, that is nearing the end of its useful life."
"Options for scaling could be improved."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"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."
"It's difficult to refactor SSIS. It gets cumbersome to reuse the solution."
"Future releases should improve the data lineage, as it currently is not good."
"Involving a data lake or data engineering aspects would be useful. While it is there, we need more features included."
"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."
"It's stable, but it depends on the office and location."
"There are issues with certain Apple devices."
SSIS is ranked 2nd in Data Integration with 69 reviews while Unifi is ranked 47th in Data Integration with 2 reviews. SSIS is rated 7.6, while Unifi is rated 8.0. The top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". On the other hand, the top reviewer of Unifi writes "Makes integration and monitoring users very easy". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue, whereas Unifi is most compared with . See our SSIS vs. Unifi report.
See our list of best 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.