To obtain the information required for configuring a MySQL Server Data Source, consult an administrator.
Configure the MySQL Data Source information as shown in the table below
| Field | Description |
|---|---|
| Database Host Name | FQDN or IP Address of MySQL server, host should be reachable by the GD server |
| Database Name | Name of designated database in MySQL server containing tables with information to be used to populate directory |
| Database Username | MySQL user with at least read access to the database and tables to be used for directory |
| Database Password | Password for MySQL User |
| Table Name | Name of table in MySQL database containing information to be used to populate directory |
| Database Charset (optional) | Database character set i.e. UTF8 – Last Name Column |
| Sync Filter | Enter a valid SQL WHERE clause condition to match filter preferences and sync desired contacts |
| Last Name Column | Name of column containing last names data |
| First Name Column | Name of column containing first names data |
| Main Number Column | Name of column containing main telephone numbers data Note: Number Formats can be applied to this field |
| Mobile Number Column | Name of column containing mobile telephone numbers data Note: Number Formats can be applied to this field |
| Other Number Column | Name of column containing any other telephone numbers data Note: Number Formats can be applied to this field |
| Location Column | Name of column containing location data |
| Title Column | Name of column containing title data |
| Additional Column | Enter any additional corresponding name ex “mail” to pull email address Note: Some of properties terms may change depending on the configuration |
| Username Column | Enter the csv header name which corresponds to Username Example – “username”. Note: If no username is present local contact attributes will be disabled for contact |
| Additional Columns | Name of column containing any other data which you would like to be present in the directory. |
Click Save to add and proceed to the Syncing a Data Source section.
Post your comment on this topic.