Remember that the data in Genesys Cloud is non-structured and in a data lake, not a database. You access the data through the API or the UI. To get data out, most people use batch jobs on the API, but others run reports daily as CSV's and then use that to import into SQL. An alternative is to use EventBridge or Notifications to capture data in real time and write to your SQL database.
Avtex Insights on the AppFoundry uses the API method to create structured database in Azure that can then be accessed with SQL tools.
------------------------------
Robert Wakefield-Carl
Avtex Solutions, LLC
Contact Center Innovation Architect
robertwc@avtex.comhttps://www.Avtex.comhttps://RobertWC.Blogspot.com------------------------------
Original Message:
Sent: 10-06-2021 04:09
From: Charl Strauss
Subject: Export data to mysql
Hi Everyone,
we are trying to setup a process where call metadata can be extracted into MySQL / SQL
with stats dispatcher no longer being available what other methods are available to automate extracting call data from Genesys cloud to MySQL?
#Reporting/Analytics
------------------------------
Charl Strauss
SafriCloud PTY Ltd
------------------------------