We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and SAS Data Integration Server based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."It has a Data Catalog that uses the Model repository."
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It is UI friendly and has all the advantages of an ETL tool."
"PowerCenter performs well during data transformation and optimization."
"The ability to scale through partitions helped us to improve the performance."
"The setup is straightforward."
"It's a complete package, which is why we use this solution."
"The setup is very simple."
"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."
"Besides loading data, we do most of our transformations in ODI."
"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."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"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."
"All our systems can be widely integrated by ODI, such as transactional systems, our data warehouses, and B2B integration."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The solution offers very good data manipulation and loading."
"The solution is very stable."
"The most valuable feature of the solution is its amazing capabilities in regard to data handling."
"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 licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"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."
"They should release new versions for the solution's on-premises setup."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"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 multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"An area for improvement in Oracle Data Integrator (ODI) is real-time integration. Currently, my company has a workaround to implement real-time integration, an area on which Oracle must focus more. Real-time integration should be easier in Oracle Data Integrator (ODI). Another area for improvement in Oracle Data Integrator (ODI) is integration with more publishers and subscribers rather than just database integrations."
"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."
"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."
"Technical Support could be better."
"The resource management aspect of the solution could be improved."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"So I would like to see improved integration with other software."
"The initial setup of SAS Data Integration Server was complex."
"The transform tool has limited access. They should make it more flexible."