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."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."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"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 greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"The most valuable features are the monitoring tools and the reporting manager."
"Can manage a huge quantity of data and provide reliability."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"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."
"It is an ETL tool, which does the extract, transform, and load."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"It allows us to use many languages to develop and to integrate practically all the technologies of the Oracle suite as well as those from non-Oracle vendors."
"What I found most valuable in Oracle Data Integrator (ODI) is that it integrates well with almost all technologies currently being used in my company."
"The product saves time and resources."
"Kofax RPA's best feature is its high success percentage in picking up information from documents, especially where the DPI is really low."
"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."
"The features that we have found the most valuable are the integration of different third-party support and productivity services."
"It is stable and scalable."
"You can automate browsing tasks without needing a server connection. The platform provides its browser, allowing you to run anything inside it."
"The most valuable features are workflow and process automation."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"There is some room for improvement in terms of pricing."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"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 terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"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."
"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."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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 process discovery could be a bit better."
"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. "
"The product has some constraints and performance issues."
"RPA technology is constantly changing, and sometimes Kofax lags behind."
"There is really nothing special about the capabilities of this product."
"It needs a free training portal for anybody on the internet to use so that they can get an idea of what the possibilities are."
"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."