My company has around ten users of Oracle Data Integrator (ODI). A team of two to five people handles the deployment and maintenance of the solution.

The current client of my company has this plan of moving to the cloud, with the possibility of replacing the ETL tool altogether, which could mean that more data is coming up, so there may be a plan to increase the usage of Oracle Data Integrator (ODI).

My advice to others looking into implementing Oracle Data Integrator (ODI) is that if your database is on Oracle or SQL server, then Oracle Data Integrator (ODI) is a good tool to use.

My rating for Oracle Data Integrator (ODI) is seven out of ten.

View full review »

I give Oracle Data Integrator a ten out of ten.

We have around 25 users.

For environments with simple architecture, one person is sufficient for the maintenance of Oracle Data Integrator.

Oracle Data Integrator is well-suited for large organizations; however, it may present complex integrations when dealing with heterogeneous source systems and different types of source data, especially without a skilled staff capable of adopting a rational approach to ODI. One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value.

View full review »

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

I rate ODI an eight out of ten.

View full review »

I have a strong bias for Oracle Data Integrator. It is a fantastic tool with automation, dynamic coding, and scalability features. While it was great on-premise, Oracle has been slow to modernize it. However, they are now making efforts to improve its user experience and automation in the cloud. ODI is up-to-date with cloud-based solutions and supports various technologies and databases. It has a web-based interface and can be deployed in high-availability clusters.

ODI's Knowledge Modules are vital in integration projects. They help create mappings, manage transformations, and generate SQL for Oracle metadata. By automating tasks and combining code and graphical elements, they make integration smoother and more efficient.

ODI handles data quality and consistency by allowing you to create elements within the mapping to ensure quality. You can use dummy referencing and build data quality modules as needed. While it is not a click-and-go tool, it offers flexibility to tailor data quality measures to your specific needs, making it more like traditional data warehousing.

It is hard to say if ODI is the best option on the market. It was a top choice in the past, but with evolving technologies and diverse cloud options, its position may vary. While it is strong in Oracle's cloud, other platforms like Azure might offer different advantages. Additionally, solutions like Snowflake provide more comprehensive offerings than just data integration tools like ODI.

Overall, I would rate ODI as a nine out of ten. I would recommend it to others.

View full review »

I rate the overall solution a ten out of ten. I recommend it to anyone who has money. While the initial setup may require a modest investment, achieving optimal performance requires high proficiency in technical details. It's unsuitable for beginners and may even be challenging for those with medium-level experience.

View full review »

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.

View full review »

I rate this solution nine out of 10. 

View full review »

I would give ODI a rating of nine out of ten.

View full review »

The knowledge module is reusable but needs to be more relevant. First, we create an ODS and data structures, such as a Snowflake or a Star schema.

We move data as quickly as possible while ensuring that we do not reprocess already moved data. Therefore, we only handle data that is newly created or modified.

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

View full review »

My advice to anyone looking into using Oracle Data Integrator (ODI) is that it's easy if you have experience with Oracle technologies. Still, if your experience is with other technologies, you may find Oracle Data Integrator (ODI) challenging.

I'd rate Oracle Data Integrator (ODI) as seven out of ten because it's not as user-friendly as Informatica. It's not as cheap as Microsoft SSIS, but it's an Oracle product, and Oracle is well-known, so that you can search for information about Oracle products on Google. You can find support for Oracle products, so Oracle Data Integrator (ODI) is a seven for me.

I'm an Oracle customer.

View full review »

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.

View full review »

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.

View full review »

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.

View full review »

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.

View full review »

If you want a robust, flexible solution with no extra hardware that is easy to learn, then ODI is the right product for you. ODI is a tool, that can talk or learn how to talk, with any database or operating system in its own language. This is the power of ODI.

View full review »

The most important decision is the deployment strategy of the Master and Work Repositories that is the use of Single or Multiple Master Repositories. The company’s internal policy will determine which strategy can be used. However, the most common implementation I have seen is multiple master and work repositories. It performs and works as advertised.

View full review »

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

View full review »

People can use the tool if they don't have a limit on their budget. However, people generally have budget constraints. We need to understand the cost before we implement the product. Overall, I rate the solution a six out of ten.

View full review »

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.

View full review »

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

View full review »

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.

View full review »

The setup of the environment requires experts on site, but it is very worth it since at first for customers it can be quite complex. The vendor needs to enable the customer on a frequent basis during implementation, but the results are great.

View full review »

So I would rate ODI a nine. And that's really because, just looking across the other ETL tools, so I mentioned Informatica, there's a lot of other ones out there. I've seen what ODI does from a sort of a declarative design approach, and the push-down of work to the source and target. I've seen that replicated in other tools that have come out after Oracle Data Integrator. That's a big key.

