Database Types

You can define the database type, such as MySQL. A database type consists of the following properties.

Property

Description

Name

The name identifying the database type.

JDBC driver

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

Connection URL template

A 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.

Database Type

Select the database type from the list. See System requirements in the Kofax Kapow Installation Guide for supported databases.

The database types are also sent to Design Studio clients.

To add a new database type, select the database type category, and click Add Database Type. Alternatively, right-click the Database Type category and select Add Database Type.

Note Kapow does not support adding new database types. However, you can modify the database types in order to add a type that defines a database server running on a non-standard port or requiring a different authentication method.