Oracle Data Integrator (ODI) vs. Oracle Integration (OIC)

Oracle Data Integrator (ODI)

Oracle Integration (OIC)

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Oracle Data Integrator (ODI)	Score 6.2 out of 10	N/A	Oracle Data Integrator is an ELT data integrator designed with interoperability other Oracle programs. The program focuses on a high-performance capacity to support Big Data use within Oracle.	N/A
Oracle Integration (OIC)	Score 5.0 out of 10	N/A	The Oracle Integration Cloud Service is an iPaaS providing prebuilt integration flows between applications, including other Oracle products. The Integration Cloud Service is scaled for enterprises, with prebuilt codeless adapters for on-premises and SaaS systems and low-code automation capabilities.	N/A

Pricing

Oracle Data Integrator (ODI)

Oracle Integration (OIC)

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
Oracle Data Integrator (ODI)	Oracle Integration (OIC)
Free Trial
No	Yes
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Optional

Additional Details

—

More Pricing Information

Community Pulse
	Oracle Data Integrator (ODI)	Oracle Integration (OIC)
Considered Both Products	Oracle Data Integrator (ODI) Verified User Anonymous Chose Oracle Data Integrator (ODI) This is very easy to integrate with Oracle data sources and as most of my databases are in oracle so I gave preference to this tool. Incentivized Helpful? Lakhan Suri SQL AND BI Developer Chose Oracle Data Integrator (ODI) MuleSoft Anypoint Platform and Alteryx Platform Incentivized Helpful? Cameron Gable Software Engineer III Chose Oracle Data Integrator (ODI) I have used Trifacta Google Data Prep quite a bit. We use Google Cloud Platform across our organization. The tools are very comparable in what they offer. I would say Data Prep has a slight edge in usability and a cleaner UI, but both of the tools have comparable toolsets. Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Oracle Data Integrator works very well if the rest of your systems are in the Oracle environment. There are some other good alternatives out there, but for what Oracle Data Integrator has to offer, it is good. It is also a little harder to use compared to the other ones I have … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) We were using Actian Pervasive before switching to Oracle and the main reason was the cost. We were getting less functionality at even more cost. Although it is much faster in terms of operation, Oracle makes it easy to connect to all data sources making data integration easier … Incentivized Helpful? zahit bogus Business Intelligence Consultant Chose Oracle Data Integrator (ODI) I have used the Pentaho Data Integrator ETL tools in different projects with the SQL Server Integration Services product from the Microsoft product family. Oracle Data Integrator ETL product is efficient in projects where Oracle databases are heavily used. The end-user … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Powerful features and Oracle based Incentivized Helpful? Holman Cárdenas, M.Eng, TOGAF®, ITIL® CIO (Chief Information Officer) Chose Oracle Data Integrator (ODI) Since our main databses are Oracle, we decided to use this tools. No other tools were evaluated (some research made, though). Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) I think that Oracle Data Integrator is much better because of the user interface it provides. Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Chose Oracle Data Integrator for its compatibility and integration with Oracle Goldengate Incentivized Helpful? Ashwini Chandorkar Senior Analyst Chose Oracle Data Integrator (ODI) ODI is best suited for Oracle Hyperion environments. We have also used it to manage files on different operating systems. Incentivized Helpful? Paolo Borghi Oracle Business Intelligence Consultant Chose Oracle Data Integrator (ODI) Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, … Incentivized Helpful? Jérôme Françoisse Data Integration Lead Chose Oracle Data Integrator (ODI) ODI is the naturel successor of OWB, adopting the same EL-T approach but supporting a lot more technologies as source and target. The overall product is much more stable and not tied to the Oracle database. Unlike Informatica, ODI generates all the code in the native underlying … Incentivized Helpful? Gurcan Orhan Senior Solutions Architect Chose Oracle Data Integrator (ODI) Because of variety of my projects that I involved, I used nearly all the world wide known tools within data warehouse environment. Data Modeling Tools : Sybase Power Designer, SQL Developer Data Modeler, ERwin Data Modeler. Incentivized Helpful? Ely Turkenitz IS Manager, Data Services Chose Oracle Data Integrator (ODI) We migrated to ODI from OWB - and we found ODI to be light years ahead of OWB (features, performance, and connectivity). We also looked at Informatica, but were turned down by its cost. Being a SAP Business Objects shop, we also considered the SAP Data Integrator tool (it … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Oracle's own ETL tool was Oracle Warehouse Builder, initially. When Oracle built the Oracle Business Intelligence Applications Suite, Oracle is in need of a strong ETL. As Oracle Warehouse Builder is not a strong ETL that customers prefer and as already Informatica captured … Incentivized Helpful? Federico Shortrede CIO Chose Oracle Data Integrator (ODI) We thought IBM was too expensive and more difficult to use. With Microsoft, since we have our main application running with Oracle DB, we understood it’d be easier for us to work with ODI. Incentivized Helpful? Samir Patel, PMP SQL Development Team Lead Chose Oracle Data Integrator (ODI) Oracle Data Integrator is a superior tool when dealing with Hyperion Planning and Essbase cubes and applications. The native connectors allow for easy data movement and transformations from one environment to the other. I do believe that Oracle Data Integrator is a very complex … Incentivized Helpful? James Parks Technology Consultant Chose Oracle Data Integrator (ODI) Informatica was slightly more intuitive but slightly less powerful than Oracle Data Integrator. My use of Informatica was much less extensive than Oracle Data Integrator, so I can not speak as in-depth about the strengths and weaknesses of Informatica. We used ODI much more for … Incentivized Helpful? Peter Shepherd Manager Chose Oracle Data Integrator (ODI) ODI is less user friendly than FDM and DRM but is much easier to deploy than core ETL tools such as HAL or Informatica. The tool is easier to master and is usually more than capable of handling the run of the mill tasks required for Hyperion deployments. It has been a good … Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) IBM Infosphere, Informatica. I worked on the mentioned tools as well as ODI. I liked ODI because it is easy to use with great features that every other ETL tool has in the market. Incentivized Helpful? Verified User Anonymous Chose Oracle Data Integrator (ODI) Our organization was using the Oracle BPM and the Oracle Data Integrator has good integration with BPM. We got good support from Oracle in setting up the integrated environment. Incentivized Helpful?	Oracle Integration (OIC) AC Alexander Cooper RPA Developer Chose Oracle Integration (OIC) The nearest thing I have used to OIC is UiPath, as it is often used as a tool to integrate software together. However, it is much more suited to legacy software which have little to no API endpoints. If the infrastructure already exists I understand why people use RPA for … Incentivized Helpful? JS jyoti shah OCI Architect Chose Oracle Integration (OIC) Easy comparatively. Incentivized Helpful? LR Lavanya Reddy Advisor Chose Oracle Integration (OIC) Oracle Integration (OIC) Cloud is a new iPaaS that makes it very easy to connect ERP applications with Salesforce.com. They have pre-built connectors that eliminate errors by not having to worry about all the connection details needed to make sure the data mapping is accurate. … Incentivized Helpful? NH Nagoor Gani harun Senior Manager Chose Oracle Integration (OIC) Oracle has more SAS offerings than any other vendor and a higher number of clients are going towards Oracle SAS offering. In order to integrate SAS with other systems, OIC comes up with pre-built cloud adapters which make the turn around time faster than any other tool. Incentivized Helpful? SP supriya prabhakara solutions architect Chose Oracle Integration (OIC) Oracle Mobile HUb is good to support the integration between Oracle ERP and Cloud systems. Integration Cloud is way broader in supporting the integration between both Oracle and non oracle third party systems. Wherever the transactions are real time and huge, Integration Cloud … Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) I haven't used any products like Oracle Process Cloud in the past, but our organization is planning to test out UIPath RPA and see how it compares with Oracle Process Cloud in the near future. Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) Since we have the PeopleSoft application and other Oracle products, OIC seemed an ideal fit. Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) Oracle Integration Cloud product focuses more on integration compared to other Oracle products that we are using. We selected the OIC product to solve our integration needs, which are growing day by day, and the core applications are becoming more of the backbone of these … Incentivized Helpful? JO Jerry Osmus Sr. Systems Integration Engineer Chose Oracle Integration (OIC) This is my first PaaS product I've used, so I cannot compare it to others, but I can attest to the ease of development vs coding integrations from scratch. It is a huge time saver from a development standpoint. Incentivized Helpful? FP Fenil Patel System Analyst Chose Oracle Integration (OIC) Since we have Oracle DB and numerous other Oracle products, OIC seemed an ideal fit. Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) OIC was better than all competitors evaluated. Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) Azure API Management Incentivized Helpful? AK Anand Kankaliya Associate Manager Chose Oracle Integration (OIC) Boomi has more stable integration and connectivity to SFDC, email and a few other adapters, but with OIC the user-friendly UI makes it simpler to build and support various integrations. Incentivized Helpful? PP Priyanka Penikalapati IT Analyst - Command Center Chose Oracle Integration (OIC) Integrated well with our oracle suite of products Incentivized Helpful? SN Stephanie Nagel Digital Consulting Analyst Chose Oracle Integration (OIC) Great for data storage and maintenance Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) OIC has allowed us to decommission our Tibco environment and migrate from outsourced integration development to in house where costs are lower and time to development has increased in some cases from months to days or weeks. Incentivized Helpful? Verified User Anonymous Chose Oracle Integration (OIC) Oracle looks and is great to use in comparison to other products. It requires less coding and is deployed easy and fast. Incentivized Helpful? AW Anish Walinjkar Project Manager / Principal Solution Architect Chose Oracle Integration (OIC) The other option is SAP HANA Cloud Integration or SAP PI/PO as compared to OIC. However, there are less/no adapters available on SAP. Incentivized Helpful? RD Ramesh Dhullipaua Sr IT Developer Chose Oracle Integration (OIC) It can integrate with any software or hardware and is easy to deploy between Enterprise Resource Planning, Supply Chain functions like procurement, inventory, ordering, on-premise applications, and human resources, marketing, sales and services. The connectors for databases … Incentivized Helpful? RA Rhianna Albert Director, CX Evangelist - Service Cloud Chose Oracle Integration (OIC) Oracle's solutions play well with their own software and other systems. Their cloud products are familiar if you have used one and the UI is easy to use. Uptime and reliability are also always a factor. Incentivized Helpful? SS Shalindra Singh Sr. Principal Solution Architect / Delivery Manager Chose Oracle Integration (OIC) Workato, SAP Cloud Platform and Mule ESB Incentivized Helpful? VR Vijaya Reddy Founder Chose Oracle Integration (OIC) Most of the customers wanted to consolidate and prefer to have one solution provider for their entire needs (Hardware, OS, DB, SOA, UI, security) Incentivized Helpful? RP Ryan Payne Oracle Solution Architect Chose Oracle Integration (OIC) SOA Suite Leverages JDeveloper and is much more robust than the standard tool. It incorporates so much more and has easy to use GUI features making it truely no comparison. Incentivized Helpful? BG Brad Gibson Senior Solutions Architect Chose Oracle Integration (OIC) In my opinion there are other products that can implement SOA but the Oracle SOA Suite is the most comprehensive product available. I have not encountered many clients that disagree. While they may sometime moan and groan about the complexity they know that Oracle provides some … Incentivized Helpful?

