We performed a comparison between Informatica PowerCenter, SAS Access, 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."The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"It's very easy to use it to develop mappings and workflows."
"The product's initial setup phase is very easy."
"The ability to scale through partitions helped us to improve the performance."
"In the end, you have structured, proper data for use in an integrated BI solution."
"It has good standard features for ETL development."
"Good product if you are trying implement data quality, data integration, and data management projects."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The most valuable feature is you have native access to the external databases."
"The most valuable feature is the metadata generated code."
"Support is absolutely excellent, efficient, and timely."
"Data transformations and rollups are easy to accomplish."
"WhereScape's deployment package is a fantastic feature. The application allows for selecting specific objects that you would like to deploy from one environment to another rather than deploying the entire database."
"It has a built-in automatic scheduling environment."
"The tool supports multiple target update methods."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"I would like to see it be able to import data from NoSQL."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal."
"The licensing is difficult."
"Integration with Artificial Intelligence would benefit this solution."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"Its scalability can be improved. It is not scalable."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"The solution can provide access to the newer databases that come out sooner."
"The pricing model needs to be reconsidered and adjusted."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"No support for change data capture or delta detection - that must be custom coded ."
"Improve the object renaming ability (it works, but it could be more automated)."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"Jobs cannot be deleted via the deployment package. When deploying from dev to QA or production, a job has to be retired. The job has to be manually removed from the target environment."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
Earn 20 points