topic Re: Could Dynatrace Run This Oracle DB Query? in Open Q&A

Could Dynatrace Run This Oracle DB Query?

agylpradipta — Wed, 24 Apr 2024 02:51:34 GMT

Hello everyone,

So I have an Oracle database query with a format more or less like this:

select "REUPLOAD_VALUE" COLUMN,count(*) from DBNAME.REG_VALUE where status='REUPLOAD'

and the output will be a table like the one below.

COLUMN | COUNT(*)

REUPLOAD_VALUE | 3276543

Is it possible to use Dynatrace, perhaps with an extension, to retrieve the result from the COUNT(*) column?

Then from the result, we will set a threshold, and if it exceeds a certain value, then an alert will be sent.

If possible, could you please assist in showing an example of how to do this?

Thank you.

DanielS — Wed, 24 Apr 2024 03:20:16 GMT

Hi @agylpradipta. Yes it's possible, one easy approach is do it with a script:

agylpradipta — Wed, 24 Apr 2024 03:26:13 GMT

andre_vdveen — Wed, 24 Apr 2024 05:32:17 GMT

You could use that, but the extension is deprecated so I wouldn't use something that is not supported anymore.

agylpradipta — Wed, 24 Apr 2024 05:23:10 GMT

I've just come across the following extension version, which seems to be new and not deprecated -> https://www.dynatrace.com/hub/detail/custom-database-extension/?query=custom+database+query&filter=all. Can we use this?

If so, would anyone here be willing to share how to use it, referring to the Oracle database query I sent earlier?

Thank you.

PacoPorro — Wed, 24 Apr 2024 06:26:06 GMT

Yes, you can use it.
You need to build your own extension. I would recommend using the extension plugin for VSCode

Then you need to build the extensión, refer to SQL datasource here https://docs.dynatrace.com/docs/shortlink/sql-reference