We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), 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 partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"I like the automated scheduling feature."
"Has a good visual tool for data mapping."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory."
"The solution is stable."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The product has an ELT approach."
"The installation of the client ODI Studio is easy."
"The initial setup is easy."
"The Knowledge Module approach provides an easy and reusable way to create our own integration strategies. It's easy to create these Knowledge Modules to connect to new technologies, for instance."
"Oracle provides great documentation."
"The scalability is great. It's one of the reasons we chose the solution."
"Most of the functions are very straightforward, like the data model, mapping, package, and load plan. Thus, a new user could get started very fast."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"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."
"RED generates comprehensive documentation and regenerates it as quickly as things changes, but it also provides impact documentation."
"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."
"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."
"Data transformations and rollups are easy to accomplish."
"The tool supports multiple target update methods."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"It has a built-in automatic scheduling environment."
"Its scalability can be improved. It is not scalable."
"The pricing could be improved."
"There is some room for improvement in terms of pricing."
"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."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The reputation of Informatica is that it is expensive."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"We used a third party to do the implementation of ODI."
"If you have something like Cisco on top of it, you will have endless problems."
"The initial setup is complex, especially if you also have to install a console."
"It needs easier security."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"Reverse engineering is complicated and challenging to manage."
"Stability could be improved because some operators have issues."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"It could use a tool to diagnose what is missing from the environment for WhereScape to install successfully."
"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."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"Technical support isn't the best."
"Customization could be better."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"The scheduled jobs which are run by the WhereScape scheduler seem to be a strangely separate animal. Unlike all other WhereScape objects, jobs cannot be added to WhereScape projects. Also, unlike all other objects, jobs also cannot be deleted using a WhereScape deployment application."
Earn 20 points