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."The initial setup is easy."
"Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
"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 product has an ELT approach."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"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 appreciate having access to the SAP data."
"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."
"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 initial setup is not complex."
"The product's most valuable features are data validation and rules."
"It is a powerful product with a broad range of features."
"The logic is also simple. It makes it easy to build your extraction."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"The initial setup is a bit complex compared to other tools."
"It would be really good if Oracle considered enabling the tool to integrate with some other platforms that are deprecated simply for commercial reasons"
"I rate it a seven out of 10 because there is room for growth because ODI is still new, in comparison to Informatica, which is a mature product."
"The tool should improve its pricing. It prevents the application of Oracle ODI on small and medium projects in countries like Croatia, Germany, or the US. While there are no technological obstacles to using it, the high price makes it unfeasible for projects with smaller budgets."
"The performance of the user interface is in need of improvement."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
"The price needs to be lowered. It's too expensive."
"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."
"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."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"An area for improvement in SAP Data Services could involve making the product more accessible to non-technical end-users."
"It will work fine only in an SAP environment. It could be said that the integration with other vendors could be better."
"Source code control is another headache. When your source code base gets too large, managing the source code becomes cumbersome."
"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."
"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 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.