Microsoft SQL Integration Guide

Yeastar P-Series Software Edition supports the integration with Microsoft SQL, which allows for automatically triggering contact lookup in your Microsoft SQL database when an inbound call reaches your PBX and displaying caller's name if a match is found. In addition, contact synchronization with phonebook(s) enables convenient outbound calling from Linkus UC Clients and intelligent inbound call routing based on phonebook(s) matches.

Requirements

Make sure that PBX server meets the following requirements:
  • Plan: Enterprise Plan (EP) or Ultimate Plan (UP)
  • Firmware: Version 83.16.0.70 or later

Integration flow

The integration between Yeastar P-Series Software Edition and Microsoft SQL enables a variety of features, including caller ID name display, contact synchronization, and intelligent inbound call routing based on phonebook matches.

Depending on the features that you want to implement, you will need to perform different operations for the integration, as shown below:

Scenario: Caller ID name display
  1. Integrate Yeastar P-Series Software Edition with Microsoft SQL
Scenario: Caller ID name display and contact synchronization
  1. Integrate Yeastar P-Series Software Edition with Microsoft SQL
  2. Set up Contact Synchronization from Microsoft SQL
Scenario: Caller ID name display, contact synchronization, and inbound call routing based on phonebook match
  1. Integrate Yeastar P-Series Software Edition with Microsoft SQL
  2. Set up Contact Synchronization from Microsoft SQL
  3. Set up inbound routes based on phonebook matches