Jython script - ODI variable

There is no direct way to assign a value to the ODI variable through a jython script.


This is performed by using JDBC connections to the appropriate database inserting/updating the table field which is used to store the value.


Note : the database table used to store the values is an application based table but not an internal repository table


The value inserted into the table may then be accessed in a package step made up of an ODI variable set up in the Refresh mode.