HOWTO Apex BI MySQL Connection

Integration with Apex Bi requires for read access within MySQL to be provided to their server in order for this integration to be functional.

Their requirements are the following:

• Whitelist the Apex BI server IP address 212.84.90.175
• Open read only access to the below tables
• CDR table
• log_ivr_calls table
• Provide the login credentials Apex BI will use to enable the connection

Access MySQL database with query:

/opt/pbxware/sh/mysql

Add a new user by means of a GRANT SQL command giving it read access to CDR and log_ivr_calls tables;

GRANT SELECT ON pbxware.cdr TO 'ApexBi'@'212.84.90.175' IDENTIFIED BY 'password';

GRANT SELECT ON pbxware.log_ivr_calls TO 'ApexBi'@'212.84.90.175' IDENTIFIED BY 'password';