Connection Info Context variables are used as a parameter in the DBQuery function, when extracting information from the databasefor mapping source elements, functions or constants to target elements. They are declared and used globally for all target elements. Once declared, they're available to be used in a Process Flow too.
To use a global variable in a mapping activity, you need to map it to a target element. This will successfully execute the global variable when you execute the mapping activity in the process flow.
Steps to declare a Connection Info Context Variable
You can edit or delete a Connection Info variable from the Parameters Panel itself.- Ensure that the source the source and destination layout are loaded and loaded and all their elements are listed under their respective nodes.
- Click Add Parameters icon from Parameter panel In the Parameters panel, click Add Parameters icon and select Variables option.
- In the Create New Variable window is displayed. Select Connection , select Context Variables option.
- Click In the Name text field and field, enter the name of the Connection Info variable you want to createthe Context variable.
- The Connection Info variable accepts a DBInfo as its value. Thus, the Connection Variable Value field displays a list of existing DBInfo Names and their IDs.
Select the DBInfo name that you want to assign for the Connection Info variable.
- Click the Save button to save the Connection Info variable. This Connection Info variable is added to the list of existing variables in the Connection Variable Name field. It is also displayed under Variables > Connection in the Parameters Panel.
- In the Context Variable Value area, enter a value for the Context variable.
- Click Save.
You'll see the Context variable added to the Parameters panel as shown below.
| Panel | ||||
|---|---|---|---|---|
| ||||
What's newBest practicesTraining guidesFrequently asked questionsAdeptia Connect APIsAdeptia security report |