Connection Info variables are used as a parameter in the DBQuery function, when extracting information from the database.
Steps to declare a Connection Info Variable
- Ensure that the source and destination layout are loaded and all their elements are listed under their respective nodes.
- Click Add Parameters icon from Parameter panel and select Variables option.
- Create New Variable window is displayed. Select Connection Variables option.
- Click the Name text field and enter the name of the Connection Info variable you want to create.
- 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.
- You can rearrange the Connection Info variables by dragging it up or down in the list.
- You can edit or delete a Connection Info variable from the Parameters Panel itself.
You may be interested in...