topic Use new database extension to run DB Query from Dynatrace in Extensions

Use new database extension to run DB Query from Dynatrace

agylpradipta — Wed, 03 Apr 2024 10:41:09 GMT

Hello everyone,

Currently, I'm still using the Custom Database Query extension to run an Oracle database query through Dyantrace.

However, there is a notification indicating that the status of this extension is deprecated and it is recommended to use the "Custom database extension".

Yet, I'm having difficulty finding the configuration steps for this extension to enable it to execute Oracle queries. Could someone please guide me on how to configure it?

Thank you.

Re: How to Use New Database Extension to Run DB Query From Dynatrace?

Mohamed_Hamdy — Mon, 25 Mar 2024 05:38:20 GMT

Hello @agylpradipta ,

unfortunately, the custom db extension v2.0 is not available publicly yet, so you can create the extension by yourself using the available official documentation or contact Dynatrace extension team

https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/sql

https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/sql/sql-reference

as for the current Custom Database Queries v1, yes it's deprecated but it's supported by Dynatrace till October 2024

Re: How to Use New Database Extension to Run DB Query From Dynatrace?

PacoPorro — Mon, 25 Mar 2024 07:14:57 GMT

take a look on the VSCode plugin to develop extensions.

https://developer.dynatrace.com/extensions-v2/dynatrace-extensions-vscode/guides/getting-started/

Re: How to Use New Database Extension to Run DB Query From Dynatrace?

jose_araya — Mon, 25 Mar 2024 20:07:15 GMT

Hi there.

We faced the same situation and we investigated the process of developing a new Query extension using the new framework, however, we found that it's still quite basic in its implementation of queries. We had to define the queries themselves inside the JSON and this was very inflexible, so for now we stick with the previous version.

Configuring queries should be managed at the endpoint configuration level in Dynatrace, not directly inside the JSON file of the extension, this complicates deployment of changes enormously.

Regards,

JD.

Re: How to Use New Database Extension to Run DB Query From Dynatrace?

AurelienGravier — Tue, 26 Mar 2024 13:39:58 GMT

Hello @agylpradipta ,

The excellent practical guide to SQL extensions with @vagiz_duseev is what you need :

https://www.youtube.com/watch?v=t9kHPKL9yKY

Regards Aurélien