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

Use new database extension to run DB Query from Dynatrace

agylpradipta
Helper

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.

4 REPLIES 4

Mohamed_Hamdy
DynaMight Champion
DynaMight Champion

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

Certified Dynatrace Professional | Certified Dynatrace Services Delivery - Observability & CloudOps | Dynatrace Partner - yourcompass.ca

PacoPorro
Dynatrace Champion
Dynatrace Champion

jose_araya
Helper

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
DynaMight Pro
DynaMight Pro

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

Observability consultant - Dynatrace Associate/Pro/Services certified
Dynatrace provides you with a framework that you can use to extend your observability into data acquired from a database using SQL queries against our supported databases such as Oracle, SQL Server, IBM, MySQL, PostgreSQL, SAP Hana, or Snowflake. Watch this hands-on tutorial where Vagiz Duseev ...

Featured Posts