Bitrix24 Self-hosted administration

This module is designed for connecting to third-party BI-systems Business Intelligence (BI) is a set of tools and technologies for collecting, analysing and processing the data.

Learn more ... engaged in processing statistical data, collected during Bitrix24 account operation.

  Module installation

By default, module is not installed independently, but installed at the page Settings > System settings > Modules.

Select the necessary options when installing the module:

• Copy Public Files And Site Template - is a required option. Remove this flag, if data input have been customized beforehand.
• Overwrite existing files - in case previous earlier module installations are discovered, they will be overwritten.

During installation, system uses default connection to database. This method guarantees the operation; however for an increased effectiveness, it's recommended to edit the settings file Bitrix Framework has several specific core settings that doesn't have a visual interface for editing.

Learn more ... Core D7 bitrix/.settings.php:

• Copy the key 'default' from the connections key into the key with a new name (for example: biconnector);
• Replace the key className value to '\Bitrix\BIConnector\Connection';
• If required, add the file connection for a connection adjustment 'include_after_connected'.

Result can look as follows:

  'connections' =>
  array (
    'value' =>
    array (
      'default' =>
      array (
        'className' => '\Bitrix\Main\DB\MysqliConnection',
        'host' => 'localhost',
        'database' => 'sitemanager',
        'login' => 'user',
        'password' => 'password',
        'options' => 2,
        'include_after_connected' => $_SERVER['DOCUMENT_ROOT'] . '/bitrix/' . 'php_interface/after_connect.php',
      ),
      'biconnector' =>
      array (
        'className' => '\Bitrix\BIConnector\Connection',
        'host' => 'localhost',
        'database' => 'sitemanager',
        'login' => 'user',
        'password' => 'password',
        'options' => 2,
        'include_after_connected' => $_SERVER['DOCUMENT_ROOT'] . '/bitrix/' . 'php_interface/after_connect_bi.php',
      ),
    ),
    'readonly' => true,
  ),

Approximate contents of the file after_connect_bi.php:

$this->queryExecute("SET NAMES 'cp1251'");
$this->queryExecute("SET sql_mode=''");

  Module handling and setup

Settings

Module setup is performed at the page Settings > System settings > Modules > BI-connector. You only have to indicate access permissions at this page. The system automatically creates Google Datastudio connector deployment ID. Identifier is not required for connecting other systems.

Module operations

This module is capable of:

• Connecting BI-systems,
• Managing keys,
• Managing reports.

Some of these operations are described in Bitrix24 Helpdesk.