Synchronize 3CX data With SQL or MySQL
NEW! Now supports the Linux version of 3CX
With 3CX Exporter, you can automatically synchronize all 3CX data and generated Call Detail Records (CDR) files with either Microsoft SQL Server or MySQL. This small Windows service runs automatically in the background to keep your external database in sync with the data in 3CX.
We created Exporter to make it EASY to get all the information you need to generate custom reports. Exporter can synchronize all 3CX data and CDR files into an external SQL database in near real-time.Matthew Orr- founder: VoIPTools LLC
The best solutions for your company
Having the data in SQL Server or MySQL allows you to use the reporting tools you already know to create custom reports.
With 3CX Exporter, it's easy to archive historical information separate from 3CX.
Regardless of the information you need, Exporter can get it into SQL for your custom reports or custom integrations.
With 3CX Exporter, you can automate the synchronization of 3CX data and Call Detail Records (CDR) with either Microsoft SQL Server or MySQL.
This small Windows service runs automatically in the background to keep your external database in sync with the data in 3CX.
Some of the benefits
Moving 3CX data to SQL Server or MySQL reduces the demands on your 3CX server. Custom reports run on a separate server.
With 3CX Exporter, processing 3CX CDR files is completely automated. No need to manually import and parse the 3CX text files.
Select the tables you need from the list and Exporter will automatically keep the data synchronized with SQL
If your 3CX server is hosted in the cloud, accessing CDR files is a challenge. Exporter uses our Relay to access CDR files remotely.
FIND OUT MORE
More details about the feature
- 3CX Version 12 or above (Windows Only)
- Windows 7 Pro and above, Windows Server 2008 R2 and above
- Microsoft SQL Server 2008 Express and above
- Microsoft Internet Information Server (IIS) 7.0 and above
- .Net 4.6.1 and above
Version 18.0.91 September 21, 2021
Version 18.0.90 August 11, 2021
- Version 18 Release
Version 16.0.89 July 7, 2021
- No longer generates errors in relay logs.
FAQ’S & KNOWLEDGEBASE
Need more info? Check out our knowledgebase
Yes, we can!
You can set it to import once a day, or every few seconds. It's up to you.
YES! We support both the Linux and Windows versions of 3CX
Sure. We can help you build custom reports. Or you can build reports yourself using whatever reporting tool you prefer.
Yes, you can get access to all 3CX data including queue statistics, extensions, chat logs, just to name a few options.
The structure of call data in 3CX is pretty complicated. The data structure of the CDR files is fairly simple and may be easier to use if the CDR files contain the information you need.
Exporter utilizes our VoIPTools REST API to access 3CX data. Parsing CDR files is handled with real-time events pushed to Exporter by our Relay.