We performed a comparison between Oracle Data Integrator (ODI) and SAP Data Services based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Besides loading data, we do most of our transformations in ODI."
"It's completely user-friendly."
"The CAEM is very useful in its modularity and portability."
"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 most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"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."
"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."
"The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"It is a powerful product with a broad range of features."
"The reporting on the data, even from third-party software, is very good."
"The most valuable feature is the logging capability."
"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."
"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."
"The feature of SAP Data Services has enhanced our company's business processes because we are able to run around 800 jobs in areas like data extraction and transaction objects."
"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."
"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."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"The resource management aspect of the solution could be improved."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"Technical Support could be better."
"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."
"The price needs to be lowered. It's too expensive."
"The solution shows a lack of cloud support data services."
"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 migration of the solution between different environments is quite complex."
"We encounter challenges while exporting implemented rules, such as those applied to objects like the material master, into a format like Excel for documentation and further analysis."
"The interface is not quite user-friendly and is in need of improvement."
"Some of the jobs that are built within Data Services require local files, and during initial deployment, those local files cannot be transported between machines simply because of security issues."
"At the integration level, there could be certain set of improvement to connect to various other systems."
"The solution should offer more machine learning and automation."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews while SAP Data Services is ranked 10th in Data Integration with 45 reviews. Oracle Data Integrator (ODI) is rated 8.2, while SAP Data Services is rated 8.0. The top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". On the other hand, the top reviewer of SAP Data Services writes "Responsive support, scalable, and beneficial integration". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Apache Kafka, whereas SAP Data Services is most compared with Azure Data Factory, Syniti Data Quality, Informatica PowerCenter, SAP Process Orchestration and AWS Glue. See our Oracle Data Integrator (ODI) vs. SAP Data Services report.
See our list of best Data Integration vendors.
We monitor all Data Integration reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.