Oracle Data Integrator and Equalum are contenders in the data integration and ETL platforms category. Equalum holds an advantage due to its real-time data streaming and ease of use, appealing to both beginners and experts, while Oracle Data Integrator's flexibility and extensive capabilities suit more advanced users.
Features: Oracle Data Integrator is known for its flexibility and extensive integration capabilities, supporting over a dozen scripting languages and offering unique ELT functionalities. Its Knowledge Modules streamline ETL processes by abstracting the integration details, focusing more on the desired outcomes. Equalum is recognized for its real-time data streaming and ease of use with no-code capabilities. Integration of Kafka and Spark enables comprehensive CDC, streaming ETL, and batch ETL on a single intuitive platform.
Room for Improvement: ODI's interface could be more responsive, with better error handling and improved integration with Oracle suite products. Users find the Java-based GUI outdated and seek enhanced version control and multi-user development capabilities. Equalum could enhance connectivity with various database types and improve user interface functionalities. Users express a need for broader integration with third-party solutions and better documentation and deployment strategies.
Ease of Deployment and Customer Service: On-premises oriented, Oracle Data Integrator is known for a complex deployment process requiring expert intervention, with mixed reviews on customer service efficiency, especially when dealing with multiple technologies. Equalum's deployment is versatile, accommodating both on-premises and cloud options, with generally positive feedback on customer service due to its easy configuration process.
Pricing and ROI: Oracle Data Integrator is perceived as expensive, with a complex licensing model better suited to large enterprises. It offers high ROI potential when effectively implemented due to its comprehensive features. Equalum's pricing is considered reasonable yet higher compared to local CDC products, offering cost savings from reduced development time. Its straightforward, component-based pricing model allows for a quick ROI if correctly set up.
Equalum is a fully-managed, end-to-end data integration and real-time data streaming platform, powered by industry-leading change data capture (CDC) tech and modern data transformation capabilities (streaming ETL and ELT). Equalum's enterprise-grade platform features intuitive UI allowing you to build robust, real-time data pipelines in minutes.
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.