Data Connector moves CRM data from Bitrix24 (Alaio) into a database that BI tools can read. Analysts get the CRM entities they need in a form ready for analysis and skip the data collection stage.
How do I get Bitrix24 data into Power BI or Looker Studio?
BI tools work with a database they can query. A spreadsheet exported by hand is out of date the next day, and building your own sync through the API is a separate project. The manual options are covered in exporting CRM data from Bitrix24 to Excel.
Data Connector handles the export. It writes the CRM data you select to an external MySQL database and keeps it up to date. You then connect Microsoft Power BI, Google Data Studio (now Looker Studio), Tableau, Qlik, Metabase, Redash, Apache Superset or Amazon QuickSight to that database and build reports there.
How Data Connector works
- You install the app and enter the access details of your MySQL database in its settings.
- In the Export Management section you choose the CRM entities and fields to export.
- A panel on the left runs a full export of the selected entity.
- After that, the data is updated in real time or once a day at a set time, depending on the plan.
- Whoever works with the analytics database has full access to it and queries the data directly.
Who it is for
Data Connector is built for analysts and BI teams who want to work on CRM data without collecting it first. It also suits managers who need CRM metrics that the built-in reports do not show; for the in-system options, see how to get a custom metric in Bitrix24 reports.
Plans differ in the number of entities and records, the update frequency and smart process export, and every plan includes a backup of your data. A trial gives full access to the top plan, so you can export part of your data, see the structure of the export and then pick a plan.
Frequently asked questions
How do I connect Bitrix24 to Power BI?
Install Data Connector and give it access to an external MySQL database. The app exports the CRM entities and fields you select into that database, and you connect Power BI to it.
Can I get Bitrix24 data into Google Data Studio (Looker Studio)?
Yes. Google Data Studio is one of the BI tools Data Connector is built for: the app fills a MySQL database with your CRM data, and your reports read from that database.
How often does Data Connector update Bitrix24 data?
Depending on the plan, data is updated in real time or once a day at a set time. Real-time updates are available on the higher plans.