Oracle Data Integrator (ODI) Reviews

ODI is used for reports. We feed the flat files into the solution to use them in reports. I create reports on the tables that are being loaded into the target tables.

The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module.

ODI could improve the ease of use. There is a steep learning curve to use the solution.

I have been using Oracle Data Integrator (ODI) for approximately two years.

ODI is stable and it's good to work with.

As the version of ODI is updated the solution scales. The scalability is based on the versions that are being provided for the product.

We have three to four people using the solution in my company.

I rate the technical support from ODI a four out of five.

Positive

I previously used Informatica and we switched because it did not support Oracle BI applications. If we stayed with Informatica we would have to use third-party tools.

The initial setup of ODI is not simple. We need to install Oracle BI applications to use ODI to access the tables that are built in or provided by Oracle. It is an on-premise system and it would help to make the process easier.

We use a consultant for the implementation of ODI.

We are having different environments for ODI and depending on many factors in those environments will dictate how many people we need. We have the development, testing, and production environment. We will need people for each of these areas. If it is a small firm or a mid-sized firm, and if the consultant has good knowledge, then they can manage the three environments, or else the work can be distributed. 

For the deployment, we use eight people. If the project is a small size project with fewer tables, then it can be even done with three people.

I recommend this solution to others. It helps to take training to use the solution.

I rate ODI an eight out of ten.

Our ODI usage is expensive and is mainly for the extraction transformation and loading (ETL) of data from multiple sources to a data warehouse.

The most valuable feature of ODI is the to use of the whole ETL to create a data lake.

We have been using Oracle Data Integrator (ODI) for approximately five years.

At this point in time, we are not satisfied with the stability. However, this is not because of the solution, but because of the deployment which was done in 2017, and the maintenance and upgrades that needed to be done, which were not done over time.

ODI is a scalability solution as long as you are keeping it up to date with all the upgrades and patching, you can scale it a lot.

We have approximately five engineers who direct users of ODI, and there is a great number who use the solution.

We used technical support and they are good.

We did not use a tool prior to ODI.

The initial setup of ODI was straightforward. The full implementation took us approximately two months because of our architecture, it was not the fault of the tool.

We used a third party to do the implementation of ODI.

We have approximately five engineers that do the maintenance and support the solution.

There is a standard license to use the solution but there are other costs in addition, such as hardware and operating system.

I rate the price of ODI a three out of ten.

My advice to other people implementing this solution would be it is good as long as the context of the systems that they are using it. For example, if they are using a lot of Oracle technologies, then it makes sense to have ODI, otherwise, there are other tools that could make more sense.

I rate ODI a seven out of ten.

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.

I have been using this solution for around seven years.

It is pretty good.

It is scalable.

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.

We have seen a return on investment with this product.

Everything is good, and I would rate it an eight out of ten.

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.

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.

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.

I have been using Oracle Data Integrator (ODI) for approximately two years.

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.

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.

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.

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.

The initial setup is complex, it took us three months.

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. 

The solution is expensive because of the model they use. The cost is for the license and for support.

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.

We use the solution for getting transactions and BI reports for stakeholders.

Stability could be improved because some operators have issues.

I have been using Oracle Data Integrator for two years and a half.

We used the solution, and we didn't have any problems with that.

I rate the solution’s stability a six out of ten.

We didn't have a problem with the tool’s scalability. There are six to seven people using this tool in our organization. We don't have plans to increase the usage. It responds to all our problems.

We didn’t contact the customer support team. We figure it out by ourselves.

The initial setup is easy. It took about two and a half months to deploy.

We set up the tool in an environment because of data sensitivity.

Overall, I rate the solution a seven out of ten.

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.

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.

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.

I have been using Oracle Data Integrator (ODI) for approximately two years.

The stability of Oracle Data Integrator is very good.

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.

I have been satisfied with the technical support.

I have used other solutions previously.

ODI has one of the easiest implementations out of all the others for a database.

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.

An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types.

ODI is a proven product with high performance in large-scale data processing.

ODI comes included when buying the cloud version of the Oracle database license.

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.

We primarily use the solution for digital health and sometimes automation tasks.

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.

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.

I've been dealing with the solution for around four years at this point.

The stability of the solution is pretty good. It doesn't crash or freeze on us. We don't have any bugs or glitches. 

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.

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.

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.

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.

We did not need the help of a vendor or integrator. We did do everything on our own.

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.

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.