Features

Oracle Data Integrator (ODI)

Oracle Integration (OIC)

Data Source Connection

Comparison of Data Source Connection features of Product A and Product B
	Oracle Data Integrator (ODI) 9.6 Ratings 13% above category average	Oracle Integration (OIC) - Ratings
Connect to traditional data sources	9.90 Ratings	00 Ratings
Connecto to Big Data and NoSQL	9.30 Ratings	00 Ratings

Data Transformations

Comparison of Data Transformations features of Product A and Product B
	Oracle Data Integrator (ODI) 9.9 Ratings 19% above category average	Oracle Integration (OIC) - Ratings
Simple transformations	9.90 Ratings	00 Ratings
Complex transformations	9.90 Ratings	00 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	Oracle Data Integrator (ODI) 9.2 Ratings 14% above category average	Oracle Integration (OIC) - Ratings
Data model creation	9.30 Ratings	00 Ratings
Metadata management	9.50 Ratings	00 Ratings
Business rules and workflow	9.10 Ratings	00 Ratings
Collaboration	8.50 Ratings	00 Ratings
Testing and debugging	9.30 Ratings	00 Ratings

Data Governance

Comparison of Data Governance features of Product A and Product B
	Oracle Data Integrator (ODI) 9.1 Ratings 11% above category average	Oracle Integration (OIC) - Ratings
