Views: 324
Last Modified: 08.09.2022

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.

Attention:

Please be advised, as of September 1, 2022, the BI-connector module is available only for Bitrix24 Self-hosted subscription licenses. You can find more details about the On-Premise licensing changes for clients and the new Bitrix24 Self-hosted subscription model in this Helpdesk article.

  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=''");
Attention:
  • Use $this for further connection adjustment.
  • Incorrect adjustment may render a project fully inoperable. It's preferable to introduce adjustments either via ssh console or by using sftp.
  • When connecting the BI-connector module in settings.php after creating a key, you must re-save this key in the public section.

  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.

  Deleting the module

Go to the admin section with the module list. Find the BI-connector (biconnector) line in the table and click the button Delete. You will see the deletion confirmation with deletion details. Remove the checkmark from the Save tables if you do not want to save the data available in the system.

To delete the module, click the button Delete module.

When deletion is successful, the opened page will notify you with corresponding message.

Click the button Back to list to switch to the admin section page with list of modules.


0


Courses developed by Bitrix24