We performed a comparison between Informatica Data Integration Hub 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 MDM solution is capable of integrating multiple systems, so it helped us to solve the purpose of centralizing the depository as well as the standardization of mass data. It takes away all the ambiguity around data integrity issues or all the process challenges which happen when every stage of a process uses a different source as master data."
"The technical support services are good."
"Performance and flexibility-wise, they're very user-friendly."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"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."
"I have found its most valuable features to be its package management capabilities and the flexibility it offers in designing workflows."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
"The initial setup was not very straightforward. Not complex, but not very simple either."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"It would be nice if you could run SSIS on other environments besides Windows."
"I would like to see better integration with Power BI."
"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."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
More Informatica Data Integration Hub Pricing and Cost Advice →
Informatica Data Integration Hub is ranked 37th in Data Integration with 3 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Informatica Data Integration Hub is rated 8.0, while SSIS is rated 7.6. The top reviewer of Informatica Data Integration Hub writes "Excellent at standardizing mass data and capable of integrating with multiple solutions ". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Informatica Data Integration Hub is most compared with Informatica PowerCenter, AWS Database Migration Service, Azure Data Factory, SAP Data Hub and Mule Anypoint Platform, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue. See our Informatica Data Integration Hub vs. SSIS 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.