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."Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"The tool improved our data integration workflow primarily due to its compatibility with Oracle. Its integration makes it very convenient for analytics. Its most valuable feature is robust extended capability. The solution's debugging capabilities are good."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"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."
"In our DW/BI solution, ODI is the main tool to integrate the data in a daily batch way."
"Besides loading data, we do most of our transformations in ODI."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"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 most valuable feature of SAP Data Services is the integration with data sources."
"Technical support from SAP is awesome. If we have an issue, they give a good solution."
"The solution is easy to use since it's a graphical tool. It also requires only low-level coding."
"The most valuable feature is the ETL functionality."
"The most valuable feature is the logging capability."
"The reporting on the data, even from third-party software, is very good."
"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."
"We can extract data at a table level, extract data at the ETL level, and we can extract data at an ODP level."
"The initial setup is a bit complex compared to other tools."
"Technical Support could be better."
"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."
"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 solution lacks some functions and features."
"If you have something like Cisco on top of it, you will have endless problems."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"At present, when multiple steps are executed in parallel in the load plan and errors occur, the error handling mechanism does not function correctly."
"It would be nice if this solution was a bit easier to move from development to production."
"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 execution engines and processing engines have shortcomings and need improvements."
"Data Services SAP is lacking in sources and target databases compared to Informatica. SAP Data Services should have more connectivity."
"With SAP Data Services, the problem arises when I try to connect to Azure Databricks."
"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."
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.