Integration with data quality tools	9.50 Ratings	00 Ratings
Integration with MDM tools	8.70 Ratings	00 Ratings

Cloud Data Integration

Comparison of Cloud Data Integration features of Product A and Product B
	Oracle Data Integrator (ODI) - Ratings	Oracle Integration (OIC) 7.4 Ratings 8% below category average
Pre-built connectors	00 Ratings	7.80 Ratings
Connector modification	00 Ratings	7.80 Ratings
Support for real-time and batch integration	00 Ratings	5.80 Ratings
Data quality services	00 Ratings	6.10 Ratings
Data security features	00 Ratings	8.00 Ratings
Monitoring console	00 Ratings	9.20 Ratings

Best Alternatives
	Oracle Data Integrator (ODI)	Oracle Integration (OIC)
Small Businesses	Skyvia Score 9.9 out of 10	Make Score 8.9 out of 10
Medium-sized Companies	IBM InfoSphere Information Server Score 8.0 out of 10	IBM App Connect Score 9.5 out of 10
Enterprises	IBM InfoSphere Information Server Score 8.0 out of 10	IBM App Connect Score 9.5 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	Oracle Data Integrator (ODI)	Oracle Integration (OIC)
Likelihood to Recommend	8.0 (0 ratings)	8.6 (0 ratings)
Likelihood to Renew	10.0 (0 ratings)	- (0 ratings)
Support Rating	- (0 ratings)	9.0 (0 ratings)
Implementation Rating	7.0 (0 ratings)	- (0 ratings)

