Using ODI variables to generate Unique URL of a data server during package run time

When using variables in the JDBC url the following method is recommended


The data server connection is established at the beginning of the session execution
for example a package




This requires that the variables used in an url and physical schema must be resolved in a different session so that session can use it values.




At the beginning of the session execution, ODI will retrieve the variable's values stored in snp_var_data which from the variable is last refreshed .


This could be from when the package ran last time.


That's why it feels like its always loading previous server data.


Therefore the following is the good method to do this


1. create a child package with the following steps"


step 1 : declare v_loop variable


step 2: declare v_src_physical schema


step 3: declare v_dataserver


step 4: declare v_tar_physical_schema


step 5: i_interface


step 6: declare v_check


Generate a scenario for the above package , this scenario is called in the next package a a child package


2. Create another package with the following steps


step 1 : set v_loop variable


step 2: refresh v_src_physical schema


step 3: refresh v_dataserver


step 4: refresh v_tar_physical schema


step 5: Execution of above child scenaria


step 6: refresch v_check


step 7: evaluate v_check


step 8: set v_loop


step 9: back to refresh v_src_physical schema step