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 technical support services are good."
"Performance and flexibility-wise, they're very user-friendly."
"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."
"SSIS integrates well with SQL servers and Microsoft products."
"We can connect with multiple data sources easily using an external connector in SSIS."
"It is easy to set up. The deployment is also very quick."
"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."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"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)."
"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."
"The high prices attached to the product can be an area of concern where improvements are required."
"This solution needs full support for real-time processing."
"Tuning using this solution requires extensive expertise to improve performance."
"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."
"We'd like them to develop data exploration more."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"Future releases should improve the data lineage, as it currently is not good."
More Informatica Data Integration Hub Pricing and Cost Advice →
Earn 20 points