TAPIMaster® 3.2.0 User's Guide

Database interface

Top  Previous  Next

TAPIMaster® can be connected to databases via ODBC, mainly for purposes of caller number identification and storage of call data.




Send call data records to clients

For each call, a call data record is generated, which includes the user extension, the number of the other party, start and end time, call direction and whether the call succeeded. If you activate this option, the data record will be sent to the client after every call. If the user is absent the data will be saved and sent to him the next time he logs on.

Several switches can display the caller data in the telephone display.


Logging of call data

Telephone data records can also be stored in text form with constant character spacing. The data can then be imported quickly into a spreadsheet. The record includes date, time, user extension, number of other party, connected (yes/no), direction (incoming/outgoing), call duration in seconds, for incoming calls the called address of the telephone and the called number (different for group calls).


05.01.2002,15:07:39,  10,            061759857482, yes,out,    31,

07.01.2002,08:29:44,  10,              0892587415,  no, in,     0,                      10,                      50,

07.01.2002,08:35:01,  10,              0892587415, yes,out,   127,

11.01.2002,13:08:25,  10,                      20, yes,out,   603,


It may be necessary to mask out some of the logged data. In this case the final three digits of the external number are overwritten before being saved. For example:


07.01.2002,08:35:01,  10,              0892587XXX, yes,out,   127


A logged on user will still, however, receive the correct data.


ODBC Connection

TAPIMaster® can support three database connections. You can use them to identify the caller on incoming calls. The clients can create telephone books from these data. The call data records generated may be saved in a different database. You can use the third interface for your own programming needs, allowing you to issue SQL commands directly from your client.

To configure an ODBC connection you need to be familiar with SQL and the configuration of ODBC data sources. If you want to test the connection, download the TAPIMaster® SDK. It contains a small database which is described in the examples following.

Important: the database supplies caller information to all clients, meaning that all clients are indirectly connected to the database. Speak to your database provider to find out if your database licences are sufficient to allow this.

The ODBC data sources must be system data sources.


Number recognition

Save call records

Save messages

SQL interface via ODBC

SQL Tools



Send feedback to TAPIMaster

© 2020 Tino Kasubke. All rights reserved.