We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and SAS Access based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage."
"Good interface, reasonable documentation."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"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."
"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."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Deployment was simple and straightforward."
"It has helped us monetize."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"The CAEM is very useful in its modularity and portability."
"The installation of the client ODI Studio is easy."
"The product has an ELT approach."
"Oracle provides great documentation."
"It is an ETL tool, which does the extract, transform, and load."
"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."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The most valuable part of SAS/ACCESS is what it is made for: connecting to remote systems that are not part of your physical SAS environment."
"The most valuable aspect of the solution is the ease of access to the data in those databases."
"The most valuable feature is you have native access to the external databases."
"The solution must improve the integration with new services."
"The performance of Informatica PowerCenter could improve."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"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 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."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Lacks ability to calculate cost of the product."
"The solution does not scale."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"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."
"Stability could be improved because some operators have issues."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"We used a third party to do the implementation of ODI."
"Technical Support could be better."
"The initial setup is complex, especially if you also have to install a console."
"I can't really recall any missing feature or general improvement that is needed. We don't really add too many new kinds of databases and therefore our needs are already met."
"The pricing model needs to be reconsidered and adjusted."
"The solution can provide access to the newer databases that come out sooner."