Power BI integration

[vivasupport]

Most of our customers are requesting to integrate PowerBI , the CDR data are not enough to complete the integration. Please help us to integrate the PowerBI and provide any workaround solutions.

 

[Sajjad.Khurshid]

Our business requires the same.

 

[TanSG]

Am working on a similar workaround too. May need to use third party tool to achieve this.

Will share when i succeed

 

[vivasupport]

Am working on a similar workaround too. May need to use third party tool to achieve this.

Will share when i succeed

Thank you for your response.

Could you please advise if we can use PostgreSQL to acquire data through the 3CX integration available in the new beta update?

Appreciate your guidance on this.

 

[Charles_3CX]

You can use PostgreSQL and the AWS PostgreSQL database to acquire data from 3CX and then read the data from the PostgreSQL DB using your tools.

https://www.3cx.com/docs/postgresql-configuration/
https://www.3cx.com/docs/aws-postgresql-configuration/

 

[Charles_3CX]

In addition to this, I’d also like to mention that this capability has been available for some time through the CDR export options in 3CX. You can configure the system to send CDR data over an active socket to a specified location, where tools like Power BI can access and interpret the data for reporting and analysis.

https://www.3cx.com/docs/cdr-call-data-records/

 

[VoIPTools]

This is an old song, but I'll keep singing it. I personally think using an active socket is a less than ideal solution. If your socket connection goes down for any reason (socket service crash, network connection failure, etc.), that data is gone. There is no retry mechanism, or any form of recovery so that data is gone forever (any calls that come in while the connection is broken). The advantage of the file-based approach is that you can always "catch up" later. That is what we do with our 3CX Exporter tool.


It's that simple -- a single checkbox. And it does not matter where your 3CX is hosted (on-prem or hosted on Amazon, Azure, Google, etc.). We instantly detect the new file, automatically parse the data, and push the data to your Microsoft SQL Server, MySQL, MariaDB database). This is real-time data.

In 3CX v20 update 6, there are new "cdr" database tables available for Grafana. We can replicate that data too. You set the frequency (default 60 seconds) and we get you near real-time data available for PowerBi, Crystal Reports, Grafanna, etc. But that is not all, we can also provide queue statistics, agent login/logout times, missed calls, extension/user lists, departments, chat, all the data 3CX uses for their internal reports.