We performed a comparison between Actian Pervasive Data Integrator [EOL], 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."There were no concerns with the stability. This product is very good from a stability perspective."
"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."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"The UI is very user-friendly."
"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."
"It has good data integration and good processes."
"SSIS integrates well with SQL servers and Microsoft products."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"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."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"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."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"Tuning using this solution requires extensive expertise to improve performance."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"I would like to see more standard components out of the box, such as SFTP, and Data Compression components."
"I come from a coding background and this tool is graphically based. Sometimes I think it's cumbersome to do mapping graphically. If there was a way to provide a simple script, it would be helpful and make it easier to use."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"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."
"Performance could be better."
More Informatica Data Integration Hub Pricing and Cost Advice →
Earn 20 points