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 features are the monitoring tools and the reporting manager."
"The setup is very simple."
"Once you have learned Informatica, it is very easy to use."
"I like the completeness of the way I can build ETL workflows."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"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 part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"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."
"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."
"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."
"I found the initial setup very easy."
"Data transformations and rollups are easy to accomplish."
"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."
"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."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"Lacks ability to calculate cost of the product."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"Requires an established data center because there is no option for software as a service."
"The solution can provide access to the newer databases that come out sooner."
"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 pricing model needs to be reconsidered and adjusted."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Technical support isn't the best."
"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."
"Customization could be better."
"No support for change data capture or delta detection - that must be custom coded ."
"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."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
Earn 20 points