Data Warehouse?


#1

Hi,

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.

Simon.