We performed a comparison between Informatica PowerCenter, Informatica PowerExchange, 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 interface is very clean and clear."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"It's very easy to use it to develop mappings and workflows."
"Can manage a huge quantity of data and provide reliability."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The transformation work called for Informatica PowerExchange. It was easy to work with this and very stable."
"The scalability is excellent."
"The most valuable feature is connectivity to data sources."
"The product’s flexibility is valuable."
"It is a scalable and versatile solution."
"Provides a significant amount of control over the landscape and overall implementation."
"The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine."
"From the product feature or product capability perspective, the aspects around integration, transformation, and standardization are valuable. It's fairly easy to use. It has a GUI-based interface."
"The most valuable feature is the metadata generated code."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"It has a built-in automatic scheduling environment."
"This is a fantastically robust DW tool that will make you at least 10 times faster in producing a DW."
"I like the data vault implementations."
"WhereScape is really helpful in terms of architecture data. Everything is one of automation. Two people can do thousands of tables in one day or two. It saves a lot of time."
"RED has provided us the ability to integrate, stage, and transform data from diverse sources into an enterprise-grade data warehouse which meets the needs of my organization, but it also enables us to easily and quickly make ETL or DW changes."
"The tool supports multiple target update methods."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"They should release new versions for the solution's on-premises setup."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"I would like to see an improvement in the digital adoption."
"The initial setup is not straightforward. You need expertise to do it."
"The pricing could be improved."
"The solution needs better integration with other tools."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"V10.2 is very stable, but we are still struggling to make V10.5 stable. We found services that were down, and PowerExchange stopped working."
"Informatica is very expensive in all aspects, so the pricing is something that could be improved."
"I would like to have easier integration with cloud platforms."
"Integration with the largest number of databases and other systems would be important."
"Should diversify more, maybe with a reporting and visualization utility,"
"The connectivity with T24 core banking could be improved."
"Improve the object renaming ability (it works, but it could be more automated)."
"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."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"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."
"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."
"Technical support isn't the best."
Earn 20 points