by AVIO Consulting | Sep 18, 2013 | ODI, Oracle
In my previous blog I demonstrated how ODI Scenarios can be exported with one click using ODI’s Toolbox features. In this blog, I will show how to do the same for ODI Scenario imports. Just like the manual exports from ODI Studio, you always have the option to...
by AVIO Consulting | Aug 21, 2013 | ODI, Oracle
It is a common practice within ODI to export ODI Packages, Interfaces, Procedures, Variables, Scenarios, and other artifacts. You always have the option to go to ODI Studio and manually right click on each artifact and click export, but it can get pretty hairy and...
by AVIO Consulting | Sep 25, 2012 | ODI, Oracle
It is a common scenario within ODI to want to know the results of the execution of a package or interface (aka ELT) and execute additional logic based on the initial result. For instance, you might want to execute interface X only if there were no inserts made into...
by AVIO Consulting | Jan 9, 2012 | ODI
In my previous blog, I showed how to do an ELT from Oracle DB to XML in ODI. Every ELT uses a Loading Knowledge Module (LKM), which describes how the data is loaded from one system to another, and an Integration Knowledge Module (IKM), which describes how the data is...
by AVIO Consulting | Sep 23, 2011 | ODI
Oracle Data Integrator (ODI) is Oracle’s data integration platform engineered to provide fast and easy data transformation and data integration processes, through E-LT (Extract – Load Transform) mechanism, between different technologies. For example,...