Data Warehouse?


There is an old discussion about data warehousing at RT - Data Warehouse? and I’m wondering if anyone has any recent experience to share ?

We’re looking to create reports that RT doesn’t do out of the box without doing too much SQL wrangling as the schema is large and it’s too easy to make mistakes.

I think I need/should/want to extract data into some kind of data warehouse but that’s not an area with which I am very familiar.

Has anyone successfully done this for a 4.4.2 installation ?

Our Opsview platform includes Jasper reports as standard so there’s some commonality there but we also have access to Power BI and other tools if necessary.

All pointers gratefully received.