Genesys Cloud - Main

 View Only


Discussion Thread View
  • 1.  Power BI to Purecloud Data

    Posted 07-13-2020 07:52

    Dear Experts ,

    we are looking to get data from purecloud to MS Power BI  or to replicate the cloud data to On Premise Data Base (SQL),

    is there any documents which has steps ?



    #Integrations

    ------------------------------
    Noufal Ibrahim

    ------------------------------


  • 2.  RE: Power BI to Purecloud Data

    Posted 07-13-2020 11:18
    If you look in the Developer Tools, there is source code for a Data Exporter and other information about using the Analytics engine to pull information from the API.  There are other options.  First Avtex and PureInsights have engines that can extract data and map it to an SQL-type database in the cloud.  Our preference is Azure DB, but AWS db's also work.  Let me know if you want information about the Avtex offering or look on AppFoundry for Power BI.  

    Please remember that data in the API is JSON data - not structured data like you find in a SQL database.  You will need to transform and and map your JSON replies from the API to the column/row structure.

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



  • 3.  RE: Power BI to Purecloud Data

    GENESYS
    Posted 27 days ago

    Posting on this thgread as well in case someone comes across it again.

    Note that you can now set up scheduled export of Performance views to a static URL and pull that data into Power BI:

    https://help.mypurecloud.com/articles/generate-static-link



    ------------------------------
    George Ganahl GCP, GCSME, ICCE, ICHD, etc.
    Senior Principal PS Consultant
    Genesys
    ------------------------------



Need Help finding something?

Check out the Genesys Knowledge Network - your all-in-one access point for Genesys resources