Forum Stats

  • 3,827,551 Users
  • 2,260,791 Discussions


How to set values for multiple variables from a store procedure

1012933 Member Posts: 1
edited Jun 5, 2013 6:08AM in Data Integrator
Hi all,

I'm facing a problem while using variables in ODI. I have a project with name SALES. I have 10 variables: V1, V2,....V10 and 10 packages to process data, these packages are using the variables. Each time I run one package I must set values for 10 variables ==> it wastes time. So, my questions is here:

How to set values for multiple variables and the values can be retrieved from a store procedure in database?

My idea:
I have a table with 10 columns and they will be store values for 10 variables
I develop a store procedure to read values of 10 columns
Set values for 10 variables, which are retrieved by the store procedure



  • Abhishek
    Abhishek Member Posts: 16
    You can get value into variable using a simple select sql line.
    Create a variable -> go to refreshing tab -> add sql code there with proper schema.

    Use variable in package in refresh variable mode.

    You are done . Enjoy.
This discussion has been closed.