Oracle DB and Server Health Report with OEM, BI Publisher Reports and Microsoft Power BI (Part-3)

Опубликовано: 21 Октябрь 2024
на канале: YouVolve

999

Under this topic we are going to learn how to create a database environment health report using data from OEM 13c repository, BI Publisher Report that comes free with OEM and Microsoft Power BI which is also free to be used in your desktop.

As this is going to be a long topic, I have divided it into 3 parts as given below:

1) Constructing and explain the SQL query to extract the data from OEM repository
   • Oracle DB and Server Health Report wi...

2) Use the SQL to create the report in BI Publisher report in OEM
   • Oracle DB and Server Health Report wi...

3) Use the SQL to create the report in Microsoft Power BI
[This Video]

I have already developed the SQL query that will be used extract the data from OEM repository.
As this is a very complex and large SQL, I have divided it into smaller parts by a method called subquery factoring using "WITH" clause. Each of the subquery is accomplishing a specific task and I am joining all the subqueries in the main query to give us the final output. Although the query looks big and complex, it is not expensive and runs within a minute or so.

This SQL query is getting the latest metric data collected for the database and host targets by the OEM agents so every time we run it it will give us the latest metric data for the targets. so we can schedule the report to come every hour or per your desired frequency.

I have also used analytical and hierarchical functions in the SQL and this can be downloaded using the link below:
https://drive.google.com/file/d/1nz7M...

Link to the series of Power BI tutorials:
   • Power BI

Power BI Desktop version download link:
https://www.microsoft.com/en-us/downl...