Data Connector Integration Overview

Data Connector on Yeastar P-Series Software Edition allows you to export PBX data to a third-party SQL database (such as PostgreSQL, MySQL, or Microsoft SQL). The data synchronized to the database can then be further accessed by Business Intelligence (BI) tools, accounting systems, or other applications for data visualization and analytics.

Requirements

Server Requirement
Yeastar PBX Version 83.23.0.83 or later.
Third-party Database One of the following database systems:
  • PostgreSQL
  • MySQL
  • Microsoft SQL

Supported data range for synchronization

Data Description
CDR Synchronize CDR list, call leg, and timeline data.
Recording Logs Synchronize recording logs.
Note: Recording files will not be synchronized.
System Metric Synchronize the following system metrics displayed on the Dashboard.
  • Active Calls
  • CPU Utilization
  • Memory Usage
  • Local Storage Usage
  • Registered Extensions
  • SIP Trunks Available
  • Linkus Client Logins
Note: The system synchronizes the data captured at the time of synchronization.
Call Notes Synchronize call disposition and remark content.
Report Data Synchronize call report data.
AI Summary & AI Transcription Synchronize AI-generated summary and transcription content.

Tutorial

Data Connector integration with Yeastar P-Series Software Edition can be implemented in just a few clicks by configuring the database connection information and synchronization policy.

For more information, see Connect Yeastar P-Series Software Edition to an SQL Database Using Data Connector.

Note: After the integration is complete, you can connect the third-party database with Business Intelligence (BI) tools, accounting systems, or other applications for data visualization and analytics. We provide detailed instructions for the database integration with Grafana and Power BI. For more information, see Import PBX Data from a Database into Grafana and Import PBX Data from a Database into Power BI.