We changed our name from IT Central Station: Here's why

Oracle Data Integrator (ODI) OverviewUNIXBusinessApplication

Oracle Data Integrator (ODI) is #5 ranked solution in top Data Integration Tools. PeerSpot users give Oracle Data Integrator (ODI) an average rating of 8 out of 10. Oracle Data Integrator (ODI) is most commonly compared to Oracle Integration Cloud Service: Oracle Data Integrator (ODI) vs Oracle Integration Cloud Service. The top industry researching this solution are professionals from a computer software company, accounting for 39% of all views.
What is Oracle Data Integrator (ODI)?

Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate. 

ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes.  It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c.  Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.

Oracle Data Integrator (ODI) was previously known as ODI.

Oracle Data Integrator (ODI) Buyer's Guide

Download the Oracle Data Integrator (ODI) Buyer's Guide including reviews and more. Updated: January 2022

Oracle Data Integrator (ODI) Customers

Griffith University, Kansas City Power & Light, Keste, Raymond James Financial, Valdosta State University

Oracle Data Integrator (ODI) Video

Oracle Data Integrator (ODI) Pricing Advice

What users are saying about Oracle Data Integrator (ODI) pricing:
"The solution is expensive because of the model they use. The cost is for the license and for support."

Oracle Data Integrator (ODI) Reviews

Filter by:
Filter Reviews
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Brian Dandeneau
Business Process and Strategy Specialist Advisor at NTTData
Consultant
Top 5Leaderboard
I have used it to improve run-times of many corporations' overall integration run-times.

How has it helped my organization?

I have used ODI to improve run-times of many corporations' overall integration run-times. Corporations on a daily basis run integration jobs which normally take five hours or more. I have seen these jobs become hourly jobs because of the time reduction they received with ODI's involvement.

What is most valuable?

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.

What needs improvement?

Error handling can always be improved with ODI. A lot of the errors are generic, but I will say that with a little experience, you can decipher the errors to help you fix them. In fact, I find myself not using the debugger that came out with 12c, just because I have learned to read "ODI-login-eze."

If there was a way to keep the basic user from creating a monster SQL that kills a system on execution, that would be great as well.

For how long have I used the solution?

I have used it for 10 years. It's hard to believe it has been that long, but time flies when you have fun -- and I actually have fun when developing integration solutions. I started out on 10g and was able to quickly pick up on the ELT model after working with ETL for years before that. I was one of the first to install 11g on Red Hat. The main reason for the upgrade to 11g was purely looks as there were very little actual enhancements beside a couple of tools.12c was a major overhaul. I love working with 12c as it's now a flow-based tool but still ELT. It brings me back to the days of Hyperion Application Link (HAL), except that 12c isn't slow.

What do I think about the stability of the solution?

Stability is good, better than 10g and 11g.

What do I think about the scalability of the solution?

Scalability-wise, 12c is the best in it's class. I could hand 12c to any size client and they would be fine developing and maintaining it.

How are customer service and technical support?

I think that you get more than the regular Oracle support when you are working with ODI. Even the "First Responders" have a very wide knowledge on the product. This is a pleasant change from some of the other products for which you get the person who asks if your computer is plugged in.

Which solution did I use previously and why did I switch?

I work on all the other integration products as well as ODI. In fact, I had to compare all the integration products (ODI, SSIS, HAL, Informatica, DataStage) when we were trying to decide on the strategic direction for the major bank that I was working for. HAL was being sunset, so easy decision there. DataStage cost a lot to host and was hard to develop in. Informatica was not installed anywhere in the corporation so the knowledge base for us wasn't there, so it got the boot too. It really came down to SSIS and ODI. We had a lot of SSIS knowledge and I was the only ODI developer. I took someone who never seen SSIS and ODI before, but had basic database knowledge, sat them in front of a computer, and gave them a day course on both. To be fair, after each course they had them create a job to do the same load. Results were clear and ODI won hands-down. ODI won out because of price, support, and speed/ease of development.

How was the initial setup?

In 12c, they have made the setup so much more simple then what it used to be. The interface to do the setup walks you through every setup step.

What about the implementation team?

I have been on both sides of the fence for this question. I would always have a vender do the install if you have never used the product before. There are a lot of little tweaks that can be made that takes experience with the tool to know these tweaks. If you have had the product for over a year, I would say, that in-house would be ok. Just make sure that if you have to remediate the install that you involve Oracle in that process so you make sure that all the parts get cleaned up properly otherwise the reinstall could be problematic.

