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.