Search

Connectors and Connections

Connectors and Connections

Back Next

MySQL connection properties

MySQL connection properties

When you set up a MySQL connection, configure the connection properties.

The following table describes the 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. 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. 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. 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> The default connection timeout is 270000 miliseconds.
Runtime Advanced Connection Properties	Additional properties for the ODBC driver to run ingestion and replication jobs . If you specify more than one property, separate each key-value pair with a semicolon.

Data Ingestion and Replication connection properties

Watch

Comments

Cloud Mass Ingestion Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.