Forum Discussion
Automate data extract from VIVA Insights
- Feb 02, 2023
Hi Jake_Caddes, my client would like to perform separate ETL jobs on the data gathered from Viva Insights (specifically on the query results generated from VIVA Insights using the pre-defined templates there) with other source table like HR data to create more meaningful data results to show to different stakeholders. The data extract is currently a manual process, we are looking at other possible methods to automate the data extract/download, any advise?
Found a data lake solution - https://learn.microsoft.com/en-us/viva/solutions/data-lakes/viva-insights (is this the only way to automate?)
Hi VI_Migration, can you elaborate on how you would extract the data from the Viva Insights portal? Do you mean downloading results from queries or is there a different download method/output you are looking at?
- VI_MigrationFeb 02, 2023Silver Contributor
Hi Jake_Caddes, my client would like to perform separate ETL jobs on the data gathered from Viva Insights (specifically on the query results generated from VIVA Insights using the pre-defined templates there) with other source table like HR data to create more meaningful data results to show to different stakeholders. The data extract is currently a manual process, we are looking at other possible methods to automate the data extract/download, any advise?
Found a data lake solution - https://learn.microsoft.com/en-us/viva/solutions/data-lakes/viva-insights (is this the only way to automate?)