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. Note: You cannot run a database ingestion and replication task on a 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 mappingsingestion and replication jobs. If you specify more than one property, separate each key-value pair with a semicolon. |