Consider a service that stores report data in a data warehouse
Sharegate has great reports, but it is a challenge to run reports against a large tenant. We wrote custom scripts that inventory all sites and subwebs to gather hundreds of metadata. We write these data, including permission matrix, to SQL server database then use Power BI for analytics. Has Sharegate considered as part of their offering to have a way to configure Sharegate to do this work for us and write it to a configurable SQL Server (Azure or on prem) under our control? I'd be happy to elaborate.
Anonymous
shared this idea
-
Jeroen Schoenmakers
commented
This service would greatly improve the scalability of Sharegate. We are currently implementing a synchronized onedrive to share the migration exports (logs) between multiple migration host which we then can analyse in Excel (which is a LOT of work); Rather have each SG migration host log their data in a central (Azure?) SQL instance and use PowerBI to analyse migration progress!
(Lets talk about scalability!)Thanks,
Jeroen