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."One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The product has an ELT approach."
"The scalability is great. It's one of the reasons we chose the solution."
"Besides loading data, we do most of our transformations in ODI."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"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."
"The installation of the client ODI Studio is easy."
"It's completely user-friendly."
"I appreciate having access to the SAP data."
"The most valuable feature is the logging capability."
"The fact that it's built on SQL, it makes it easy to write code. The database and the connection are quite smooth."
"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."
"The basic functionality is quite good as is the basic logic and data information."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"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."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
"The solution lacks some functions and features."
"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."
"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."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"Integration with other products could be improved."
"Newer feature integration is lagging behind the company acquisitions and the product could do more to service a broader range of devices."
"In the future, Data Services should offer a cloud version."
"The interface is not quite user-friendly and is in need of improvement."
"I want some more business intelligence applications. People need to know more and more about data, including the transformation rules, etc. Informatica is a better product for data cataloging. SAP should update the data catalog."
"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 execution engines and processing engines have shortcomings and need improvements."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 15 reviews while SAP Data Services is ranked 10th in Data Integration with 15 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 "We can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools". On the other hand, the top reviewer of SAP Data Services writes "Easy to use, simple to implement, and offers very good mapping capabilities". 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, SSIS 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.