SMDR to SQL. Fail-tolerant, real-time SMDR data logging - 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.

SMDR to SQL data flow diagram

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 to use our database table, but you may write data to your database table.

Download a Free Trial Version. It allows you to try all features!

PBX compatibility list


3COM NBX (XML, v6)


Aastra 470 (PC5 format)
Aastra Intelligate (tab)
Aastra Intelligate IP SMDR
Aastra MX-ONE (ASB501 format)
Aastra MX-ONE (MDFP15 format)
Aastra MX-ONE
Alcatel 100 model 64 phase II
Alcatel 4100
Alcatel 4200
Alcatel 4300
Alcatel 4400 (FTP)
Alcatel 4400 P
Alcatel OmniPCX Enterprise (Ethernet Real Time)
Alcatel OmniPCX Enterprise (OXE)
Alcatel OmniPCX Office (OHL Driver XML)
Alcatel OmniPCX Office
Aristel AV38 (DD MM)
Aristel AV38
Asterisk (AMI interface)
Asterisk (CSV)
Asterisk (Master CSV)
Asterisk Fonality (CSV)
AudioCodes Gateway (Extended)
AudioCodes Mediant 1000
AudioCodes SBC
AudioCodes VoIP Gateway
Australia Mobile (CSV)
Avaya (59 Chars Output Format ACM 4.0+)
Avaya (Customized Output Format ACM 4.0+)
Avaya (Customized Output Format ACM 6.0+)
Avaya (Customized Output Format Call Center)
Avaya (Enhanced Unformatted Output Format ACM 4.0+)
Avaya (Expanded Output Format ACM 4.0+)
Avaya (Printer Output Format ACM 4.0+)
Avaya (Unformatted Output Format ACM 4.0+)
Avaya (cost)
Avaya ACM3 (Custom User Format)
Avaya Aura S8800 (Customized Output Format ACM 6.3+)
Avaya CMS (Split Feed)
Avaya Communication Manager (Customized Output Format ACM 6.3+)
Avaya Definity v1
Avaya G3 V12 (Unformatted ACM 3.x)
Avaya G3 V12 (Unformatted Output Format)
Avaya G3 V12
Avaya G3 V9
Avaya IP Office 406 (CSV)
Avaya IP Office 500 (CSV)
Avaya IP Office Phone (CSV)
Avaya MERLIN 1030
Avaya MERLIN 3070
Avaya Merlin Magic
Avaya MultiVantage (Unformatted Output Format ACM 4.0+)
Avaya Partner


BroadSoft BroadWorks


Cadcom 3600
Cisco Call Manager (CSV) v10
Cisco Call Manager (CSV) v6
Cisco Call Manager (CSV) v7
Cisco Call Manager (CSV) v8
Cisco Call Manager
Cisco Router CDR
Cisco UC560
Comdial (CSV)
Comdial ConversIP MP5000
Comdial DSU2
Comdial DX80
Comdial DXP (SMDR)
Comdial DXP Plus (SMDA)
Comdial DXP Plus (SMDR)
Comdial FX
Comdial MP5000 v2


DVC (Digital Voice Corp)
Digium Switchvox (Event Notifications)


ECI Telecom Coral III
ESI (csv)
ESI (tabular)
ESI v2 (csv)
ESI v3 (Extended Format)
ESI v3 (csv)
Eclipse Executone IDS
Ericsson BP 250 (BiDi)
Ericsson BP 250
Ericsson BP128i (Call-Hotel)
Ericsson BP128i
Ericsson Businessphone 250b
Ericsson Businessphone 250c
Ericsson Businessphone 250
Ericsson Businessphone 50-250 (CIL4HOTEL Format)
Ericsson Businessphone 50-250 (Flexible CIL Format)
Ericsson Businessphone 50
Ericsson MD110 (FORM2 ASB 501)
Ericsson MD110 BC12
Ericsson MD110 Standard
Ericsson MD110


