Welcome to Kofax RPA > Management Console > Management Console Configuration and User Interface > Settings > Database types

Database types

In this section, you can define one of the following database types: Apache Derby (Development Database), Sybase Adaptive Server, PostgreSQL, Oracle, MySQL, Microsoft SQL Server, and IBM DB2.

To edit an existing database type, select the respective tab. To create a new type, on the New type tab, specify the following properties and click Save. For an example, see Add database Microsoft SQL Server database type.

Property

Description

Name

Name identifying the database type.

JDBC driver

JDBC driver class of the driver (the driver must be uploaded under Database drivers).

Connection URL template

Template string defining how connection URLs for databases of the given type look. Possible variables to use in the template string are the following:

${ServerName}

Defines the server name (host) of the database server.

${Schema}

Defines the schema (or database/catalog depending on database vendor) of the database.

An example of a connection string template is jdbc:mysql://${ServerName}/${Schema}. This string defines the connection string for a MySQL database running on the default port (no port is specified), on the server given by ${ServerName} and using the schema given by ${Schema}. The variables are given values when databases of the given type are created (see the cluster databases section).

SQL flavor

Select the database type from the list.

For more information on supported databases, see the Kofax RPA Technical Specifications document on the Kofax RPA 11.2.0 documentation site.

The database types are also sent to Design Studio clients.

Note Kofax RPA does not support adding other database types than specified in the "SQL flavor" list. However, you can modify the database types to add a type that defines a database server running on a non-standard port or requiring a different authentication method.