Database mappings

The "Database mappings" section lists database mappings of the selected project. You can link your robot to different databases in a cluster by using mappings, and you can create new mappings in this section. After you install Kofax RPA, a default database mapping "objectdb" is added to the default project, which is pointing to the Production cluster default development database.

For more information on database mappings, see Map Databases in the Design Studio chapter.

When creating a database mapping, note the following:

  • You cannot have database mappings with the same name in one project.

  • You can use space, parentheses, and hyphens for database mapping names. For example, "Development Database (MySQL)" is a valid database mapping name.

At the top of the "Database mappings" section, in the Projects drop-down list, you can select the project with databases to display. You can change the way the information for each database mapping is presented as follows:

  • Filter the list of database mappings in the table by applying filters in the Filter text field. See Filtering for more information.
  • Select the table columns to display for a database mapping using the menu icon on the right.
  • Refresh the displayed information by clicking the refresh icon on the right.
  • Reset the custom column settings by clicking the reset icon on the right.
  • Select the number of items to display per page and navigate among pages by using the navigation menu in the bottom right corner.

By default, the following information is displayed for each database mapping.

Column

Description

Name

Database mapping name.

Project name

The name of the project that the mapping is assigned to (useful when viewing all projects).

Database

Name of the database that the mapping is used for.

Cluster

Name of the cluster that the database mapping is related to.

Create New Database Mapping

  1. To create a new database mapping, click the plus sign in the upper left corner.

    The "Add database mapping" dialog box appears.

  2. Specify a project to assign the mapping to.

  3. Select a cluster and a database to map the database mapping to.

  4. Click Save.

Additionally, you can perform the following actions on database mappings from the context menu:

  • Edit: Contains the same fields as the "Add database mapping" dialog box.

To remove a database mapping from the Management Console, select it in the table and click the bin icon in the upper left corner. You are prompted to confirm the deletion.

If you delete the last mapping of a database, this database will not be available in Design Studio even if a cluster is selected to provide Design Studio with shared databases.