MySQL connection properties

Property	Description
Connection Name	Name of the connection. Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -, Maximum length is 255 characters.
Description	Description of the connection. Maximum length is 4000 characters.
Type	Type of connection. Select MySQL from the list.
Runtime Environment	The name of the runtime environment where you want to run the tasks. Specify a Secure Agent, Hosted Agent, or serverless runtime environment.
User Name	User name for the database login. The user name can't contain a semicolon.
Password	Password for the database login. The password can't contain a semicolon.
Host	Name of the machine that hosts the database server. Note: The host name is auto populated with the port number if you have enabled the Secret Vault licenses in your Organization. You can remove the port number and enter the host name.
Port	Network port number used to connect to the database server. Default is 3306.
Database Name	Name of the MySQL database that you want to connect to. Note: The database name is case-sensitive. Maximum length is 64 characters. Database name can contain alphanumeric and underscore characters.
Code Page	The code page of the database server.
Metadata Advanced Connection Properties	Additional properties for the JDBC driver to fetch the metadata. Enter properties in the following format: <parameter name>=<parameter value> If you enter more than one property, separate each key-value pair with a semicolon. For example, enter the following property to configure the connection timeout when you test a connection: connectTimeout=<value_in_miliseconds> Note: The default connection timeout is 270000 miliseconds.
Runtime Advanced Connection Properties	Additional properties for the ODBC driver to run mappings. If you specify more than one property, separate each key-value pair with a semicolon.

SSL properties

When you enable SSL for the MySQL connection, you must configure the SSL properties for both the MySQL JDBC and ODBC drivers. Configure the required SSL properties for the JDBC driver, so that the Secure Agent can access metadata securely from MySQL. Also, configure the required SSL properties for the ODBC driver, so that the Secure Agent runs mappings to securely read from or write data to MySQL.

Connection property	Description
Use SSL	Determines whether the Secure Agent establishes a secure connection to the MySQL database. When you select this option and the database server supports SSL, the Secure Agent establishes an encrypted connection. If the MySQL database server cannot configure SSL, the connection either fails or the Secure Agent establishes an unencrypted connection depending on whether you enable or disable the Require SSL checkbox. If you do not select the Use SSL checkbox, the Secure Agent attempts to establish an unencrypted connection.
Verify Server Certificate	If you select Use SSL and select this option, the client validates the server certificate that is sent by the database server.
Require SSL	Applicable only if you select Use SSL. If you select the Require SSL checkbox, and the MySQL database supports SSL, the Secure Agent establishes an SSL connection. If you select the Require SSL checkbox, and the MySQL database cannot configure SSL, the Secure Agent attempts to establish an SSL connection but fails. If you clear the Require SSL checkbox, and the MySQL database cannot configure SSL, the Secure Agent establishes an unencrypted connection.
TLS Protocols	The TLS protocols used for the secure communication when you select Use SSL. You can select from the following protocols: - TLSv1 - TLSv1.1 - TLSv1.2 Default is TLSv1.2. The TLSv1 and TLSv1.1 protocols are not applicable.

Connection property	Description
Trust Certificate Key Store	The path and file name of the truststore file. You must prefix the file path with file colon (file:). For example, file:C:\SSL\mysql_new\truststore For the serverless runtime environment, specify the following certificate path in the serverless agent directory: /home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<TrustStore_filename>
Trust Certificate Key Store Password	The password for the truststore file.
Client Certificate Key Store	The path and file name of the keystore file. You must prefix the file path with file colon (file:). For example, file:C:\SSL\mysql_new\keystore For the serverless runtime environment, specify the following certificate path in the serverless agent directory: /home/cldagnt/SystemAgent/serverless/configurations/ssl_store/<KeyStore_filename>
Client Certificate Key Store Password	The password to access the keystore file.
JDBC Cipher Suites	Colon-separated cipher suite values in RFC format. For example: TLS_ECDHE_ECDSA_WITH_AES_128_CBC_SHA256: TLS_ECDHE_RSA_WITH_AES_128_CBC_SHA256

Connection property	Description
SSL Certificate Authority	The path and name of the CA certificate. For example, C:\SSL\mysql_new\ca.pem
SSL Certificate	The path and name of the client certificate. For example, C:\SSL\mysql_new\client-cert.pem
SSL Key	The path and the name of the private key of the client. For example, C:\SSL\mysql_new\client-key.pem
SSL Cipher	Colon-separated cipher-suite values in OpenSSL format. For example: ECDHE-ECDSA-AES128-GCM-SHA256: ECDHE-ECDSA-AES256-GCM-SHA384: ECDHE-RSA-AES128-GCM-SHA256:
Verify Server's Identity	Verifies the host name in the certificate while verifying the server CA certificate. This property is applicable only when you enable Verify Server Certificate in the SSL properties.