SMDR to SQL. Fail-tolerant, real-time SMDR data logging

Logging SMDR or CDR data to SQL

The data logging process contains the following steps:

1. Receive and capture SMDR or CDR data. Usually, that data comes through an RS232 or TCP port. It would be great if the system creates log files with all the received data. It is the first part of the fail-tolerant system. You can always restore data from these files later.
2. Parse SMDR or CDR data to data rows and data columns for a SQL table. The main goal here is to prepare data for SQL: convert text or binary data to values acceptable by your SQL database.
3. Insert data to a database. The SQL interface should take into account that a database might be temporarily offline in time of database maintenance or network problems. The logger should handle this situation, and store data locally and restore data automatically later.

How to configure the connection between SMDR and SQL?

1. RS232 or TCP connection. Please, follow a link for your PBX in the table below. The page contains the connection instructions for your PBX. The generic tutorial is here.
2. Data parsing. Our Advanced PBX Data Logger contains parsers for many PBXs (356 formats of 296 models and 87 vendors). The links below show a full list of captured values.
3. SQL interface. Please, follow this guide and configure fail-tolerant logging to a SQL database. We recommend using our database table, but you may write data to your database table.

PBX compatibility list