Administrator
- Administrator
- All Products
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.
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.
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.
If you specify more than one property, separate each key-value pair with a semicolon.
|
Runtime Advanced Connection Properties
| Additional properties for the ODBC driver to run
mappings ingestion jobs .
If you specify more than one property, separate each key-value pair with a semicolon.
|