Press "Enter" to skip to content

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.

  •  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

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *