Connections > MySQL connection > MySQL connection properties
  

MySQL connection properties

When you set up a MySQL connection, configure the connection properties.
Before you configure the connection properties, you'll need to get information from your MySQL Cloud account.
The following video shows you how to get information from your MySQL Cloud account:
https://infa.media/3POvO7P
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.
Select the Informatica Cloud Hosted Agent.
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 data loader tasks.
If you specify more than one property, separate each key-value pair with a semicolon.