cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

API-only metrics - Oracle database insights

Babar_Qayyum
Leader

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

1 REPLY 1

ryan_ott
Dynatrace Mentor
Dynatrace Mentor

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

ACE Consultant, Dynatrace Services
Dynatrace Certified Professional