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. |
Use Secret Vault | Stores sensitive credentials for this connection in the secrets manager that is configured for your organization. This property appears only if secrets manager is set up for your organization. When you enable the secret vault in the connection, you can select which credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured. Note: If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option. For information about how to configure and use a secrets manager, see Secrets manager configuration. |
Runtime Environment | The name of the runtime environment where you want to run the tasks. Specify a Secure Agent, Hosted Agent, serverless, or elastic runtime environment. For more information about how to configure an elastic runtime environment, see Configure the elastic 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. |
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 an ampersand (&). For example, enter the following property to configure the connection timeout when you test a connection: connectTimeout=<milliseconds> 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. |
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:
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. |