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 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. |
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 jobs. If you specify more than one property, separate each key-value pair with a semicolon. |