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."Performance and flexibility-wise, they're very user-friendly."
"The technical support services are good."
"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."
"It's a competent product."
"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."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The simplicity of the solution is great. The solution also offers excellent integration."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The setup is straightforward. It's very easy to install."
"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."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"Performance could be better."
"The high prices attached to the product can be an area of concern where improvements are required."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"Tuning using this solution requires extensive expertise to improve performance."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"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."
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.