Connect Dromlik to Microsoft SQL
Last updated: 2026-10-19
When Dromlik is connected to Microsoft SQL, every inbound call triggers a contact lookup in your database. If the number matches, the caller's name is shown.
Requirements
| Item | Requirement |
|---|---|
| Dromlik phone system | Orbit plan or higher |
| Microsoft SQL Server | Any version |
Step 1. Turn on the Microsoft SQL integration
- In the admin console, go to Contacts > Company Contacts.
- At the top of the page, click Synchronize Contacts.
- Turn on Enable Microsoft SQL Integration and fill in the settings below.
| Setting | What to enter |
|---|---|
| Server Address | The server's IP address or domain name. If SQL Server uses the default port 1433, enter only the address (for example 112.48.21.123). On another port, add it (for example 112.48.21.123:20001). |
| Database Name | The name of the database. |
| Timeout(s) | How long to wait for the connection to the server. |
| Connection Encryption Mode | Disabled: no encryption. Optional: encrypt only if the server supports or requires it. Mandatory: encryption is required. |
| User | The username used to connect to the database. |
| Password | The password used to connect to the database. |
| Auto-match Contact Filter | A SELECT statement used to match the caller's number, in the format select ${MAP} from {schema_name}.{table_name} where {condition_to_filter_number}. See the example below. |
Auto-match filter example
select ${MAP} from testpbx.contacts where businumber like CONCAT('%', ${NUMBER}, '%')
select ${MAP}—${MAP}is replaced by the columns mapped to the fields you turn on in the Map section (First Name, Last Name, or both). These are shown as the caller's name.from testpbx.contacts— the table to read from. Always use the two-part name{schema_name}.{table_name}.where businumber like CONCAT('%', ${NUMBER}, '%')— finds rows wherebusinumbercontains the caller's number anywhere.
Step 2. Map contact fields
-
Scroll down to the Map section.
-
For Contacts ID, First Name, and Business Number, enter the matching column names from your SQL contacts table. When a call matches, the contact's first name is shown.
Note: Business Number is mapped here because it is the number used in the filter example. Always map the number field you actually filter on.
-
Optional: To also show the last name, select Last Name and enter its column name.
-
If you plan to sync contacts into Dromlik, turn on and map any other fields you want to copy.
-
Click Save.
Result
- The admin console shows that Dromlik is connected to your Microsoft SQL server.
- When an inbound call matches a contact in your database, the caller's name is displayed.
What to do next
To let users call your SQL contacts straight from the Dromlik apps, set up contact sync from Microsoft SQL.