Set up contact sync from Microsoft SQL
Last updated: 2026-10-19
Sync your Microsoft SQL contacts into Dromlik so users can call them from the Dromlik apps. Synced contacts can also be used to route inbound calls to specific destinations based on phonebook matches.
Limits
| Number of extensions (N) | N ≤ 50 | 50 < N ≤ 200 | N > 200 |
|---|---|---|---|
| Company contacts (total) | 50,000 | 200,000 | 500,000 |
| Company phonebooks | 100 | 200 | 500 |
Before you start
You have connected Dromlik to Microsoft SQL and mapped the contact fields you want to sync.
Set up contact sync
- On the Microsoft SQL settings page, scroll down to Contacts Synchronization.
- Turn on Contacts Synchronization and fill in the settings below.
| Setting | What to enter |
|---|---|
| Synchronize to Phonebook | Where synced contacts are stored. Create New: create a new phonebook and enter its name in Phonebook Name. Read Specific Property Value and Create New: create phonebooks based on the values in one column of your contact table; enter the column name in Property Name. This is useful when you want to route callers from different groups to different destinations. |
| Data Synchronization Frequency | How often to sync, and at what time. Syncing many contacts can affect performance, so schedule it outside busy hours. |
| Feedback Email | Optional. Email addresses that receive the sync result. Up to 5, separated by a semicolon ;. |
| Sync Contact Filter | A SELECT statement for the sync, in the format select ${MAP} from {schema_name}.{table_name}. The TOP clause is not supported. See the example below. |
| Remove existing contacts which are not received from the server | When on, contacts synced last time that are missing from the current sync are deleted. |
Sync filter example
select ${MAP} from testpbx.contacts order by id desc
select ${MAP}—${MAP}is replaced by the columns mapped to the fields turned on in the Map section.from testpbx.contacts— the table to sync from, as{schema_name}.{table_name}.
- Click Save.
- Click Sync Now to sync contacts right away.
Result
- A banner shows how many contacts were synced.
- Synced contacts and their phonebooks appear under Contacts > Company Contacts and Contacts > Phonebooks, tagged as coming from Microsoft SQL.
- Users with access can view and call the contacts from the Dromlik apps.
Note: Give users permission to see the phonebook under Extension and Trunk > Client Permission > Contact Visibility, and make sure they use an up-to-date version of the Dromlik apps.
What to do next
Route known callers by phonebook to send calls from synced contacts to the right team.