Tuesday, November 14, 2017

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



No comments: