Oracle Data Integrator and Azure Data Factory are both prominent players in the data integration category. Azure Data Factory appears to have an advantage with its user-friendly interface and extensive data transformation capabilities, appealing to businesses looking for comprehensive real-time data processing and cloud integration.
Features: Oracle Data Integrator offers advanced ELT capabilities with strong integration across various technologies, such as RDBMS and Hadoop. It supports scripting languages and has robust data integrity features. Its Knowledge Modules enable reusable integration strategies. Azure Data Factory provides an easy-to-use pipeline orchestration tool with over 100 built-in connectors, facilitating real-time data movement and transformation across platforms.
Room for Improvement: Oracle Data Integrator could improve its error handling, simplifying the reverse engineering process, and enhancing GUI performance. Users also note a steep learning curve and less intuitive configuration management. Azure Data Factory could enhance real-time processing capabilities, enrich prebuilt connectors, and improve documentation and support for better customer experience.
Ease of Deployment and Customer Service: Oracle Data Integrator supports on-premises and hybrid cloud deployments, often requiring significant hardware resources, impacting deployment times. Customer support can be fragmented across product lines. Azure Data Factory's cloud-native design supports agile deployment, integrating seamlessly into cloud environments, though service efficiency varies due to complex support channels.
Pricing and ROI: Oracle Data Integrator is often seen as expensive due to complex licensing and additional database costs, making it suitable for larger enterprises seeking long-term operational savings. Azure Data Factory's pay-as-you-go model allows flexibility but can scale with usage. Despite pricing complexity, it provides good ROI through scalable services and efficient data management.
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.