The use case involved integrating a GMI-specific solution, which was a customer requirement. We used the software provided by the customer for this purpose. However, within our organization, we consumed some of the services by using Oracle.
Vice President at Fluentgrid
The solution's initial setup is straightforward compared to its competitors
Pros and Cons
- "The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup."
- "In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
What is our primary use case?
What is most valuable?
I will need to involve the integration team to elaborate on the features, as they can provide input. I work mostly on the functional-technical side. However, in Oracle Data Integrator, the governance, especially the service governance, is good. There is also a schedule-based data-pulling mechanism. The message-pulling mechanism in the solution is good, and we can define threshold limits on top of the services. For instance, if I publish some equipment gateway or email gateway, the end user can consume a specific number of services from the solution.
What needs improvement?
In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release. Specifically, I'd like to see if the solution will support us in acquiring data from our databases.
For how long have I used the solution?
I have been using Oracle Data Integrator for the past two years in a customer implementation process where the solution was required. Also, I have experience with the solution's commercial version. I am a solutions consultant.
Buyer's Guide
Oracle Data Integrator (ODI)
June 2025

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
860,592 professionals have used our research since 2012.
What do I think about the stability of the solution?
Stability-wise, I rate this solution a seven out of ten.
What do I think about the scalability of the solution?
In our organization, we have not checked whether Oracle Data Integrator is scalable, including whether it is vertically or horizontally scalable or can scale automatically. However, we can deploy and configure it. We have only worked with Oracle Data Integrator in one of the deployments. At the same time, we were involved with Pentaho Data Integration for the other deployments. To ensure the solution's maintenance, we require a staff of three technical experts, including an integration expert and an ESB expert.
How are customer service and support?
We haven't had any experience with the solution's technical support team. Also, technical support-related affairs are taken care of by a different team.
Which solution did I use previously and why did I switch?
We have used WSO2 Integration for a proof of concepts (POC) in our organization. We have also used Red Hat Fuse and Pentaho Data Integration. So, we have worked on these tools from an ESB point of view. Also, commercial ESBs like Oracle Enterprise. We primarily used Red Hat Fuse for APM and ACM, deployed specifically for one of our customers between 2015 and 2016. So, our recent experience is with Pentaho Data Integration and Hitachi Pentaho Data Integration.
How was the initial setup?
The solution's initial setup is straightforward, especially compared to Mule, which our team has worked with before and found to be a bit more complex in terms of setup. Pentaho Data Integration and Hitachi Data Integration are also good.
Since the deployment of Oracle Data Integrator has already been done, the customer provides the platform or software. Another team is responsible for maintaining the solution while we have published some of its services. It takes around three months to deploy the solution.
What's my experience with pricing, setup cost, and licensing?
Our company didn't have to pay for the license of the solution since our customer had already paid for it.
What other advice do I have?
Based on the customer's requirement, I would recommend the solution to them. In our company, we have prior experience with ESBs. We can suggest multiple ESB options that are best suited to the customer's needs. Overall, I rate this solution an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Manager- Application and Cloud Services at a tech services company with 501-1,000 employees
Good plug-ins, capable of constant extraction, and is user-friendly
Pros and Cons
- "It's scalable."
- "The price needs to be lowered. It's too expensive."
What is our primary use case?
We had an opportunity to set up a data warehouse. We were doing a complex stack of Oracle. The customer was using Oracle as their backend database.
What is most valuable?
It can extract all day. It doesn't look after any particular database. It is not platform-dependent, and that's the main thing that makes it really useful.
It has good plug-ins.
The studio was quite useful.
It was a user-friendly product.
The product is stable. It's scalable.
What needs improvement?
The price needs to be lowered. It's too expensive.
There are a few other tools that can do what Oracle does. It's not necessarily the leader in the space.
As far as what I have learned from other people, I've heard that the Oracle console is big and confusing. If it was less complex, it would be easier to customize.
For how long have I used the solution?
I've used the solution for two or three projects. I last used it less than a year ago.
What do I think about the stability of the solution?
This is a very, very stable product. It's reliable. There are no bugs or glitches, and it doesn't crash or freeze.
What do I think about the scalability of the solution?
The solution can scale well.
How are customer service and support?
I haven't created any tickets through support. However, my understanding is that, once you open a ticket, they will ask many, many questions, and they do resolve things. It can just be frustrating when you need a problem solved, and they just keep asking questions. There's a bit of going back and forth.
Which solution did I use previously and why did I switch?
We are actually moving away from Oracle, as it's not very reasonable cost-wise.
What you can do on ODI, for example, can be done on SSIS from Microsoft too, which is free of cost.
How was the initial setup?
In terms of the initial setup, at first, it was a bit hard for me. That said, it is pretty straightforward once you are done with this data source connection tool and once you are done with this on the repository side. Setting up a reporting server was easy, however, doing the middleware, especially on the application server, was a bit tedious for me.
I'd rate the setup process a four out of five in terms of ease of implementation.
What's my experience with pricing, setup cost, and licensing?
It's quite an expensive solution. We'd like it if they could adjust the pricing according to the region they are operating in.
Per user, it is $900 USD per year, though they will give some discount. However, even a 60% to 70% of discount for each won't help us much. On top of that, there is the perpetual license you must pay at the outset.
I'd rate the cost at a one out of five in terms of affordability.
What other advice do I have?
I've used the solution mostly on the testing side. I haven't done anything on the client side or on the production side.
I'd rate the solution nine out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner / Reseller
Buyer's Guide
Oracle Data Integrator (ODI)
June 2025

Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
860,592 professionals have used our research since 2012.
Senior Plsql & ODI Developer at Infosys
Quick support, easy to use, and integrates with all systems
Pros and Cons
- "Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application."
- "It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
What is most valuable?
Integration with all systems is easy with Oracle Data Integrator, and it is easy to use. I have not used any other product, but with Oracle Data Integrator, we can easily connect to an ERP system, an SAP system, or a cloud application.
What needs improvement?
It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us.
For how long have I used the solution?
I have been using this solution for around seven years.
What do I think about the stability of the solution?
It is pretty good.
What do I think about the scalability of the solution?
It is scalable.
How are customer service and support?
I didn't contact them for the line breakage issue, but I have contacted them for other things. My experience with them was good. Their solution was quick and the response was quick. I would rate them a four out of five.
What was our ROI?
We have seen a return on investment with this product.
What other advice do I have?
Everything is good, and I would rate it an eight out of ten.
Disclosure: My company has a business relationship with this vendor other than being a customer. Partner
Applications Support Manager at a marketing services firm with 1,001-5,000 employees
Easy to develop, plenty of templates, and scalable
Pros and Cons
- "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."
- "The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects."
What is our primary use case?
We use ODI for integration services from different systems, such as finance systems and online display systems. Additionally, we integrate it with the external partners with ODI.
We use ODI in combination with the SFTP server.
What is most valuable?
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.
What needs improvement?
The interface of ODI could be improved. For example, navigating and finding functions can be difficult. For example, you have to know which step you need to go to look at where your job status is. The logical step is a bit complex compared to other tools. It's much easier to get a graphical view, but with ODI, it's graphical, plus you have to know all the other pieces that fit around it. You have to think about the logical and physical aspects.
One aspect I always struggle with is there's no single view to see which jobs are going to run or what time. You have to look around, it's very clunky. If you had a couple of agents, you can't see everything in one place. You have to go and look at an agent schedule and look at that, and then, go to another one to look. There's no single view that gives you the whole picture.
What would be nice for us is, if ODI can easily integrate to GitHub, to allow us to have all our source code in GitHub rather than within ODI. This would be a very good feature, everyone is using GitHub.
For how long have I used the solution?
I have been using Oracle Data Integrator (ODI) for approximately two years.
What do I think about the stability of the solution?
Since we moved to the new version, ODI has been very stable, and we haven't had any unplanned outages. We only have had planned outages, I'm pretty happy with it.
The only issue we have had recently was when we patched ODI all the jobs that were supposed to be scheduled at 6:00, it ran seven hours earlier. It's a result of the patch. We were working with Oracle and they gave us a fix.
What do I think about the scalability of the solution?
The solution is scalable, we can increase the agents and let it do more work.
We have approximately 12 people using the solution in my organization.
We use this solution extensively without our organization.
How are customer service and support?
The technical support is very good. f you give them all the information, they seem to give you a solution pretty quickly. We have not had any issue with the support. However, we are using paid support and I am not sure if the regular support is the same.
Which solution did I use previously and why did I switch?
I've used other solutions previously, such as Microsoft tools, they are much easier to set up. ODI is a bit clunky to begin operations, it requires a longer learning curve.
We are using this solution extensively.
How was the initial setup?
The initial setup is complex, it took us three months.
What about the implementation team?
We reached out to Oracle and a few other partners that Oracle has but, in the end, we decided we should do it ourselves. If we did not do it ourselves we wouldn't have the knowledge of how to do it in the future. We received a quotation from them and then decided, we would do it ourselves, in-house.
For all these cloud products, we have to patch them ourselves, it is not done automatically. I was expecting patching to be automatic but it is not.
What's my experience with pricing, setup cost, and licensing?
The solution is expensive because of the model they use. The cost is for the license and for support.
What other advice do I have?
I would recommend it if they were an Oracle house mostly. It works very well with other Oracle products. If a business is not an Oracle shop, I would not recommend it. OBI understands Oracle E-business, Oracle CRM, and other Oracle products well. However, if you were to go to another company that had different products, ODI would struggle.
I rate Oracle Data Integrator an eight out of ten.
Which deployment model are you using for this solution?
Public Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Other
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Technical Lead at a computer software company with 10,001+ employees
Light on resources, good support, simple implementation
Pros and Cons
- "ODI's most valuable features are it utilizes the database engine and is very lightweight."
- "ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use."
What is our primary use case?
Oracle Data Integrator (ODI) integrates with the cloud, but the 12C version only can be integrated with the cloud. The best part of the ODI is, it does not have its own ETL engine of its own, it utilizes the database engine itself.
We use ODI for data integration only, such as extraction, transformation, and loading of data from different sources into one particular database. Additionally, we use ODI for our data warehouse.
What is most valuable?
ODI's most valuable features are it utilizes the database engine and is very lightweight.
ODI's ability to connect multiple types of database environments from a particular server, place, or system is beneficial. I can connect to many databases, such as Dev, UAT, production, or user acceptance test databases. All together in only one place. It's all about changing the context in that particular application. The moment you change the context, the ODI will start processing the data from different environments altogether.
What needs improvement?
ODI could improve by being more user-friendly. Informatica, which is also an ETL tool, similar to ODI, but Informatica is very user-friendly, easy to use, and simple to integrate, compared to ODI. ODI has many features, put them all together, and sometimes we get confused about which ones to use, which ones not to use.
For how long have I used the solution?
I have been using Oracle Data Integrator (ODI) for approximately two years.
What do I think about the stability of the solution?
The stability of Oracle Data Integrator is very good.
What do I think about the scalability of the solution?
ODI is scalable, it is a matter of your configuration. If you configure the tools properly it is scalable.
The solution can be used for small to large enterprises.
How are customer service and support?
I have been satisfied with the technical support.
Which solution did I use previously and why did I switch?
I have used other solutions previously.
How was the initial setup?
ODI has one of the easiest implementations out of all the others for a database.
What other advice do I have?
I would recommend using ODI if we are using an Oracle Database as your data warehouse, or as your primary database only. If not then I wouldn't recommend ODI to be used.
I have seen the newer cloud version and I think it is more user-friendly than the older versions.
I rate Oracle Data Integrator an eight out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer. partner
Director at a computer software company with 1,001-5,000 employees
Proven high performance with large-scale data processing
Pros and Cons
- "Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
- "An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
What needs improvement?
An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types.
What do I think about the stability of the solution?
ODI is a proven product with high performance in large-scale data processing.
What's my experience with pricing, setup cost, and licensing?
ODI comes included when buying the cloud version of the Oracle database license.
What other advice do I have?
ODI is very friendly to those who have been traditionally writing a scale PL/SQL. It has lots of connectors to many different sources, although the target databases it supports are relatively limited compared to Informatica. It's also easier to understand, very developer-friendly, and has a big forum community and lots of documentation for support. I would rate it as nine out of ten.
Which deployment model are you using for this solution?
Hybrid Cloud
If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?
Amazon Web Services (AWS)
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Banking Excellence - Predictive Analysis at a financial services firm with 11-50 employees
Easy to set up with good integrations and great scalability
Pros and Cons
- "The scalability is great. It's one of the reasons we chose the solution."
- "The resource management aspect of the solution could be improved."
What is our primary use case?
We primarily use the solution for digital health and sometimes automation tasks.
What is most valuable?
The integration of the solution with Oracle is very good. It's nice and easy.
The scalability is great. It's one of the reasons we chose the solution.
The stability is okay.
We found the implementation to be quick and easy.
What needs improvement?
The resource management aspect of the solution could be improved.
The migration process could be easier.
Technical support could be better. They're okay, however, their service could improve a bit.
The solution could be more reliable.
For how long have I used the solution?
I've been dealing with the solution for around four years at this point.
What do I think about the stability of the solution?
The stability of the solution is pretty good. It doesn't crash or freeze on us. We don't have any bugs or glitches.
What do I think about the scalability of the solution?
We have about 20 people using the solution within our organization. They use it on a daily basis.
We deployed with scalability in mind. We've found it to be quite effective.
How are customer service and technical support?
We've contacted technical support in the past. They're okay in terms of the service we provide. I would rate them seven out of ten overall. They could be a bit better.
Which solution did I use previously and why did I switch?
We did previously use a variety of different solutions. So far, this product has been the best option for our organization. It has more features and integration capabilities. It's a bit more complex than other options.
How was the initial setup?
The initial setup of the solution is not complex. It's very straightforward. We found it to be easy.
For simple mapping, deployment only takes about half an hour.
We handle the maintenance ourselves. Occasionally, we may reach out to Oracle for certain tasks, however, largely, we deal with everything maintenance related internally.
What about the implementation team?
We did not need the help of a vendor or integrator. We did do everything on our own.
What's my experience with pricing, setup cost, and licensing?
The solution isn't the most expensive, nor is it the cheapest option. In terms of pricing, it sits somewhere in the middle. Everything is covered under one license. You don't have to buy any add-ons.
What other advice do I have?
We're simply an Oracle customer. We don't have a business relationship with the company.
There's no specific version of the solution that we use.
I wouldn't recommend any other services above Oracle.
Overall, I would rate the solution eight out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Solutions Architect at a tech consulting company with 51-200 employees
If it doesn't connect out-of-the-box to a specific technology, we can add a new technology into it
What is our primary use case?
We mainly use ODI to integrate all of our EPM applications, which includes Essbase ASO/BSO cubes, Hyperion Planning, DRM and HFM applications. Also it is used to manage a custom data warehouse developed in Oracle DB which is used as source for OBIEE reporting.
How has it helped my organization?
We use ODI to integrate all Oracle EPM suite used in our financial area. ODI is the core engine used to move data across different applications every day. It’s by far the most important architectural element in our BI/EPM environment since all data passes through it.
What is most valuable?
ODI has the ability to connect to virtually any technology out there. If it does not connect out-of-the-box, we can very easily add a new technology into it. This flexibility gives a tremendous developmental advantage to its users, which can use ODI as the official ETL tool for any kind of integration project.
Its Knowledge Modules (KMs) may abstract the “how” portion of integrations, allowing the users to focus on the “what” that needs to be done. It can be easily used by either young ETL developers or expert professionals.
For resumes, the ease of use for young professionals and its great development flexibility for expert professionals make it a great product to be used for every ETL project out there.
What needs improvement?
In my opinion, ODI should connect to ALL Oracle products out-of-the-box, but currently that’s not the case for all of them. Hyperion Financial Management (HFM) is one of the Oracle products for which Oracle decided to remove its ODI support in its last product version. In other words, if you wish to use ODI and HFM together, both from Oracle, you will need to create custom code, which does not make any sense to me.
Another area to improve would be the development life-cycle, which did improve in the latest ODI version, but needs further improvements.
For how long have I used the solution?
More than five years.
What do I think about the stability of the solution?
ODI 12 version is very stable. It can manage several parallel executions/large volumes without much trouble.
What do I think about the scalability of the solution?
ODI scales very well.
How are customer service and support?
This is a delicate subject. My experience with Oracle support has both great and very bad situations. If the problem that you are facing is only related to ODI, then your chances of having a great Oracle support experience are good. But if your problem involves multiple technologies, like ODI integrating EPM apps, then it is probably going to be a nightmare (and, unfortunately, most of the problems that will require support assistance will involve “multiple technologies”).
This happens because Oracle supports different technologies with different teams and the communication between them seems complicated sometimes. Several times I was in a situation where teams would keep discussing who should fix the problem instead of actually fixing it.
Which solution did I use previously and why did I switch?
I've always worked with ODI for ETL development.
How was the initial setup?
The initial setup is extremely easy and straightforward.
Which other solutions did I evaluate?
ODI was the only option we considered.
Which deployment model are you using for this solution?
On-premises
Disclosure: PeerSpot contacted the reviewer to collect the review and to validate authenticity. The reviewer was referred by the vendor, but the review is not subject to editing or approval by the vendor.

