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: |
agentid | Secure Agent ID |