To obtain all the information required to connect to MSSQL Server, consult the SQL Server administrator.
- Enter the information required for Microsoft 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 |
Table Name | Enter Database Table Name |
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 |
Mobile Number Column | Enter Database Table Column containing Mobile Number |
Other Number Column | Enter Database Table Column containing Other Number |
Location Column | Enter Database Table Column containing Location Number |
Title Column | Enter Database Table Column containing Title |
Username Column | Enter Database Table Column containing Username Note: If no username is present local contact attributes will be disabled for contact |
Additional Data Column | Enter Database Table Column containing Additional data such as email address |
- Click *Save *to add a data source and proceed syncing data source section 4.3
Post your comment on this topic.