Connecting to MySQL
This section describes connection configuration details for DataVeil license type MySQL.
DataVeil uses JDBC for connectivity.
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.
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.
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 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.