In a previous post, Uli Bethke asked if it would be possible to leverage ODI Tools using Groovy.

It turns out that yes, you can do so by combining Groovy and the SDK: dynamically build a package that contains the tools, and execute the code – all in one shot.

The key elements in the code are:

  • Create an empty package
  • Add a step to the package and name that step 
  • Add code for that step
  • Generate a scenario from the package
  • Execute the scenario

You can find a procedure (generated with ODI 11.1.15) with the code here.

The text of the code is available here if you ever have issues with the procedure.

(Note: some people seem to have a hard time when they click on the links to view the procedure or the code. This seems to be browser dependent. In that case do a “right-click” on the link and select “save as…” to make a local copy)