To obtain the information required for configuring a SQL Server Data Source, consult a SQL Server administrator.
Configure the information required for a SQL Server as shown in the table below
| Field | Description |
|---|---|
| Database Server Name | Enter Database Server Name or IP Address |
| Database Username | Enter Database Username |
| Database Password | Enter Database Password |
| Database Name | Enter Database Name |
| Database Table Name | Enter Database Table Name |
| Sync Filter | Enter a valid SQL WHERE clause condition to match filter preferences and sync desired contacts |
| Last Name Column | Enter Database Table Column containing Last Name |
| First Name Column | Enter Database Table Column containing First Name |
| Main Number Column | Enter Database Table Column containing Main Number Note: Number Formats can be applied to this field |
| Mobile Number Column | Enter Database Table Column containing Mobile Number Note: Number Formats can be applied to this field |
| Other Number Column | Enter Database Table Column containing Other Number Note: Number Formats can be applied to this field |
| Location Column | Enter Database Table Column containing Location Number |
| Title Column | Enter Database Table Column containing Title |
| 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 | Associate any other additional attributes to be synced from data source |
Click Save to add and proceed to the Syncing a Data Source section.
Post your comment on this topic.