Oracle Data Integrator and Azure Data Factory compete in the data integration sector. ODI offers comprehensive EL-T capabilities with strong database processing, while Azure Data Factory is preferred for its seamless Azure integration and user-friendly visual pipelines.
Features: Oracle Data Integrator showcases advanced loading capabilities of slowly changing dimensions, re-usable mappings, and automation through scripting. Its Knowledge Module methodology and multi-platform connectivity are key advantages. Meanwhile, Azure Data Factory stands out with its visual pipeline creation, ease of use, and seamless integration with various Azure services.
Room for Improvement: Oracle Data Integrator could improve in areas such as its steep learning curve, outdated interface, and error handling limitations. Moreover, it needs more efficient multi-user processes. Azure Data Factory requires better integration with non-Microsoft services, enhanced real-time data capabilities, and simplified error handling and pipeline monitoring. Pricing model complexities also need addressing.
Ease of Deployment and Customer Service: Oracle Data Integrator's on-premise deployment suits controlled environments but can complicate deployment. Reactions to its customer service are mixed, with broad support yet challenges with multi-technology resolutions. Azure Data Factory offers cloud deployment, making it flexible and scalable. Its customer service is appreciated for its active and broad support, although pricing complexity affects support clarity.
Pricing and ROI: Oracle Data Integrator is seen as expensive, driven by its source and target databases. Users recommend exploring bundles or alternatives to manage costs. Its powerful features imply a solid ROI if well-optimized. Azure Data Factory's pay-as-you-go model provides flexibility but poses estimation challenges. Despite being costly with high usage, its competitive pricing, integration, and scalability are acknowledged for significant ROI potential.
The technical support from Microsoft is rated an eight out of ten.
The technical support is responsive and helpful
The technical support for Azure Data Factory is generally acceptable.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
Azure Data Factory is highly scalable.
The solution has a high level of stability, roughly a nine out of ten.
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
There is a problem with the integration with third-party solutions, particularly with SAP.
Sometimes, the compute fails to process data if there is a heavy load suddenly, and it doesn't scale up automatically.
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.
The pricing is cost-effective.
It is considered cost-effective.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
It connects to different sources out-of-the-box, making integration much easier.
The interface of Azure Data Factory is very usable with a more interactive visual experience, making it easier for people who are not as experienced in coding to work with.
I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.
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.
