We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica PowerCenter, and WhereScape RED 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."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"I like the automated scheduling feature."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"Informatica PowerCenter is a very good ETL tool."
"It is an excellent ETL tool."
"The most valuable features are the monitoring tools and the reporting manager."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"Support is absolutely excellent, efficient, and timely."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"The most valuable feature is the metadata generated code."
"WhereScape RED has improved our business's ability to generate needed reporting without requiring a large team of developers to manually code all of the necessary plumbing."
"I like the data vault implementations."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"The tool supports multiple target update methods."
"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)."
"We had stability issues, mostly with JVM size."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"It would be good to recreate the entire interface to make it easier for users to build workflows."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"Integration with Artificial Intelligence would benefit this solution."
"The performance of Informatica PowerCenter could improve."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Improve the object renaming ability (it works, but it could be more automated)."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Customization could be better."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"No support for change data capture or delta detection - that must be custom coded ."
"Technical support isn't the best."
Earn 20 points
Earn 20 points