ODI - Groovy JDBC connection

--

Groovy is now Officially supported in ODI 11.1.1.5.
It provides another option to a team whose developers are comfortable using Groovy and also opens new ways to integrate,code which adds more flexibility.
Now Groovy can be used in Knowledge Modules and ODI Procedures.

In this post we will look at how to make JDBC connections using Groovy in ODI.
It's always nice to know which version of groovy is uesd in ODI (documentation does not reflects).


Snippet of code to connect using Groovy to different databases in ODI using ODI Procedure (No rocket science).

Command on Source:

Command on Target:

Executing the procedure on a standalone agent will print the output:

Throwing an exception to print the Groovy version on the operators output -

Executing the procedure -



 

The Groovy version is 1.7.4.

--