› Management Console › Admin › RoboServers › Configure cluster settings › Databases

Databases

Add or delete a database on the Databases tab in the cluster settings.

  • The databases defined on a cluster are available to robots running on the cluster RoboServers via Repository > Database mappings. See Database mappings.

  • Define Database types in the Settings menu.

  • If a cluster is selected to provide Design Studio with shared databases and database mappings pointing to these databases exist in the repository, the databases that are defined on the cluster are available in Design Studio. See Database Connections for more information on database properties.

Drivers

  • To connect to a specific database, Tungsten RPA needs the JDBC driver for the database type. Download the driver from the database provider. For example, if using sqljdbc4.jar with a Microsoft SQL Server database, download it from the Microsoft website.

  • To provide the driver for Tungsten RPA to use, upload it to Management Console under Settings > Database drivers > Upload driver JAR.

  • By default, upload driver JAR files to Management Console when you connect to it as admin user from localhost (otherwise, the Upload Driver JAR button is disabled).

    Change the setting in RoboServer Settings > Management Console > JDBC Driver Upload.

Important: Start the RoboServer Settings as the user running the Management Console. After making changes in the RoboServer Settings, restart Management Console for the changes to take effect.

Create new development database

Use the New development database button to create a database connection to pre-installed Tungsten RPA development databases.

  1. Navigate to Admin > RoboServers, then from the Action column for a cluster, select the context menu and select Cluster settings.
  2. Select the Databases tab.
  3. Select New development database.
  4. Configure the database settings. See Local Databases.
  5. To test the current configuration, select Test.

    This action only tests the connection to the database. It does not test whether you have the proper permissions in the database.

  6. Select Save.

Create new database

Use the New database button to create a new database connection.

  1. Navigate to Admin > RoboServers, then from the Action column for a cluster, select the context menu and select Cluster settings.
  2. Select the Databases tab.
  3. Select New database.
  4. Configure the database settings. See Local Databases.
  5. To test the current configuration, select Test.

    This action only tests the connection to the database. It does not test whether you have the proper permissions in the database.

  6. Select OK.