data lake
It would be very useful to have a separate reporting database or the ability to replicate the database for reporting purposes.
For us this could be useful to have a data lake that could be used externally like with Power BI. We currently run many very complex reports using SmartConnect API's against our live instance (because they are too complex for the built-in reports).
This can cause major slowdowns in the live system with some of our more intense reports.
There was a suggestion regarding AI insights where John Fulton suggested a data lake. It would be great if we could have dual use of this data lake for AI insights as well as external connectivity with a tool like Power BI and/or custom coded reports (i.e. API access).
Otherwise, it would also be useful to have some way to automatically backup the database in a format that could be restored (ie. Maria DB - I think that's what SS uses). Then to keep the database up to date, an option to ship logs at specified intervals for replication - or even webhooks that could be called any time there is a CRUD operation on the system. It would be also useful to have settings to specify which UTA's to include as well as what target data (i.e. maybe the ability to specify a filter of some sort)
 Eric Babin
    
 shared this idea
Eric Babin
    
 shared this idea
      
     
        