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."It has the ability to easily load slowly changing dimensions."
"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."
"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's scalable."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"The CAEM is very useful in its modularity and portability."
"The most valuable feature that we use is the Knowledge Modules."
"The initial setup is not complex."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"The basic functionality is quite good as is the basic logic and data information."
"The most valuable feature of SAP Data Services is the integration with data sources."
"I have worked with Data Services for a long time, and currently, I find the dashboarding and reporting part to be the most valuable function."
"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."
"You can always manipulate a lot of things as long as you have the skill level."
"The solution offers very good integration capabilities."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"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."
"The resource management aspect of the solution could be improved."
"Reverse engineering is complicated and challenging to manage."
"The initial setup is a bit complex compared to other tools."
"The solution lacks some functions and features."
"We used a third party to do the implementation of ODI."
"Newer feature integration is lagging behind the company acquisitions and the product could do more to service a broader range of devices."
"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."
"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 pricing of the solution should be improved."
"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."
"The initial setup is complex."
"There needs to be multi-language support, however, my understanding is they are working on multi-language now."
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.