We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and Tungsten RPA based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."Can manage a huge quantity of data and provide reliability."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It reduces a lot of legacy coding."
"I found the map links, work links, and workflows valuable. They are important features."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"The most valuable features are the metadata repository and the data warehouse application console."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"The number of docs has been reduced drastically, which is very good."
"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 product has an ELT approach."
"It's completely user-friendly."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"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."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It has the ability to easily load slowly changing dimensions."
"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."
"The flexibility to use already-developed components is really good. You can use it for Excel-related operations and other things."
"The most valuable feature is the robotic process."
"The features that we have found the most valuable are the integration of different third-party support and productivity services."
"The most valuable features are workflow and process automation."
"The OCR was quite stable and flexible."
"The product saves time and resources."
"The most valuable feature of Kofax RPA is the simplicity of automating tasks."
"This is a stable platform and we did not encounter any big problems."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"Integration with Artificial Intelligence would benefit this solution."
"This product is going to decommission in the next couple of years."
"It needs easier security."
"The initial setup is complex, especially if you also have to install a console."
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"If you have something like Cisco on top of it, you will have endless problems."
"The resource management aspect of the solution could be improved."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"The product has some constraints and performance issues."
"Its documentation is not widely available on the web. They should work on the availability of its documentation. In Automation Anywhere, there is a feature called Discovery Bot that automatically records the process steps and suggests a possible bot. I am not sure if such a feature is available in Kofax. If it is not available, it will be very good to have this feature. "
"This product has room for improvement in support of aviation. The interface could be improved in the next release."
"Kofax RPA needs to improve integration with SAP and Microsoft. The professional services offered by the tool's team is below par. Its licensing needs to be more modular."
"There is really nothing special about the capabilities of this product."
"Kofax RPA's UI could be more user-friendly."
"The solution could use some AI integrated features."
"The product needs more AI capabilities."