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 Tungsten 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.

Database mapping layout

At the top of the "Database mappings" section, in the Projects drop-down list, select a project with databases to display. Customize 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 database mapping

If a project is locked to a cluster, the Cluster list on the Add database mapping dialog is read-only.

Select Repository > Database mappings and click the plus sign.

The "Add database mapping" dialog box appears.
Type a Mapping name.
From the Project list, select a project to assign the mapping to.
From the Cluster list, select a cluster.

If the project you selected has Service Cluster enabled, the Cluster list will be read-only and automatically contain the name of the cluster configured in the project. See Projects.
From the Database list:
- If you selected a project that has Service Cluster enabled and the cluster (service or client) has only one database, then the Database is automatically selected
- If there is more than one database or the project does not have Service Cluster enabled, select a database.
Click Save.

Edit or delete a database mapping

If a project is locked to a cluster, the Cluster list on the Edit database mapping dialog is read-only.

Select Repository > Database mappings and click the context menu to select Edit.

The "Edit database mapping" dialog box appears and 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.