It puts it kind of at the top, if you're going to look at a scale across all of the ETL tools. The other aspect to that rating is how they're integrating a lot of the big data technologies now. And it's a big deal from an Oracle standpoint, it's kind of how things are going. And it also just makes sense to, again, keep everything consolidated in one place. You already have an investment in ODI, it makes sense to try to drive some of your other big data type Hadoop loads or whatever it may be from that same place.

View full review »

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

View full review »

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.

View full review »

Plan your ODI infrastructure, especially where data is transformed to ensure you get the best balance between license costs and performance. Get your developers trained in best practices so that avoid unnecessary pit falls.

View full review »

I haven’t checkout out other solutions, so I don’t know where it scales, but from a developer’s standpoint, I’d give the product a seven or an eight. On infrastructure, I’d bring it down to a five.

View full review »

As with all software, read the installation guide cover to cover before you start.

View full review »

View full review »

You would have to evaluate what your key purpose is, and your existing, internal talent and experience. It's my belief that you should always try to have internal talent that is very confident, rather than having to always rely on consultants. If your talent has the experience in Infomatica – I don't think Infomatica is going anywhere – then it might be the best choice for you. I don’t think your office will fall apart. I think you have to evaluate which one will work for you.

We were new customers to data integration, so we decided to go with newer technology that had already come from the same source.

View full review »

You should use Oracle Data Integrator for your data transformation, or at the very least give it a try.

View full review »

It needs improvement with reusability.

View full review »

We learned some lessons, such as how to plan out the entire process, and so on. Oracle documentation is good. If you follow that, you should be fine.

When I’m choosing a vendor such as Oracle, support is the most important criteria.

View full review »

Always keep in mind that ODI offers a huge number of solutions to any task you are developing. There is not a best practice in solving a problem; being able to identify the best solution for your particular problem is up to you and it may also be difficult to identify. This does not mean that the solution you have in mind is not correct.
Always try to maintain an ordered environment, keeping only what you really need, and perhaps organizing the items in different projects or folders, or even different work repositories.

View full review »

I rate this solution eight out of 10. 

View full review »

Make sure you understand differences between ETL and ELT (ODI is the latter). Have a well-structured source data. And if you don't know anything about ODI, find someone who does before diving into your data-warehouse project. You can learn SSIS or Informatica yourself in days. This approach is not going to work for ODI.

View full review »

Good luck. I do think the training was beneficial but I know everybody doesn't have that as an option. If you do have the option to do some training, I think that could be a really big help; it helped me.

I don't feel like I am fully utilizing it but based on the things I do use, once you get the hang of it, it's a pretty cool data integration tool.

View full review »

Before implementing or designing, please have someone familiar with the product give their input. If your network is weak, the implementation may take more time.

View full review »

I would definitely recommend the ODI. The reason is that now Oracle, after a long time, has put its weight behind an ETL tool, which is ODI, and so Oracle is going to stand behind it, which means that it has a long life. That's another reason which we chose it. 

Informatica is a gold standard in ETL and, before ODI, Informatica used to be the king of the ETL. Now, because Oracle is putting its weight behind this tool we think that, long-term, ODI will have a better future. When we had the option of choosing an ETL tool, we went with ODI because we wanted to choose something for the long-term.

View full review »

• Think about the architecture in which you are going to use ODI very well.
• Think about where to place an agent and, if possible, put your ODI repository as close to this agent as possible.
• If possible, run your agent closer to the target than to the source.
• Try splitting up your repository into multiple work repositories for groups of developers of no more than five developers.

View full review »

ODI is a great ETL tool that you can use for implementation. It’s not complicated to use, and with knowledge of SQL and PLSQL you can customize it a lot.

View full review »

The Knowledge Module is the heart of this solution. If you have nicely written Knowledge Modules, then you will not have any performance issues. The language should be kept as common as possible and all in one solution. You can write in many different languages, but the maintenance will need a wide variety of knowledge in the future. This can be very tricky in the long term. Do not forget to clean temporary tables after each execution of ETL. Otherwise, the database will be full of unnecessary data.

View full review »

I definitely recommend using this for any data warehouse project.

View full review »

It's a great product.

View full review »

I rate this solution seven out of 10. 

View full review »

To benefit the most of Oracle Data Integrator it is important to assemble a team with the experience to make the project a success.

View full review »

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.

View full review »

This is a good solution if they are trying to move to fusion stack.

View full review »

It is a great tool to work with.

View full review »

The product may not be as evolved as Informatica, but still has a lot to offer in the Fusion Middleware Product Suite. Keeps all the promises of an ETL/ELT tool, but when it comes to Administration and maintenance the product still leaves a lot to be desired.

View full review »

Go ahead it is a very good, stable and reliable product. 

View full review »

 Oracle Data Integrator separates the declarative rules from the implementation details. It can run entirely within a Service Oriented Architecture. ODI is the most integrated ETL product for running data integration as a service, accessing web services and writing to web services as a target. View full review »