We performed a comparison between Informatica Data Integration Hub and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."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."
"It is easy to set up the solution."
"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 UI is very user-friendly."
"The initial setup was easy."
"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."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"It is easy to set up. The deployment is also very quick."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
"The initial setup was not very straightforward. Not complex, but not very simple either."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"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 was also not enough instructions from Microsoft in regards to this application or this technology, which can easily be improved upon."
"There are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"Tuning using this solution requires extensive expertise to improve performance."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"This solution needs full support for real-time processing."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
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, Mule Anypoint Platform and SAP Data Hub, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
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.