

Oracle Data Integrator and Oracle Integration Cloud Service are key products in the data integration and cloud service category. ODI is favored for complex data tasks and scalability, while OIC has an edge in cloud integrations due to its extensive library of adapters.
Features: Oracle Data Integrator offers robust ETL capabilities, real-time transformation, and scalable architecture. It leverages Knowledge Modules to enhance integration efficiency and supports various data sources. Oracle Integration Cloud Service is user-friendly, with numerous pre-built APIs, supporting rapid deployment and a wide range of connections, making it ideal for cloud applications.
Room for Improvement: Oracle Data Integrator could improve in user-friendliness, real-time integration, and error handling. Its learning curve and repository management complexities are notable. Oracle Integration Cloud Service could enhance debugging, multi-cloud support, and data volume handling. Both could simplify setup and improve usability against competitors like Informatica.
Ease of Deployment and Customer Service: Oracle Data Integrator is commonly deployed on-premises or in hybrid setups, with responsive technical support, though case resolution speed needs improvement. Oracle Integration Cloud Service excels in cloud environments with favorable cloud support but has occasional issues with problem resolution speed. Users appreciate the technical expertise and support for both products.
Pricing and ROI: Oracle Data Integrator has mid-range pricing that varies with deployment scenarios, while Oracle Integration Cloud Service offers flexible but costly pricing as usage increases. Both promise strong ROI; ODI reduces custom ETL time, whereas OIC's pay-as-you-go model offers cost advantages for cloud connectivity needs.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The customer support for Oracle Integration Cloud Service is accessible through Service Requests (SR) for unknown problems, with a response expected within 24 hours.
I find the technical support from Oracle to be good.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
Oracle has provided some fixes, and in my last two to three large engagements, we haven't faced any major challenges with the product.
The reliability of Oracle Integration Cloud Service is strong.
I raised an Oracle SR to understand why it went down during those five to seven minutes.
Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent.
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.
Adding AI capabilities would make Oracle Data Integrator (ODI) even better.
Setup and deployment can be done in OCI, the Oracle Cloud Infrastructure, allowing for role-based access and configuration, managing access levels for Oracle Integration Cloud Service environments such as Dev, Test, and Production.
The mapping is a bit complex, so configuration is not very easy for a new user.
Most large customers use multiple clouds, and Oracle's partnership with Azure and other hyperscalers needs additional development on the Integration Cloud Service side.
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.
If integration points exceed 30, I recommend that customers use Oracle Integration Cloud Service as it becomes cost-effective with its pay-as-you-use model and multiple available packages.
Oracle Integration Cloud Service's pricing is affordable and reasonable considering its facilities.
At TCS, we also have our own instance because we have purchased the product from Oracle.
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)'s ELT architecture has helped optimize my data movement and transformation significantly.
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 Integration Cloud Service offers capabilities for data customization and validation, handling different date formats, and API calls using REST and SOAP.
Additionally, it provides a wide variety of built-in adapters for many cloud providers, such as Azure Blob and AWS S3.
It is very easy to integrate, and the pre-built APIs available to connect multiple systems help establish connections faster and more accurately.
| Product | Mindshare (%) |
|---|---|
| Oracle Data Integrator (ODI) | 3.0% |
| SSIS | 4.0% |
| Informatica Intelligent Data Management Cloud (IDMC) | 3.8% |
| Other | 89.2% |
| Product | Mindshare (%) |
|---|---|
| Oracle Integration Cloud Service | 3.0% |
| MuleSoft Anypoint Platform | 6.8% |
| Boomi iPaaS | 6.6% |
| Other | 83.6% |


| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 44 |
| Company Size | Count |
|---|---|
| Small Business | 10 |
| Midsize Enterprise | 8 |
| Large Enterprise | 28 |
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.
Oracle Integration Cloud Service offers a user-friendly platform for seamless system integration, combining pre-built adapters and intuitive interfaces with robust performance, supporting REST and SOAP APIs for diverse environments.
Oracle Integration Cloud Service stands out for its comprehensive integration capabilities, allowing businesses to effortlessly connect systems like SAP and Salesforce using a low-code platform. Features include an intuitive drag-and-drop interface that simplifies orchestration across on-premises and cloud systems, complemented by extensive pre-built adapters. Users benefit from seamless integration through REST and SOAP API calls, supported by an insightful dashboard for effective monitoring and powerful security features such as OAuth. While the service offers predictable pricing and scalability, documentation and flexibility require attention. Challenges include handling legacy applications, architectural design, and multicloud integration.
What are the key features?Industries employ Oracle Integration Cloud Service extensively in financial, supply chain, and ERP implementations. Businesses utilize it for connecting databases, payment gateways, REST services, and enhancing system automation. Employing prebuilt adapters allows support for hybrid models, facilitating integration within both Oracle and non-Oracle environments, streamlining tasks for efficient operations.
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.