When you create or update a MySQL connection, you can configure additional attributes, such as the connection ID and the connection name.
The following table describes attributes that you can use for MySQL connections:
Attribute | Description |
---|---|
id | Connection ID |
orgid | Organization ID. |
name | Connection name. |
description | Optional connection description. |
type | Connection type. Use MySQL. |
username | User name for the database login. |
password | Password for the database login. |
host | Name of the machine hosting the database server. |
port | Network port number used to connect to the database server. Default is 3306. |
database | Database name for the MySQL database target. Database name is case sensitive if the database is case sensitive. |
codepage | The code page of the Microsoft SQL Server database. Use one of the following options: UTF-8. Unicode Transformation Format, multibyte. MS1252. MS Windows Latin 1 (ANSI), superset of Latin 1. ISO-8859-15. Latin 9, Western European. ISO-8859-2. Eastern European. ISO-8859-3. Southeast European. ISO-8859-5. Cyrillic. ISO-8859-9. Latin 5, Turkish. IBM500. IBM EBCDIC International Latin-1. |
agentid | Secure Agent ID |