Genesys Cloud CX (formerly PureCloud)

Discussion Thread View
Expand all | Collapse all

Export data to mysql

  • 1.  Export data to mysql

    Posted 11 days ago
    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
    ------------------------------


  • 2.  RE: Export data to mysql

    Top 25 Contributor
    Posted 6 days ago
    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.com
    https://www.Avtex.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 3.  RE: Export data to mysql

    Posted 6 days ago
    Hi Rob,
    Just a question about EventBridge. Who pays for the AWS processing of real time notifications?
    Kind Regards

    ------------------------------
    Warren Beddie
    Noralogix PTY (Ltd)
    warren@noralogix.com
    ------------------------------



  • 4.  RE: Export data to mysql

    Top 25 Contributor
    Posted 5 days ago
    From what I have seen with the Beta, it is all on AWS, so you would pay on your AWS account.  This is just an integration that allows EventBridge to subscribe to GC notifications, so there is nothing on GC that could be billed, but you never know with Genesys.

    ------------------------------
    Robert Wakefield-Carl
    Avtex Solutions, LLC
    Contact Center Innovation Architect
    robertwc@avtex.com
    https://www.Avtex.com
    https://RobertWC.Blogspot.com
    ------------------------------



  • 5.  RE: Export data to mysql

    Posted 5 days ago
    Hi Rob,
    Yes that is correct so a client needs to be very careful the type of data one tales unless cost is no issue.
    Kind Regards

    ------------------------------
    Warren Beddie
    Noralogix PTY (Ltd)
    warren@noralogix.com
    ------------------------------