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 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.
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
. 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.
-
On the
Add Database.
window, select
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.
-
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
-
- Click Test.
- Click OK.