

Oracle Data Integrator and Denodo compete in the data integration and data virtualization sector. Oracle Data Integrator has an upper hand in integration and automation capabilities, while Denodo excels in data abstraction and centralization.
Features: Oracle Data Integrator supports an EL-T architecture for robust data integration across various technologies using Knowledge Modules for flexible data processes. Its real-time data integration and support for multiple scripting languages enhance its adaptability. Denodo focuses on data virtualization, providing a centralized access layer without data movement and simplifying access to disparate data sources. Its data abstraction and performance features are highly rated by users.
Room for Improvement: Oracle Data Integrator can enhance its user interface and compatibility with external tools. Improved error handling and expanded integration with Oracle products are also desired. Denodo aims to improve data catalog integration, interface automation, and provide better training resources. Users report complexity in Denodo's setup, suggesting more intuitive configuration and integration with cloud applications.
Ease of Deployment and Customer Service: Oracle Data Integrator is primarily available on-premises, facing deployment flexibility issues. Customer support experiences are mixed, with complex scenarios often complicating responses. Denodo offers hybrid and cloud deployment options, providing higher flexibility. Users desire more efficient customer support and documentation for Denodo.
Pricing and ROI: Oracle Data Integrator's licensing model is perceived as complex and expensive, challenging for smaller entities. However, it can yield high ROI when used effectively. Denodo is also considered costly, appealing to larger enterprises, though it offers substantial ROI through efficient data management. Both solutions require careful consideration of licensing costs versus benefits.
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.3% |
| Oracle Data Integrator (ODI) | 2.2% |
| Other | 96.5% |


| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 21 |
| 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.