For our current client, we didn't evaluate other solutions apart from Oracle Data Integrator (ODI), but for other clients, we evaluated Informatica and Talend. Pricing was a factor in why our clients went with Oracle Data Integrator (ODI) because Informatica has a much higher pricing than Oracle Data Integrator (ODI).

We evaluated Informatica and Microsoft SSIS.

We also looked at Informatica Power Center, AbInitio, Business Objects Data Integrator (BODI), and SQL Server Integration Services (SSIS).

MS SQL Server Integration Services (SSIS) was considered. However, the internally-preferred vendor company was Oracle. The availability of a license and expertise in product usage helped in the decision-making process.

Since the product is expensive, we are exploring other tools like Azure Data Factory to reduce costs.

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.

As far as why consider Oracle Data Integrator, I think the big thing is the ability to consolidate all of your ETL into one place. Whether it's an Oracle to Oracle, source to target load, or even Oracle to Hadoop, or anything in between. SQL Server, MySQL, XML. ODI can basically talk to all of those different technologies. From a consolidation of all of your data warehouse or your data integration, if you will. And also, just use the same approach for mapping and creating processes for all of those different types of solutions. You have everything logically defined. And so when you're developing, it actually doesn't look any different than an Oracle source, and target doesn't look any different than a Hadoop source and target.

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

We looked at FDMEE.

We didn't actually look at anyone else. We looked at different Oracle partners who provided this software, but the product was Oracle from the start.

I tried many integration tools, both Oracle and other vendors. I think that ODI is one of the most complete and open solutions, since it can work with almost any technology and it gives you the ability to develop the same solution in a wide variety of ways depending on the one you prefer.

ODI was the only option we considered.

When I came on board, I believe we had already purchased the licensing for this. I got to be the lucky person to implement it.

We considered moving forward with Oracle Warehouse Builder, but dismissed OWB because it was running out of support.

We also considered Informatica PowerCenter, but it seemed to be even more expensive an option than ODI. With ODI, we could still use some of the present Oracle skills (mapping design), so the learning curve seemed less steep compared to Informatica.

I tried PowerCenter a few months before Oracle Data Integrator. I wanted to try the Oracle ETL to compare it with the tools of PowerCenter.

We evaluated SQL Server prior to choosing this solution.

Basically the ETL tools is determined by the database.

We looked at alternatives, but they could not provide us with the complete set of features.

No.

I didn't look at any other similar products.