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.