How to configure logging to the database using the ODBC Database module
If you are going to use an MS SQL Server, MySQL, or Oracle database, first create a database with tables for storing data. You may find the corresponding SQL script or MS Access database file in "Program Folder\data\" (for example, C:\Program Files (x86)\Advanced PBX Data Logger\data\). Note: the logger cannot automatically create a database for you. Maybe, you prefer to re-install the program. The installation wizard can create a database for you.
For MySQL or Oracle, you need to install the latest 32-bit version of ODBC drivers separately.
MS SQL Server, MS Access: Windows XP or higher already contains ODBC drivers for these databases.
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.
If you have already installed our software, the following tutorial describes how to configure a connection with a database.
1. Create a new configuration (if you haven't done it yet)
- If you do not have any configurations yet, you may click the "Green Plus" button in the program's main window and configure everything manually. But please consider to re-install the program from scratch and select the necessary options. The installation wizard will prepare all the required settings.
- If you have a working configuration already, then clone the working configuration "Main menu → Options → Manage configuration → Clone."
2. Configure a connection to your PBX.
3. Switch to the "Modules → Query Parse Filter" tab and select a parser for your PBX (Figure 1).
Note: A lack or incorrect operation of the parser may prevent data from being written to the database. The next section describes how to check the parser's operation.
Figure 1. Selecting a parser
4. Switch to the "Modules → Data export" tab and check the "ODBC database" checkbox (Figure 2).
Figure 2. Selecting a data export module
5. Open the data export module's settings by double-clicking the module's name.
6. Click the "Load & Save" button (Figure 3), and select:
- "PBX-Logger-ODBC-Items" - if you are going to write data to a MySQL, MS SQL Server, or Oracle database.
- "PBX-Logger-ODBC-Access" - if you are going to write data to an MS Access database.
7. Switch to the "Common" tab (Figure 3) and enable data logging to the database.
Figure 3. Enabling logging to the database
8. Switch to the "Connection" tab.
8.1. If you already have an ODBC data source, select it from the list (Figure 4).
8.2. If you do not have any ODBC data source yet, click the "Setup" button and create a system ODBC data source. For more details, see the next section. After creating the data source, click the "Refresh" button and select the newly created data source in the list.
8.3. If you use the MS Access database, you should specify or select the database file (*.mdb) in the "Database file" field. You may find the database file in "program folder\data\."
Figure 4. Selecting an ODBC data source
9. Switch to the "Binding" tab and check that the list contains a description of database columns. If the item list on that tab is empty, go to step 6.
10. Click "OK" and save all changes both in the ODBC database settings window and in the module selection window.
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.