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.
Denodo is a leading data integration, management, and delivery platform that uses a logical approach to enable data science, hybrid and multi-cloud data integration, self-service BI, and enterprise data services. Organizations of different sizes across various industries utilize the product to get above the data silos. The solution offers organizations the freedom to migrate data to the cloud, or logically unify data warehouses and data lakes, without affecting business. This can ultimately result in the evolution of data strategies.
The platform accelerates data provisioning through reduced data replication, provides business users the freedom to select their preferred applications, and enables consistent security and governance across multiple systems. The solution offers one of the leading logical data fabric solutions by initiating data virtualization and eliminating the complexity and exposing the data in business-friendly formats.
Denodo also offers modern data integration and management for hybrid and multi-cloud environments for Denodo Platform for Cloud. This service can be purchased through the bring-your-own-license (BYOL) option. Users seeking faster deployment can license the product to popular cloud providers, including Amazon AWS, Google Cloud Platform, and Microsoft Azure. The solution integrates, manages, and delivers data in complex environments with high performance, governance, and security. It also offers additional solutions, such as the Denodo Platform for Cloud Modernization, the Denodo Platform for Cloud Data Integration, and the Denodo Platform for Cloud Analytics, which overcome common cloud data challenges.
Denodo Features
At the beginning of 2022, version 8.0 of Denodo introduced several new key features of the platform. These include:
Denodo Benefits
Denodo offers various benefits for its users through its services. Some of the greatest advantages of using this platform include:
Reviews from Real Users
Naresh M., a senior application developer at a financial services firm, appreciates Denodo because it offers quick and simple web services creation.
Alisson M., a senior BigData DevOps engineer at Schaeffler, says that Denodo is great for queries and scouting data.
Oracle Data Integrator (ODI) is a data integration software solution that provides a unified infrastructure to streamline data and application integration projects. It uses a powerful design approach to data integration, which separates the declarative rules from the implementation details. The solution is based on a unique ELT (Extract Load Transform) architecture, eliminating the need for a standalone ETL server and proprietary engine.
Oracle Data Integrator Features
ODI has many valuable key features. Some of the most useful ones include:
Oracle Data Integrator Benefits
There are many benefits to implementing ODI. Some of the biggest advantages the solution offers include:
Reviews from Real Users
Below are some reviews and helpful feedback written by PeerSpot users currently using the Oracle Data Integrator (ODI) solution.
Brian D., Business Process and Strategy Specialist Advisor at NTTData, says, “The Knowledge Module (KM) is my favorite feature of ODI. This is where I learned how to use variables to make jobs dynamic. I took that knowledge and created a KM that would go into iTunes and pull the sales of eBooks. Making something that is reusable, like a KM, is important to not only reduce build time but also maintenance in the future.”
Ashok S., Applications Support Manager at a marketing services firm, mentions, "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."
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.