We performed a comparison between Informatica PowerCenter, Oracle Data Integrator (ODI), and SAP Data Services based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"The product's initial setup phase is very easy."
"Good product if you are trying implement data quality, data integration, and data management projects."
"The solution is stable."
"What I like the most is that we have to deal with less while writing the queries."
"It's a complete package, which is why we use this solution."
"It has helped us monetize."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"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."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"I like that Oracle Data Integrator (ODI) has a straightforward setup and offers good technical support."
"The most valuable feature is Data movement."
"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 most valuable features of SAP Data Services lie in its ability to effectively observe and interpret the information within data related to people or facts, stands out."
"It's easy to understand and deploy. It's easy to create new applications, and depending on the complexity of the application, it is easy to deploy the new requirements."
"You can always manipulate a lot of things as long as you have the skill level."
"The HANA database, which is very fast, is a valuable feature."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"The most valuable feature is the logging capability."
"The solution offers very good integration capabilities."
"Its integration capabilities and the data migration capabilities are the most valuable. It is very good for SAP and non-SAP tools. It has very good integration with SAP, but it also has the capabilities to connect to other systems. We find it very helpful and stable."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"It should be more cloud-centric than on-prem-centric."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"There is some room for improvement in terms of pricing."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"Integrating new tools can be tricky and challenging."
"Its scalability can be improved. It is not scalable."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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 stability of the software could be improved. Sometimes, the software just crashes. "
"If you have something like Cisco on top of it, you will have endless problems."
"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."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"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 would be nice if this solution was a bit easier to move from development to production."
"The initial setup is complex."
"An area for improvement in SAP Data Services could involve making the product more accessible to non-technical end-users."
"The description of error messages isn't extensive, although they point to the problem. With other solutions, like Talend, I was able to use the debugger to get directly to the problem, but with SAP Data Services the debugger is not working. I'm not sure if it's a problem with the version specifically, but I'm using it in an enterprise environment and I can't do an upgrade."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"The solution could improve the overall features. There is a lot that can be done in the solution, therefor there are areas where it can improve. Additionally, there is a need to make it easier for one to create connections to other non-SAP systems. The flexibility to connect to other non-SAP systems is needed."
"The skillset of data engineers matters a bit to use all the functionality of this solution. Otherwise, the delivery speed won't be faster."
"The solution should offer more machine learning and automation."