FIAS RS232 (Micros Fidelio Interface Application over RS232)
FIAS TCP (Micros Fidelio Interface Application over TCP)
FreeRADIUS (Accounting Log)
Fujitsu 9600
Fujitsu E650


Genbend M6
GoldStar GPS-6A
Grandstream UCM6100
Grandstream UCM6200 (Real Time)
Grandstream UCM6200
Grandstream UCM6500 (Real Time)


HOBIC (I,II,2001)
Harris 20x20M
Harris 20x20
Hybrex G1-824
Hybrex GD-320
Hybrex GDS-160


Inter-Tel 5000
InterTel Axxess
Iwatsu ADIX


Karel MS48
Komutel Custom Format


LG Aria Soho
LG CS-1000
LG GDK-100
LG GDK-162
LG GHX-1232
LG LDK-100
LG LDK-300
LG Starex VSP
LG ipLDK-20
London 16
Lucent G3


MTA M-200
Matrix Eternity (Report)
Matrix Eternity
Meisei 100-D R3
Mitel 3000
Mitel 3300 ICP (Standard Format)
Mitel 3300 ICP (Standard Full)
Mitel 3300 ICP (Universal)
Mitel 5000 CP
Mitel 5000
Mitel CS-5000
Mitel SX 200 EL
Mitel SX 2000
Mitel SX 200D
Multicom (Universal)
Multicom A416
Multicom A632
Multicom BS-24100
Multicom C1248
Multicom G1260
Multicom Maxicom MP80
Multicom Maxicom MXM300
Multitek 300


NEC (LAN Extended Format Fixed Length)
NEC (LAN Flexible Format Variable Length)
NEC (LAN Normal Format Fixed Length)
NEC 2000 IVS Series
NEC 2400
NEC Aspire (Format2,Date)
NEC Aspire 300IP
NEC Aspire V2
NEC Aspire
NEC DS2000
NEC Electra Elite IPK II (no date)
NEC Electra Elite IPK II
NEC ElectraElite IPK (CSV)
NEC ElectraElite IPK
NEC Elite Series 8000
NEC NEAX7400 ICS m100
NEC Neac 1400
NEC SL1000
NEC SL1100
NEC SV9100 (General Overseas Format)
NEC SV9300
NEC Topaz
NEC Univerge SV8100 (General Overseas Format)
NEC Univerge SV8100
NEC XN 120
NEC Xen Axis (CSV)
Nec SOPHO iS3000 (RS232, FDCR Format 4)
Netas Diginet DX-1,2,3
Nitsuko 124i
Nitsuko 288 M2
Nitsuko 288
Nitsuko 384i
Nitsuko Businesscom DS
Nitsuko DX2E-32i
Nortel CS1000 (2 rows)
Nortel Meridian (1 row)
Nortel Meridian (2 rows)
Nortel Meridian (3 rows)
Nortel Meridian (3 rows,v25)
Nortel Norstar SL1 CLID
Nortel Norstar SL1 Standard
Nortel Norstar Standard
Nortel Type 2


Onyx III
Opticon IP


Panasonic 576 (Caller ID)
Panasonic 576
Panasonic 816
Panasonic DBS 72 CPC-A
Panasonic DBS-90
Panasonic KX-HTS32
Panasonic KX-HTS824
Panasonic KX-NCP1000
Panasonic KX-NCP500
Panasonic KX-NS1000
Panasonic KX-NS300-NS500-NS700
Panasonic KX-NSX1000
Panasonic KX-NSX2000
Panasonic KX-T1232 (DD-MM-YY)
Panasonic KX-T1232
Panasonic KX-T336100b
Panasonic KX-T7436
Panasonic KX-TA308
Panasonic KX-TA616
Panasonic KX-TA624
Panasonic KX-TD1232
Panasonic KX-TD500 v2 (ring)
Panasonic KX-TD500 v3 (cost)
Panasonic KX-TD500 v4 (ring,cost)
Panasonic KX-TD500
Panasonic KX-TD612
Panasonic KX-TD816
Panasonic KX-TDA100 (cost)
Panasonic KX-TDA100 (ring)
Panasonic KX-TDA100 (ring,ampm)
Panasonic KX-TDA100 (ring,cost)
Panasonic KX-TDA200 (cost)
Panasonic KX-TDA200 (ring)
Panasonic KX-TDA200 (ring,cost)
Panasonic KX-TDA30 (cost)
Panasonic KX-TDA30 (ring,cost)
Panasonic KX-TDA600 (cost)
Panasonic KX-TDA600
Panasonic KX-TDA
Panasonic KX-TDE100
Panasonic KX-TDE200 (ring, mm.dd.yy)
Panasonic KX-TDE200 (ring,cost)
Panasonic KX-TEB308 (cost)
Panasonic KX-TEB308
Panasonic KX-TEM824
Panasonic MU
Planet IPX-2000


