› Management Console › User interface › Settings › Database drivers

Database drivers

This topic is for users with the following roles: Administrator and Project Administrator.

Use the Database drivers option to upload database JDBC drivers and view a list of installed JDBC drivers. These drivers are required and based on the database types.

  • For detailed information about installing databases and drivers, see the Kofax RPA Installation Guide.

  • For detailed information about configuring databases and drivers, see the Kofax RPA Administrator's Guide.

Oracle JDBC drivers are supported when they are installed on the embedded Management Console, RoboServer, and Design Studio machines. Do not upload the Oracle JDBC driver to Management Console. For details, see "Configure Management Console before running robots" in the Kofax RPA Installation Guide.

Only one database driver of each type should be uploaded to the same Management Console. For example, having two different MySQL drivers at the same time in the same Management Console is not supported. If you upload multiple drivers of the same type, only the first driver is used.

As with database types, database drivers are sent to Design Studio clients. If you run your Management Console on a MySQL database, you need to provide Tomcat with the MySQL driver. This means that MySQL databases work when used in Management Console in the Log view or when testing the connection. However, for the MySQL databases to work on all RoboServers, you must upload the MySQL driver so that it can be sent to the RoboServers and Design Studio.

The Derby JDBC driver is not distributed with the Enterprise Management Console. See the Apache Derby website for Derby JDBC driver download information. We recommend using MySQL or another enterprise-class database with your Enterprise Management Console.

Hint

On certain database types, you might need to modify variable settings to store larger files.

Example: on MySQL databases, you might need to increase the value of the max_allowed_packet variable, which in many installations is set to 1 MB (meaning that database drivers larger than 1 MB cannot be stored).

Consult the documentation for your database if you encounter problems when uploading drivers. To identify issues, review error messages and the Management Console log.

Security Note

By default, only an administrator is allowed to upload JDBC drivers while accessing Management Console from a local host. Without administrator access, the "Upload driver JAR" button is disabled.

  • If you are running Management Console in embedded mode, you can change this behavior in the RoboServer Settings. For more information, see the "Embedded Management Console Configuration" section in the Kofax RPA Administrator's Guide.

  • If you are running Management Console in Tomcat, see the "Security" section under "Tomcat Management Console" in the Kofax RPA Administrator's Guide.