What was our ROI?

The ROI on this tool is dependent on if it is implemented properly. When done properly your ROI is very quick. Most client however block the ability to have this setup properly. However the Cloud version is helping us as consultant show the client how powerful this setup can be.

What's my experience with pricing, setup cost, and licensing?

I would say that you need to pay attention to the licensing to make sure that you are not paying to much. Normally, the licensing can be your friend if you don't need ODI for anything complex. You can switch ODI to go back to ETL if you don't want to spend that much money. Thin about it this way, if you are charged for only where it translates the data, then put a 4-core Red Hat in the middle of everything. Force your jobs to translate only on the Red Hat server. Your 1 million dollar implementation just went to 200k -- you're welcome. The caveat with the ETL setup is that the processing is slower per job -- you're not welcome. Again, ask yourself, what do I really need this for?

What other advice do I have?

Know what you are getting into.

If you are going to use a firm to build out a solution, ask for a Proof of Concept and ask them to show you how flexible it can be. If they can't quickly come up with something, be wary. Don't just go with someone that is cheap, you get what you pay for.

This snapshot is to turn on automapping. This is a very useful function to have on when developing. This will make the magic happen when you connect a source and a target together. This is not in the documentation, so good luck finding how to turn it on if you haven't used it before.

Which deployment model are you using for this solution?

On-premises

If public cloud, private cloud, or hybrid cloud, which cloud provider do you use?

Other
Disclosure: My company has a business relationship with this vendor other than being a customer: We're implementation partners.
Ricardo Giampaoli
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting
Consultant
Top 5Leaderboard
We can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools.

What is our primary use case?

Very large and complexes environments implementation, 10000+ users with 24x7 global operation and multiple EPM tools working in sync.

How has it helped my organization?

For the EPM environment, the ODI is the key to transforming a good project into a great project. With ODI, we can make all the EPM tools work together as one and we can create a puzzle that will increase the performance and capability of all EPM tools. We can have an integrated environment and decrease the close time from two days to one hour.

What is most valuable?

It's the best tool for data integration. It can do anything you want, but the only downside is that you need to know what you are doing. You can take 10 times longer to do the same thing if you don't know how to use the tool.

You have to know how to change the KM, how to use the dynamic coding, how to create dynamic models, and so on. In a lot of places, I see people using ODI wrongly, but the good thing about the tool is that isn't hard to fix common mistakes. With this you can improve performance, and in some cases, more than 10 times.

What needs improvement?

Right now, we have two very different GUIs - 11g and 12c. 11g is faster to develop than 12c as it takes more steps to do exactly the same as 11g, but you have a lot of things that you need to do yourself.

12c implemented some things for which you have to use some specialized code automatically, like parallel data load, but it is slower to develop. For me, the best thing would be to merge the GUI from 11g into the capabilities of 12c.

For how long have I used the solution?

More than 10 years.

What do I think about the stability of the solution?

There were issues mainly because of a Java memory leak.

What do I think about the scalability of the solution?

We have had no issues with scaling it for our needs.

How are customer service and technical support?

The technical support for EPM is bad. I don't remember anytime that the service support helped me with something. The problem is bigger when you have an environment with more than one product like Hyperion Planning and ODI.

This happens because the products have different owners within Oracle and then different supports, and because of this, if you open a trouble ticket of loading data to planning and you say the words ODI, you'll be pushed around the two separate support teams indefinitely, even if your company has an Oracle support director just for you.

How was the initial setup?

The bigger the environment, the bigger the challenge is you need to face. Maybe one day Oracle will integrate all their tools. It'll be easier, and the good thing is that I saw a lot of improvements over the years.

What's my experience with pricing, setup cost, and licensing?

All tools are expensive, but I think ODI is the most expensive since it depends on your sources and target databases. I think the best way to go is by doing packages and try to include free tools (if you buy Planning you have an ODI for BI licenses for free) or try to get discounts from your Oracle supplier. It's always good to explore what could happen if you get another tool or hardware together. Sometimes, you get more for less than if you get just one tool. Just be careful to not buy things that you won't use.

Which other solutions did I evaluate?

I'm a consultant and my only evaluation was on the database. I decided on Oracle because of the database and during my career, their other tools are starting to come naturally.

What other advice do I have?

