Forum Discussion

VI_Migration's avatar
VI_Migration
Silver Contributor
Mar 29, 2022

Viva Insights query integration with enterprise systems

Currently we are manually accessing our Viva Insights queries using a Microsoft API to download the query result sets to our Enterprise backbone and one of our loads takes roughly 3 days to get execu...
VI_Migration's avatar
VI_Migration
Silver Contributor
Mar 29, 2022

Hi VI_Migration, 

I'm not sure if this post may help - https://community.vivainsights.microsoft.com/t5/Advanced-insights/Using-Data-Factory-via-OData-connector/m-p/1375#M185

Unless you're already doing something similar?

  • VI_Migration's avatar
    VI_Migration
    Silver Contributor
    Mar 30, 2022

    Hi Dazza,

    Thank you very much for this prompt reply but we are already doing this and accessing Queries that we pre built into our WpA instance. The limitation here is that we will need to build queries for each month of data that we are looking to download. 

    What we are looking for an flexible API were we can pass a parameter/s for say "the month of the data we are trying to down load". here the query will remain the same but the data will change based on the month we are looking for.

    Looking for feedback on this.

    Thanks,

    Glen

Resources