Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Archiving data

Good Evening people!
With the lack of a true UCCX interface, I have a bodged process that outputs the data from the Cisco Phones to a SQL table on another server.  However, it only gives you a single row of data for that day, as at midnight it wipes it all out and starts again. I have imported the data, as I am performing steps that stop me using a direct link, so I was wondering, is it possible to archive the data at some point before midnight, so that I can start to build it up and build reports around it?  The first field of the row is the start time, so I was wondering if there is a way to stop the data writing on an existing row when the date does not match what is there already and make it jump to a new row?

Or could I do a flow to write the data to a SQL table for archive purposes?

Need Help

5 Replies

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    6 years ago

    Hi Anonymous ,

     

    "With the lack of a true UCCX interface, I have a bodged process that outputs the data from the Cisco Phones to a SQL table on another server."

    Did you mean that because Power BI does not have a UCCX interface, so you transfer data to SQL tables and then connect?

    There are two ways here, one is to use a custom connector .

    And the other is to find a way in your data source, as long as the data source can archive the data, you can get what you want in Power BI.

     

    Best regards,
    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Lionel,  I say true interface, because there is a beta Informix interface, but it only appears to do 64bit, while Cisco is only 32bit. So BI throws an error.

      • v-lionel-msft's avatar
        v-lionel-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Are you using this connector?

         

         

        "so I was wondering if there is a way to stop the data writing on an existing row when the date does not match what is there already and make it jump to a new row?"

        Your problem has nothing to do with the connector, this involves data update problems.

        In Power BI, M and DAX is used to transform and model, so maybe you can try to use SQL to achieve it.

         

        Best regards,
        Lionel Chen

        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago

    This sounds more like a SQL question to me. My SQL skills are not super powerful but seems like you would do an INSERT into the SQL table each time so that you would build up rows of data in your SQL table?