Advanced PBX Data Logger

Trust In Confidence!

For Windows 2000 - Windows 10 (2019) (incl. Server, x86 and x64). Latest version: 3.5.2 build 805. .


How to install PBX Logger with ODBC Database

Why do I need it?

You need a database you want to use our PBX Reports utility. The logger writes all incoming data to a database in real-time, and PBX Reports works with the prepared data.

Preliminary requirements

If you are going to use an MS SQL Server, MySQL, or Oracle database, first create a database with tables for storing data.

For MySQL or Oracle, you need to install the latest 32-bit version of ODBC drivers.

Download links:

MySQL: http://dev.mysql.com/downloads/connector/odbc/

Oracle: http://www.oracle.com/technetwork/database/windows/downloads/index-096177.html

Windows XP or higher already contains ODBC drivers for MS SQL Server and MS Access.

Solution

The simplest solution is to install or reinstall the program, and then select the respective option in the installation wizard (Figure 1):

  1. Select "Create a configuration."
  2. Select a parser for your PBX.
  3. Select "Write to database" and your database type. If you have 2000 calls per day on your PBX, select the MS Access database. It is free and easy to set up and maintain.

Creating a configuration

Figure 1. Creating a configuration

If you are using an MS SQL Server, MySQL, or Oracle database, you must specify a connection string and the credentials (login and password) of an administrator/user who has the privileges to create objects in the database.

Creating a configuration

Figure 2. Login and password

At the next step, you can choose whether to create any objects in the database. You can copy the object creation script and pass it to your database administrator, who will create objects for you. If you prefer to do that, skip this step.

Creating objects in the database

Figure 3. Creating objects in the database

Interface type

Figure 4. Interface type

DDL script for objects in the database

Figure 5. DDL script for objects in the database

If the installation is successful, Call logging to a database will be configured to write data to the database. You only need to configure the connection to your PBX. PBX Reports will also be configured to read data from the same database.

Now each time new data are received, the program will write them to the database in real-time. If you use the "PBX Reports" utility, you need to click the "Refresh" button on the "SMDR data" tab. Reports use real-time data without clicking the "Refresh" button.

Related articles: