Creating ODI packages
I am currently working on a data warehouse project where I often have to load Tier 1 and Tier 2 tables from source. Layer 1 is a copy of the original data plus some technical fields, while Layer 2 handles foreign keys and does some minor transformations.
The process is carried out as follows:
- Create DDL scripts to create tables in L1 and L2
- Use ODI (Oracle Data Integrator) to define interfaces that define transformations from one level to another.
This is a fairly repetitive task in which the transformations remain roughly the same.
I was wondering if there is a way to generate ODI + interfaces + variables packages on the odi agent from a scripting language so that I can automate most of this part of the time.
ODI Version: ODI_11.1.1.7.0_GENERIC Platform: Windows 7
Thank you in advance
source to share
Using the ODI SDK, it is indeed possible to do almost any task that you can do in ODI Studio: http://docs.oracle.com/cd/E29542_01/apirefs.1111/e17060/toc.htm . This Java API can also be used in Groovy scripts executed directly from ODI Studio (Tools → Groovy → New Script). Groovy is a programming language for the JVM, it uses a syntax similar to that of Java, with some shortcuts, and is dynamically compiled. With a few exceptions, Java code can be used in Groovy.
Michael Rainey made a nice presentation to introduce the ODI SDK, Groovy and some use cases. Here are the slides: https://s3.amazonaws.com/rmc_docs/biforum2013_slides/odi_mclass_6_sdk_groovy.pdfI guess this complete example by the same author might be of interest to you, as it adds multiple columns to its Foundation level tables (equivalent to your level 1 in Oracle Information Management Reference Architecture): http://www.rittmanmead.com/2012 / 05 / oracle-data-integrator-11g-groovy-add-columns-to-a-datastore /
After you grasp the concepts, the Oracle Data Integrator team posted a nice script to automate creation on their blog a few years ago. I think it was tested on 11.1.1.5, so it may need adaptation, but this is a good starting point: https://blogs.oracle.com/dataintegration/entry/interface_builder_accelerator
One of the limitations of the SDK is that there is no way to leverage ODI capabilities for versions.
source to share