Welcome to Kofax RPA > Management Console > Management Console Configuration and User Interface > Admin > RoboServers > Configure Cluster Settings > Cluster Databases

Cluster Databases

You can add or delete a database on the Databases menu of the Cluster Settings window.

The databases defined on a cluster are available to robots running on the cluster RoboServers via database mappings. A database uses a database type. Database types are defined in the Management Console settings.

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 also available in Design Studio. You can check database mappings on the Repository > Databases tab.

For users upgrading from pre 9.2.0 versions, it is possible to import databases from the legacy db.properties files in which databases were previously defined. This is done by selecting the Databases node in the tree, and clicking Import Databases From File. This will open a window in which the contents of the file can be pasted.

See Database Connections for more information on database properties.

To add a new database, you can either select the database category, and click Add Database, or right-click the database category and click Add.

Note To connect to a specific database, Kofax RPA needs the JDBC driver for this database type. The driver can be downloaded from the provider of the database. For example, sqljdbc4.jar that is used with a Microsoft SQL Server database can be downloaded from the Microsoft website. To provide the driver for Kofax RPA to use, upload it to the Management Console under Admin > Settings > Database Drivers > Upload Driver Jar.

By default, you can upload driver jars to the Management Console when you connect to it as administrator from localhost (otherwise, the Upload Driver Jar button is disabled). This setting can be changed in RoboServer Settings > Management Console > JDBC Driver Upload. Important: start RoboServer Setting as the user running the Management Console process. After making changes in the RoboServer Settings, restart the Management Console for the changes to take effect.

The Add Development Database button creates a database connection to the pre-installed Kofax RPA development database.

  1. On the Cluster Settings > Databases window, select Add Database.

    Optionally, you can right-click the database category and click Add.

    Note To import databases from legacy properties files, select the database category and click Import Databases From File.

    When the window appears, paste the contents of the file to import.

  2. Complete the following database details.

    • Name

    • Host

    • Schema

      Note If the concepts of "'schema" and "database" are equivalent (used interchangeably) in your database provider, specify the name of the schema in this field. Otherwise, specify the name of your database. In this case, the default schema is used.

    • Database Type

    • User name

    • Password

    • Max active connections

    • Max idle connections

  3. Click Test.
  4. Click OK.