Use new database extension to run DB Query from Dynatrace

[agylpradipta]

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.

[Mohamed_Hamdy · Accepted solution]

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

[PacoPorro · Accepted solution]

take a look on the VSCode plugin to develop extensions.

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

[jose_araya]

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.

[AurelienGravier · Accepted solution]

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