API-only metrics - Oracle database insights

[Babar_Qayyum]

Dear All,

How to obtain the Oracle database insights API-only metrics (These metrics are not charted in Dynatrace but can be accessed through calls to the Dynatrace API.) and use them in a presentable way?

Regards,

Babar

[ryan_ott · Accepted solution]

Hi Babar,

These metrics and their data points can be pulled via an API call to the following endpoint: '/api/v2/metrics/query'. You can provide the metricSelector (as mentioned here - metric keys: https://www.dynatrace.com/support/help/shortlink/database-insights#api-only-metrics ), resolution, starttime, endtime, and entitySelector for filtering. You can play around with these API queries interactively through the API explorer built-in to Dynatrace - accessible by clicking the person icon in the top right of your environment and then selecting 'Environment API v2', in this case. 

For presenting the data, I would recommend using any tool that can dynamically import data from Web API calls, such as Excel or PowerBI. Both of which provide powerful charting and reporting capabilities.

Hope this helps.

-Ryan