🧩 Integration
🗄️ Database Grant
📊 Get CDR Data from Database of IZT Cloud Voice

📊 Get CDR Data from Database of IZT Cloud Voice

IZT Cloud Voice allows you to access the system database and get CDR data. This topic describes how to get CDR data from the PBX database via Navicat software.

Procedure

  1. Grant Access to the PBX Database:

  2. Log in to PBX web portal, go to Integrations > Database Grant.

  3. Turn on Database Grant option and configure the authentication information for the third-party software to access the PBX database.

Enable Database Grant
  1. Click Add.
  • Enter required address and subnet masks.
  • In this example, enter the IP address of the current network 192.168.5.x and subnet mask 255.255.255.0 to allow all IP address in the network granted access.
Database Grant Permitted IP
  1. Click Save and Apply.
  • The Database Address and Port of the PBX will be displayed on the web page and cannot be modified.
Enable Database Grant

  1. Access the PBX Database via Navicat Software:

  2. Launch Navicat for MySQL on the PC.

  3. On the Navicat main window, click Connection and select MySQL.

Navicat Connection
  1. In the pop-up window, enter the following information:
FieldDescription
Connection NameEnter a connection name to help you identify it.
HostEnter the database address of PBX.
PortEnter the database port.
User NameEnter the same user name that is configured on the PBX.
PasswordEnter the password that is configured on the PBX.
Navicat General Configuration
  1. Click Save.
  2. To check the CDR data, double-click the new connection, and select the cdr table.
Check CDR Table

For more information about the cdr table, see cdr Table in the PBX Database.

🗄️ Database Grant Overview🗃️ CDR Table in the PBX Database