Oracle OEM details in PowerBI

Instead of filling out excel files with all of our Oracle database details, I decided to use Power BI to organize that information.

Prerequisites

•  Must have Oracle client installed on computer
• Must have a tnsnames.ora file to connect to Oracle database
• Connecting to Oracle Database

The server entry is actually the entry in your tnsnames. Example below

Also fill in the select statement for the view that you want

In the next window choose database and then supply database credentials

A few of the OEM tables that I find interesting
mgmt.$hw_nic
mgmt.$jobs
mgmt.$os_hw_summary
mgmt.$target
mgmt.$target_properties