Microsoft SQL Integration Guide

Yeastar P-Series PBX System 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 37.16.0.70 or later
Note: There are no specific requirements for Microsoft SQL, all versions of Microsoft SQL Server can be integrated with Yeastar P-Series PBX System.

Integration flow

The integration between Yeastar P-Series PBX System 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 PBX System with Microsoft SQL
Scenario: Caller ID name display and contact synchronization
  1. Integrate Yeastar P-Series PBX System 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 PBX System with Microsoft SQL
  2. Set up Contact Synchronization from Microsoft SQL
  3. Set up inbound routes based on phonebook matches