Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Connections

Connections

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.
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.

0 COMMENTS

We’d like to hear from you!