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."In the end, you have structured, proper data for use in an integrated BI solution."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"The setup is very simple."
"The number of docs has been reduced drastically, which is very good."
"It is an excellent ETL tool."
"We have found the PowerCenter and B2B data transformation most valuable."
"I like the completeness of the way I can build ETL workflows."
"Has a good visual tool for data mapping."
"The product has an ELT approach."
"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."
"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."
"The most valuable feature that we use is the Knowledge Modules."
"The CAEM is very useful in its modularity and portability."
"The scalability is great. It's one of the reasons we chose the solution."
"The most valuable feature is Data movement."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"Their support staff are very knowledgeable, courteous, and professional. I feel their support staff go above and beyond to assure their customers are satisfied."
"Naturally produces a way to easily debug your DW data solutions."
"It has a built-in automatic scheduling environment."
"Data transformations and rollups are easy to accomplish."
"Quickly develops a data warehouse for our organization with documentation and can track back/forward features."
"I found the initial setup very easy."
"Support is absolutely excellent, efficient, and timely."
"I like the data vault implementations."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"The solution must improve the integration with new services."
"The documentation could be improved."
"The initial setup is not straightforward. You need expertise to do it."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"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."
"Reverse engineering is complicated and challenging to manage."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"The resource management aspect of the solution could be improved."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"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."
"The ability to execute SSIS projects within WhereScape would be nice because we have a lot of packages that are too cumbersome to recreate."
"The solution can be a little more user-friendly on enterprise-level where people use it."
"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."
"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."
Earn 20 points