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's scalable."
"The most valuable feature is Data movement."
"Besides loading data, we do most of our transformations in ODI."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"The most valuable features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"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."
"The most valuable feature of SAP Data Services is the integration with data sources."
"The reporting on the data, even from third-party software, is very good."
"You can always manipulate a lot of things as long as you have the skill level."
"Data Services' best features are its robustness and plug-and-play integration with other SAP applications."
"Data Services' table comparison mechanism is very powerful. It's pretty hard to find a similar feature in other solutions."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The BA reporting tools, such as Data Services, and ETL tool in SAP Data Services are the most valuable. When we had in-memory requirements, we used HANA. HANA is most preferably for most the customers for in-memory. SAP is the first company that created the in-memory concept."
"The performance of the user interface is in need of improvement."
"The stability of the software could be improved. Sometimes, the software just crashes. "
"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."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"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."
"ODI could improve the ease of use. There is a steep learning curve to use the solution."
"Reverse engineering is complicated and challenging to manage."
"It's an ETL that is very good with relational databases but not as good with files and semi-structured files."
"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."
"They could make it easier to work with web services."
"The interface is not quite user-friendly and is in need of improvement."
"We would like the different tools offered within this solution to be available as standalone entities, rather than having to purchase the entire package when we only require a few features."
"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."
"Integration with other products could be improved."
"Scheduling of jobs in the sequence is not available. It's a very tedious process to do that particular task. If there was a tool to schedule in the sequence that would be extremely helpful."
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.