We performed a comparison between SSIS and Unifi based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"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."
"It is easy to set up the product."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"The simplicity of the solution is great. The solution also offers excellent integration."
"It's a competent product."
"The technical support is very good."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"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."
"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."
"The performance of SSIS could improve when comparing it to Oracle Database."
"There was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"The solution could improve on integrating with other types of data sources."
"We'd like them to develop data exploration more."
"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."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Video training would be a helpful addition."
"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 68 reviews while Unifi is ranked 45th in Data Integration with 2 reviews. SSIS is rated 7.8, 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 "Good management and pricing but not great for enterprise environments". SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue, whereas Unifi is most compared with Informatica Enterprise Data Catalog and Alteryx.
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.