Because Oracle products are development frameworks, your final results are as good as the people that implemented it. Make sure that your implementation team is the best it could be, at least for the first implementation. If something is implemented incorrectly at the start, it'll cost you a lot more to fix than to build a new system from scratch. Sometimes it can be so badly designed that it is impossible to fix.

I've been working on implementations for 21 years and I have seen bad implementations everywhere. In fact, I have seen the same tools implemented in the same team by two different people, with one being a success and the other a failure. In the same company, one department says that the tool does not work for them and another says that the tool is the best. The only difference was the implementer. Make sure you get a good team to implement it. The tool has its flaws but most of time (99%) it is the implementer's fault that you have a bad or slow model.

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. The reviewer's company has a business relationship with this vendor other than being a customer: We're platinum partners.
Learn what your peers think about Oracle Data Integrator (ODI). Get advice and tips from experienced pros sharing their opinions. Updated: January 2022.
564,599 professionals have used our research since 2012.
Applications Support Manager at a marketing services firm with 1,001-5,000 employees
Real User
Top 20
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: I am a real user, and this review is based on my own experience and opinions.
Flag as inappropriate
Muhammad Arif Javed
Senior Manager Software Development at Techlogix
Real User
Top 5
Has a good declarative design and client-server architecture model
Pros and Cons
  • "All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
  • "There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."

What is our primary use case?

We have been using Oracle Data Integrator for populating Financial Services Data Warehouse. Data extraction is done into a staging area from different source systems and then this data is validated and certain quality checks have been performed here. We used Oracle Data Integrator data quality checks builtin capability to perform these different data quality checks. Then data is consolidated and transformed into the staging area and finally gets landed into the data warehouse. I also used this for generating data hand-offs for other applications.

How has it helped my organization?

Oracle Data Integrator offers a declarative style ETL development, where you mainly use pre-built knowledge modules for doing integration tasks. As a developer, you don't need to focus on how part of the integration, you only focus on what to do. You just need to configure certain components as per your requirements and underlying execution plan and code is generated for you. For every technology there are knowledge modules available, the best optimal code is generated which eventually gets executed on database level. Our developers created best performing ETLs with very little effort leveraging this feature.

What is most valuable?

There are number of valuable features in this tool: 

  • Declarative design 
  • Client-server architecture model.
  • Very good user access model
  • Pre-built user profiles defined that give you control for access management
  • Very good logging and execution logs feature which gives you complete detail of executions and you can query these in a different manner.

All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner. 

What needs improvement?

There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue. 

Error descriptions should be easy and specific to actual problems rather than generic lengthy descriptions. Also, another main feature that should be readily available is that there should be a source component available that can extract data from a source based on the custom query rather than giving a source data store only in the mapping. 

For how long have I used the solution?

I have been using Oracle Data Integrator for five years. 

What do I think about the stability of the solution?

Good.

What do I think about the scalability of the solution?

It's very good.

How are customer service and technical support?

Whenever we needed Oracle Technical Support, we're able to get it in timely fashion and most of the time has been good to help in resolving the problems.

Which solution did I use previously and why did I switch?

I didn't switch any tool. I'm a professional developer and my tool selection is based on client requirements. I've used both SSIS and ODI for different clients.

How was the initial setup?

The initial setup is a bit complex as it needs some repo schema setup and agent setup.

What about the implementation team?

We did it at our own.

What was our ROI?

Excellent.

What's my experience with pricing, setup cost, and licensing?

ODI has bit on higher end in setup and pricing but it has more power as well. So it depends on your use. 

Which other solutions did I evaluate?

No, my selection was based on client's choice.

What other advice do I have?

I think different tools have their own pros and cons, so it all depends on your overall needs.

Which deployment model are you using for this solution?

On-premises
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Rodrigo Radtke De Souza
Solutions Architect at a tech consulting company with 51-200 employees
Consultant
Top 10
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 11 version is very stable. It can manage several parallel executions/large volumes without much trouble. I do see some complains about ODI 12 version, but I cannot share any opinion since I’m not currently working with it.

What do I think about the scalability of the solution?

ODI scales very well.

How are customer service and technical 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.
Mohamed Ahmed Fouad
Banking Excellence - Predictive Analysis at a financial services firm with 11-50 employees
Real User
Top 20
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: I am a real user, and this review is based on my own experience and opinions.
Product Categories
Data Integration Tools
Buyer's Guide
Download our free Oracle Data Integrator (ODI) Report and get advice and tips from experienced pros sharing their opinions.