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."Good interface, reasonable documentation."
"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."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"I like the automated scheduling feature."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models."
"Besides loading data, we do most of our transformations in ODI."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The most valuable feature is Data movement."
"It has the ability to easily load slowly changing dimensions."
"The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
"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."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"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."
"Support is absolutely excellent, efficient, and timely."
"Data transformations and rollups are easy to accomplish."
"I like the data vault implementations."
"Naturally produces a way to easily debug your DW data solutions."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Support could be better."
"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."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"Its scalability can be improved. It is not scalable."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"The initial setup is a bit complex compared to other tools."
"The resource management aspect of the solution could be improved."
"Stability could be improved because some operators have issues."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"The solution lacks some functions and features."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"We used a third party to do the implementation of ODI."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"Project-based searching of data objects in the data warehouse browser needs to be improved."
"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 ."
"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."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"They need a more robust support center. It has been a bit difficult to find solutions to problems that are out-of-the-box."
"Customization could be better."
Earn 20 points
