Versions Compared

Old Version 1

changes.mady.by.user Akash Kumar Jaiswal

Saved on

compared with

New Version 2

changes.mady.by.user Akash Kumar Jaiswal

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Connection Info variables are used as a parameter in the DBQuery function, when extracting information from the database.

...

  1. Ensure that the source and target schemas are loaded and all their elements are listed under their respective nodes.
  2. Click the Global tab in the Mapping Graph Area. All tabs of the Global tab are displayed.

  3. Click the Connection Info tab. The Connection Info Variable pane is displayed in the Mapping Graph Area (see Figure 546).

    Image Removed

    Figure 546: Connection Info Variable Pane

  4. Click the Connection Variable Add Parameters icon from Parameter panel and select Variables option.

    Image Added

  5. Create New Variable window is displayed. Select Connection Variables option.

    Image Added

  6. Click the Name text field and enter the name of the Connection Info variable you want to create (e.g. Var1). Press the Tab orEnter key. This takes the control to the Connection Variable Value field.. 
  7. The Connection Info variable accepts a DBInfo as its value. Thus, the Connection Variable Value field displays a list of existing DBInfo Names and theirtheir IDs.

  8. Select the DBInfo name that you want to assign for the Connection Info variable (see Figure 547).

    Image Removed

    Figure 547: Enter Connection Variable Value

     

    You can click Synchronize to reload the DBInfo list.

  9. Click the Save Connection Variable ( Image Removed ) 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 Connection Info in under Variables > Connection in the Parameters Panel. If you shift the focus to another node, or click any of the Mapping Rules, Textual Rules, Local Variables, Properties, XSL or Debugger tabs, without saving the Connection Info variable, an alert  message is displayed (refer to Figure 522).
  10. Click No to save the Connection Info variable and shift the focus to the other object. If you click Yes, then the defined Connection Info variable is cleared and the focus is shifted to the other object.

...

  1.   
    • 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. For details, refer to the  Managing a Global Variable from Parameter Panel section.