We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica PowerCenter, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"We can scale the product."
"The number of docs has been reduced drastically, which is very good."
"Good interface, reasonable documentation."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"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."
"It's very easy to use it to develop mappings and workflows."
"Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical."
"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."
"ODI's most valuable features are it utilizes the database engine and is very lightweight."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"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."
"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."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"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."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"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."
"It should be more cloud-centric than on-prem-centric."
"There is some room for improvement in terms of pricing."
"The solution does not scale."
"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."
"The performance of the user interface is in need of improvement."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"Technical Support could be better."
"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 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."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"Reverse engineering is complicated and challenging to manage."
"Stability could be improved because some operators have issues."
Earn 20 points