

Oracle Data Integrator and Denodo compete in the data integration and virtualization space. While both have unique strengths, Denodo seems to have an advantage with its data virtualization capabilities, enhancing flexibility and accessibility across diverse data sources.
Features: Oracle Data Integrator employs an EL-T approach, eliminating the need for additional transformation hardware by leveraging target data server workloads. It features Knowledge Modules for effective customization and connectivity across various data sources and targets. Denodo stands out in data virtualization, providing seamless access and integration across multiple sources with robust data cataloging, simplifying analytical processes.
Room for Improvement: Oracle Data Integrator could benefit from better native REST integration, enhanced error handling, and improved integration with external version control systems like GIT. Denodo could focus on optimizing performance management, streamlining integration processes, and enhancing complex data handling for analytics.
Ease of Deployment and Customer Service: Oracle Data Integrator typically deploys in on-premises environments with cloud options available, although technical support receives mixed reviews. Denodo offers hybrid and cloud deployment flexibility, with customer service generally well-received for its efficiency and support.
Pricing and ROI: Oracle Data Integrator's pricing ranges from moderate to high, catering to medium and large enterprises, promising automation and long-term ROI with effective implementation. Denodo's pricing targets large enterprises, perceived as costly but valuable due to efficient data access and significant ROI potential.
It provides a positive return on investment for those who can connect multiple data sources and make data-driven decisions easily.
If you don't need to write a whole ETL to make the data virtualization, you need way fewer people to write a query instead of writing an ETL pipeline.
I have seen a return on investment, which showed up in improved customer satisfaction scores.
They have a good methodology for learning how to use the tool.
Denodo's customer support team is very competent and responsive.
If we raise a ticket, it can be resolved or addressed within a reasonable time frame, so support is good.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
For huge data requests, it cannot scale automatically; admin action is required.
Denodo's scalability comes into play specifically when there is data transfer.
My client has almost 100 million records, and the performance was impacted in a way that required optimization.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
I would rate it nine out of ten because it is very reliable, always performing as expected.
If JVM does not function properly, it may cause Denodo to fail to connect to different sources.
Denodo is stable and good.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
Ensuring data caching is up to date is critical.
Denodo needs better communication on how the product can be deployed for specific solutions.
The system has dependencies on other environments, like JVM, which can affect its performance.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
It would be excellent not to have to go into different areas to perform different activities but rather have a user-defined interface where we can configure a job, run it, monitor it, link packages, and link subprocesses all in one frame.
Adding AI capabilities would make Oracle Data Integrator (ODI) even better.
For small companies, it's not a solution that most small companies can afford.
Denodo is considered pricey, limiting its use to large enterprises or government organizations that can afford its comprehensive setup.
Denodo's pricing is not affordable for small companies and is more suitable for medium to large enterprises.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The pricing aspect of Oracle Data Integrator (ODI) is reasonable; it brings significant value to the table.
Denodo's ability to connect to multiple data sources and perform extract-transform-load (ETL) operations on the fly is noteworthy.
The most valuable feature of Denodo is its uniformity of self-site data access types, which allows it to connect to almost any storage technology and feed it transparently.
Denodo supports SQL base, so if you want to join two tables or two views, you can use SQL, which is an advantage as most developers or business people know SQL.
The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly.
| Product | Mindshare (%) |
|---|---|
| Denodo | 1.4% |
| Oracle Data Integrator (ODI) | 2.5% |
| Other | 96.1% |


| Company Size | Count |
|---|---|
| Small Business | 17 |
| Midsize Enterprise | 6 |
| Large Enterprise | 20 |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 44 |
Denodo specializes in data virtualization, data cataloging, and user-friendly interfaces. It's recognized for connecting disparate data sources, presenting unified data for analytics, and supporting efficient decision-making with agile analytics and robust data governance.
Denodo effectively aggregates data from multiple sources to offer a comprehensive understanding through its virtualization capabilities. It provides role-based access control, flexible query languages, performance optimization, and integration with databases. Enhancements are needed in its interface and documentation to ensure better user experiences. While the platform supports cloud migration, integration challenges with tools like Salesforce and MuleSoft exist. Improvements in data visualization, automation, and scalability, especially in large data environments, are critical areas for growth.
What are the key features of Denodo?In industries like finance, healthcare, and retail, Denodo plays a crucial role in data virtualization and integration. Organizations use it to unify disparate data systems, enabling real-time analytics and supporting cloud migrations. Denodo's platform is ideal for businesses needing to aggregate, transform, and utilize diverse data efficiently, optimizing operations and enhancing governance.
Oracle Data Integrator offers flexible EL-T architecture, optimizing processing with database capabilities. It supports diverse data sources, automates deployment, and provides efficient data transformations, making it suitable for data warehousing and complex data environments.
Oracle Data Integrator leverages EL-T architecture to enhance processing by utilizing database strengths. It integrates with a wide array of technologies, including RDBMS, cloud, and big data. The software's Knowledge Modules enable customizable integration strategies, accelerating development. With a user-friendly interface and automation features, it simplifies metadata management and supports real-time data warehousing. Key areas such as UI performance, integration, and real-time data capabilities require enhancements. Challenges include error handling, initial setup, and compatibility with platforms like Git, Azure, and IoT services. Improvements in metadata management, scalability, and user-friendliness are needed.
What are the most important features of Oracle Data Integrator?Organizations utilize Oracle Data Integrator primarily in data warehousing, handling data from ERP systems, EBS, Fusion, and cloud databases. It aids in creating data lakes, OLTP migrations, digital health initiatives, and automation tasks, ensuring seamless integration with databases like MySQL and SQL Server.
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.