Oracle Data Integrator (ODI) Previous Solutions

Alan Yves
Big Data / Business Intelligence / Datawarehousing at a tech services company with 51-200 employees
Besides ODI I have used SSIS and Power Center Informatica, both are similar and typical ETL tools, ODI up until 11g version had some differences, for example in ODI 11g we call the integration object as"Interface" wheres in Informatica it is called "Mappings" which has been implemented in the ODI 12c version. I still could see the Oracle solution being more robust and more logical, not to mention when it comes to customization, in ODI I felt more freedom to develop and customize the built-in code and designer objects such as the models, interfaces, for example, you can run updates in the repository tables"SNP's". Also, ODI handles high data volume more efficiently, of course, your database must be well tuned a good hardware helps a lot. The other difference is that you have more flexibility to manage the ODI metadata since everything is based on database . View full review »
Rodrigo Radtke De Souza
Solutions Architect at a tech consulting company with 51-200 employees
I've always worked with ODI for ETL development. View full review »
Muhammad Tahir
Assistant Manager - MIS Analyst at a logistics company with 5,001-10,000 employees
Before this solution, we were using SQL Server. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: November 2019.
379,605 professionals have used our research since 2012.
Dava Wang(汪燊)
Data engineer at realestate.pingan.com
Informatica and SSIS are also good ETL tools besides ODI. View full review »
Find out what your peers are saying about Oracle, Informatica, Microsoft and others in Data Integration Tools. Updated: November 2019.
379,605 professionals have used our research since 2012.
Sign Up with Email