Databases

You can 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). Database types are defined 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 also available in Design Studio.

See Database Connections for more information on database properties.

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 Management Console under Settings > Database drivers > Upload driver JAR.

By default, you can 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). This setting can be changed in RoboServer Settings > Management Console > JDBC Driver Upload. Important: Start the RoboServer Setting as the user running the Management Console. After making changes in the RoboServer Settings, restart Management Console for the changes to take effect.

Actions

  • The New development database button creates a database connection to the pre-installed Kofax RPA development database.

  • The New database button creates a new database connection.

New Database

  1. On the Databases tab in the cluster settings, select New database.
  2. Complete the following database details.
    • Name

    • Host

    • Port

    • Schema

      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.

    • Type

    • User name

    • Password

    • Max active connections

    • Max idle connections

  3. Click OK.