Having platform hosted on On-Prem gave the customers flexibility to create the DB replica (backup/restore) of Production instance and write the custom queries for heavy reporting requirements. With CCv2 in place, what are our options apart from OOTB Reporting Definitions which basically uses Backoffice and fires the flexible queries in production DB?
I am looking to avoid firing reporting queries on active prod DB instance as it will have an impact on storefront traffic.
Any inputs/pointers are highly appreciated.