Databases

When a Robot accesses a database with a database step, it uses a name for the database. This is the mapping that the database step uses when a Robot is called from the Basic Engine Robot.

This approach of passing database mappings as input allows easy reuse of robots, because they are not bound to a single database, and they can use different databases, depending on which database mappings are specified as input to those databases.

To use more than one database in a robot, specify multiple database names in the Databases area of the Robot definition pane, then pass the corresponding number of actual database mappings.

Database names follow the same naming conventions as variables and input parameters, but the names can overlap with variable and input parameter names. The actual database mappings specified in the Call Robot step may or may not be different, but the database names inside the Robot must be different.

If a Robot is called from a Basic Engine Robot, the database mapping is provided by the Basic Engine Robot's Call Robot step. Different calls may pass different mappings to the same robot if there are several calls to the same robot. If a Robot is called from Management Console in standalone mode, the Project Database defined in the robot is the one used.

To manage database names for a Robot:

See also the following related topics:

  • To configure databases in Management Console, use the Databases tab.

  • To map databases, see Database mappings.

  • To view a list of Database steps available for use in a Robot, see Database steps.

Add a database definition

Use the Databases area in the Robot definition pane to define databases. See Edit Robot for navigation and context-menu options.

  1. If the Device pane is not expanded, click the down arrow, which changes to an up arrow.

  2. If no definitions exist, click the Add Database button or right-click the context menu to select Add Database.

  3. If definitions exist, use one of the following methods:

    • To add after existing entries, click the green plus sign.

    • To add between existing entries, select the preceding database, then select Add Below to insert the new one.

    • To add at the top of an existing list, place the pointer at the top and select the Add Database option from the context menu.

  4. Name the database and press Enter.

  5. If the Robot executes in standalone mode, click the Project Database down arrow to select the corresponding mapped database.

    If the field is empty, no databases are currently mapped. See Database mappings.

    After you define an available database in this field, it will be available in database steps. When executing these steps, the robot accesses the database through the actual mapping.

    If you change a database definition while inside a Query Database step, the editor resets the execution.

Delete a database definition

Use the Databases area in the Robot definition pane to delete databases. See Edit Robot for navigation and context-menu options.

In the Databases area, right-click the database definition and click Delete.

Deleting a database definition from a robot only removes the named database from the robot.