Quintum Tenor


RADIUS (Accounting Server)
Rolm 9751 (ACD ANS REPORT)
Rolm Redwood 9722


Samsung DCS Compact II
Samsung DCS
Samsung MU
Samsung NX-1232
Samsung NX-820
Samsung OfficeServ 100
Samsung OfficeServ 500
Samsung OfficeServ 7030
Samsung OfficeServ 7070
Samsung OfficeServ 7200
Samsung OfficeServ 7400
Samsung SKP-36HX
Samsung SKP-56_120
Samsung SKP-816 (fixed pos)
Samsung SKP-816
Samsung iDCS 100 M2
Samsung iDCS 100
Samsung iDCS 500
Selta 1000
Selta SAM Office 8
Selta Sti 100
Shoretel 6
Shoretel 7
Shoretel 9
Siemens HiPATH 1100
Siemens Hicom-118
Siemens Hicom-150 OfficeCom v2
Siemens Hicom-150 OfficeCom
Siemens Hicom-250
Siemens Hicom-300E (ANI format)
Siemens Hicom-300H (ANI format)
Siemens Hicom-300H
Siemens Hicom-350H
Siemens Hipath 4000 (CDR Standard Format)
Siemens Hipath 4000 (CDRE)
Siemens Hipath 4000
Siemens Hipath-3350
Siemens Hipath-3500
Siemens Hipath-3550 v2
Siemens Hipath-3550
Siemens Hipath-35xx (CSV)
Siemens Hipath-3700
Siemens Hipath-37xx (CSV)
Siemens Hipath-37xx (Delimited by Pipe)
Siemens Hipath-3800
Siemens Rolm 9751 (Compat,no ANI)
Siemens Unify OpenScape Business X8
Siemens Unify Openscape 4000 (TCP)
Siemens Unify Openscape 4000
Siemens Unify Openscape Office V3
Siemens iSDX Realitis
Snom ONE
Sonus 2000 SBC
Sonus SBC (RADIUS,1000,2000)
Sphere VOIP Softswitch
Splicecom Maximiser


TAPI data parser
Tadiran Coral (1 row)
Tadiran Coral (2 rows)
Tadiran Coral Emerald
Tadiran Coral Flexicom 400
Tadiran Coral II (2 rows)
Tadiran Coral III
Tadiran Coral IPX
Tadiran Emerald ICE
Tadiran IPX 500 (1 row)
Tapit CSV
Tekelec T6000 (CSV)
Telepo 3
Telnyx CDR (CSV)
Telrad v2
Tennyson SOX
Toshiba IP Edge
Toshiba Strata CIX
Toshiba Strata CTX
Toshiba Strata DK 14,40,424
Toshiba Strata DK 240,280
Toshiba Strata DK 2
Toshiba Strata DK 56


Vertical SBX 320 (Caller ID Name)
Vodavi Starplus
Vodavi XTS


Welltech ePBX 100


Yeastar (S100,S200,S300)
Yeastar MyPBX Enterprise


eOn Millennium v1.2
eOn Millennium