Buyer's Guide
Download our free Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros
sharing their opinions.
Updated: June 2025
Product Categories
Data IntegrationPopular Comparisons
Informatica Intelligent Data Management Cloud (IDMC)
Azure Data Factory
Informatica PowerCenter
Palantir Foundry
IBM InfoSphere DataStage
Talend Open Studio
Oracle GoldenGate
SAP Data Services
Qlik Replicate
Alteryx Designer
Buyer's Guide
Download our free Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- Which ETL tool would you recommend to populate data from OLTP to OLAP?
- Oracle ICS vs ODI
- What is your favorite Feature of ODI 12c? (Compared to 10g or 11g)
- Experiences with Oracle GoldenGate vs. Oracle Data Integrator?
- What Is The Biggest Difference Between ODI and OIC?
- Looking for advice on how to invoke a select script through ODI?
- What's the difference between Oracle Integration Cloud Service and Oracle Data Integrator (ODI)?
- What is the best suitable replacement for ODI on Azure?
- When evaluating Data Integration, what aspect do you think is the most important to look for?
- Microsoft SSIS vs. Informatica PowerCenter - which solution has better features?
Hi Rodrigo,
That is good to know those limitations on integrating ODI with EPM applications .
In terms of the main RDBMS in the market I think ODI is quite good in providing the native drivers, when they don't we can find it and place on the ODI drivers folder and works but I guess sometimes there are some commercial roadblocks imposed by oracle, for example I had a hard time to connect ODI with a CRM on the cloud (Sales Force), we had to customize a webservice to accomplish the goal of the project, thankfully it worked fine but I found it really annoying because you could see they had deprecated the connector just because they wanted to force clients to buy Siebel instead, but Oracle realized it and they changed it in the Cloud option making it available to clients .