› Management Console › Settings › Database drivers

Database drivers

Use the Settings > 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, refer to the Tungsten RPA Installation Guide.

  • For detailed information about configuring databases and drivers, refer to the Tungsten RPA Administrator's 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. Refer to the Apache Derby website for Derby JDBC driver download information. We recommend using MySQL or another enterprise-class database with your Enterprise Management Console.

Oracle JDBC drivers

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 a Management Console. For details, refer to "Configure Management Console before running robots" in the Tungsten RPA Installation Guide.

Settings for larger files

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.

Add new driver

Use the New driver table to add a new database driver.

  1. In the File to upload box, use the Browse file button to find and select a database driver.

    If you are using RPA in a cloud implementation, only approved drivers are allowed to be uploaded. If you select an approved file using the Browse file button, the upload will succeed. However, if you select a driver that is not approved, an error message appears when you try to upload the file.

  2. To automatically override the old driver with the new one, select the Override if exists checkbox.

  3. If using Tungsten RPA on the cloud, see Approved database drivers

  4. Click Upload driver JAR to upload the driver.

    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, change this behavior in the RoboServer Settings. For more information, refer to the "Embedded Management Console configuration" section in the Tungsten RPA Administrator's Guide.

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

Approved database drivers

This table lists approved drivers available for cloud implementations of RPA. This option for adding a driver provides a layer of security for cloud deployments and verifies the checksum expected for the JAR file.

Use the Approved database drivers table to review and select from approved drivers.

  1. From the SQL flavor column, choose a flavor.

  2. From the corresponding Driver versions list, choose a version.

Also, you can use an API call to get a list of the approved drivers.

Delete a driver

  1. From the Settings > Database drivers list of uploaded drivers, select the one you want to remove.

  2. Click Delete.