Connecting to MySQL

This section describes connection configuration details for DataVeil license type MySQL.

DataVeil uses JDBC for connectivity.
 

 

 

Database Type

This must be MySQL for correct operation. This value is set when the Connection definition is created. After it has been created the value cannot be changed directly. This is why the field is disabled.

If there is a reason why this value must be changed, such as because the Connection definition was created using the wrong value by mistake, then the Migrate Masks function can be used to move to a new Connection definition.
 

Database Name

The name of the MySQL database.
 

Hostname or IP

This can be a server name, an IP address or blank.

If the database is on the same computer where DataVeil is running then this field can be left blank.
  

Port

The TCP port where the connection shall be attempted. If left blank then the MySQL default port shall be attempted.
  

Use JDBC Connection String

When this option is selected DataVeil shall use the user-specified JDBC connection string to establish connections instead of using the other connection parameters on the form.

The only exceptions are the Username and Password fields. Although it is possible to specify username and password details in a JDBC connection string it is strongly recommended that you do not include these in the JDBC string. This is because they will be exposed as plain text and that presents a security risk. Instead, the username and password details should be specified in the corresponding Username and Password fields and omitted from the JDBC string. DataVeil manages the Password field securely and encrypts it whenever saved to a project file.
 

Other Parameters

Other execution parameters that apply to this connection, such as masking batch sizes and the maximum number of parallel JDBC connections (threads), can be specified in Execution Settings.

 

JDBC No Suitable Driver Found Error

If you experience a "No suitable driver error found", as shown in the GUI error dialog below, then it means that the MySQL JDBC driver has not been installed.

DataVeil is unable to bundle the MySQL JDBC driver due to licensing restrictions of MySQL. However, the end user (you), is able to freely download and install the driver. Please follow the Installation instructions for MySQL JDBC Driver.