User Testimonials
	Oracle Data Integrator (ODI)	Oracle Integration (OIC)
Likelihood to Recommend	I tried various ETL tools and here is [where and] why I recommend Oracle Data Integrator. 1. When you want to process structured data from different databases - Teradata, Exadata, DB2, SQL, Oracle etc. 2. Oracle Data Integrator supports all platforms, hardware, and OS. This is a major advantage compared to other leading tools. 3. The ELT architecture giving a cutting edge performance over leading ETL tools. There is no need to align Oracle Data Integrator between source and target. ODI uses the source and target servers to perform complex transformations. 4. Speeds up the development and maintenance by reducing the code that developers need to write Incentivized Verified User Anonymous Read full review	Oracle Process Cloud is suited for medium-sized companies and up who want to create applications that can automate tasks without the need of recruiting more software developers. With a couple hours of training, any member of the organization's business team will be well-equipped with all of the knowledge that is needed to use Oracle Process Cloud effectively. If your IT team is large and able to take upon the task of making the given application, then something like Oracle BPM is a better solution. Incentivized Verified User Anonymous Read full review
Pros	Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types. Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target. Incentivized Verified User Anonymous Read full review	Auto-association of Oracle applications prepopulates the application connector select box and preconfigures Oracle Integration (OIC) using secure credential access for faster integration. Various other system connectors are available to use readily. User-intuitive experience--Connectors, integrators, and dashboard can be seen on one page. Incentivized Verified User Anonymous Read full review
Cons	Oracle support is not the best when needing help with the system The documentation is also very poor and takes very long to generate Some parts of it are not intuitive to use and get hard to troubleshoot Like other Oracle products, you must have very, very thorough knowledge about their systems to understand Like all Oracle products, cost is high Incentivized Verified User Anonymous Read full review	Currently, it is not retaining the logs for more than 3 days, which it needs to address. We also need some functionality inside the interface to re-push the same transaction again so that it will be helpful while testing and fixing the issue. Also, some log errors are not giving the correct details. Oracle needs to rectify those. Incentivized Verified User Anonymous Read full review
Likelihood to Renew	It is maturing and over time will have a good pool of resources. Each new version has addressed the issues of the previous ones. Its getting better and bigger. Verified User Anonymous Read full review	No answers on this topic
Support Rating	No answers on this topic	The team is proactive and takes the issue up for resolution, they follow continuous development and release. Incentivized Shalindra Singh Sr. Principal Solution Architect / Delivery Manager Read full review
Alternatives Considered	Talend Data Integrator has been evaluated during the setup of the architecture for a customer, in comparison to ODI, since it's an open source ETL. But, differently from the meaning of "open source", it has licence costs too that aren't that different from ODI ones. Moreover, the other components of the business intelligence architecture of the customer were Oracle, so we thought that ODI would suit at best with them, more than a different vendor software. Incentivized Paolo Borghi Oracle Business Intelligence Consultant Read full review	The nearest thing I have used to OIC is UiPath, as it is often used as a tool to integrate software together. However, it is much more suited to legacy software which have little to no API endpoints. If the infrastructure already exists I understand why people use RPA for integration, however for when API's are easily accessible and you're using Oracle tools, OIC is better. Incentivized Alexander Cooper RPA Developer Read full review
Return on Investment	Oracle Data Integrator helps provide a business with the data it needs to defend the decisions it makes. Oracle Data Integrator allows you to analyze data from what can be separate, different, and often outdated data sources. It allows you to make direct comparisons when analyzing data from different pieces of equipment. Data from Oracle Data Integrator was used to analyze manufacturing quality and drive down spoilage, saving the company money. Incentivized James Parks Technology Consultant Read full review	We run big integration practices and that practice is pretty successful. We have seen the customer getting quick ROI as the initial investment is not much. The customer can also get a free 1-month trial instance of OICS to try out. All of our customers are happy with this investment so far. Incentivized Shalindra Singh Sr. Principal Solution Architect / Delivery Manager Read full review
ScreenShots		Oracle Integration (OIC) Screenshots