Local Databases

Use the Local Databases tab to create a database in Design Studio. Note that databases created in Design Studio are only available in Design Studio.

To make the database available both in Design Studio and on the server, the databases must be configured in the Management Console.

A list of created connections is shown in the left pane. You can create new connections, remove connections, or change their order using the buttons below the list. The currently selected connection is configured in the right side of the "Local Databases" window. The field name, host, type, schema, username and password are mandatory and must be specified.

The different database types are defined in the Management Console and automatically distributed to Design Studio at startup. New database types must be created in the Management Console.

Option

Required

Description

Name

Yes

A name for uniquely identifying the database in Kofax RPA. The name is used for internally referencing the database and it may only contain alphanumeric characters and underscores.

Host

Yes

The host name of the database server. This can be an IP address, or the fully qualified domain name, such as myhost.kofax.com.

Type

Yes

The type of database, such as Oracle. The different types of databases are configured in Management Console and provided automatically at Design Studio startup.

Schema

Yes

The name of the database schema (or catalog).

User name

Yes

The user name for the database.

Password

Yes

The password for the database.

Max active connections

Yes

The maximum number of concurrent connections to the database that Kofax RPA (RoboServer or Design Studio) create. The connections are managed by a connection pool, which means that existing connection is reused before creating new connections.

Max idle connections

Yes

The maximum number of idle connections allowed. If more connections are created due to a heavy load, they are closed automatically when no longer needed.

To test the current connection, click Test Connection.

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

Connecting to Oracle: If you are using an Oracle database, In the Username field, you must enter a username and a role. For example, if the username is "sys" and the role is "sysdba," you should enter "sys as sysdba" in the Username field.