oracle - Generating ODI Packages -

oracle - Generating ODI Packages -

i working on info warehousing project need load tables layer 1 , layer 2 source. layer 1 re-create of source info plus technical fields , layer 2 handles foreign keys , minor transformations.

the process goes follows:

create ddl scripts create tables in l1 , l2 use odi (oracle info integrator) define interfaces define transformations 1 layer another.

this quite repetitive task transformations remain same.

i wondering if there way generate odi packages + interfaces + variables on th odi agent scripting language can automate largest part of time consuming part.

odi version: odi_11.1.1.7.0_generic platform: windows 7

thanks in advance

using odi sdk, indeed possible perform tasks can in odi studio : http://docs.oracle.com/cd/e29542_01/apirefs.1111/e17060/toc.htm. java api can used in groovy scripts executed straight odi studio (tools -> groovy -> new script). groovy programming language jvm, uses syntax similar java syntax shortcuts , it's dynamically compiled. few exceptions, java code can used in groovy.

michael rainey did nice presentation introduce odi sdk, groovy , utilize case. here slides : https://s3.amazonaws.com/rmc_docs/biforum2013_slides/odi_mclass_6_sdk_groovy.pdf

i guess finish illustration same author might interesting adds few columns tables of foundation layer (equivalent of layer 1 in oracle info management reference architecture) : http://www.rittmanmead.com/2012/05/oracle-data-integrator-11g-groovy-add-columns-to-a-datastore/

once understand concepts, oracle info integrator team posted nice script automate creation on blog few years back. think tested on 11.1.1.5 might need adapations nice starting point : https://blogs.oracle.com/dataintegration/entry/interface_builder_accelerator

one limitation sdk there nil utilize versioning capabilities of odi.

oracle scripting oracle11g data-warehouse oracle-data-integrator