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

Custom Query Extension 2.0. Can I borrow yours?

dannemca
DynaMight Guru
DynaMight Guru

Hi community, good day to all.

I just got the update that the current Custom Query DB is now deprecated, and we are supposed to create our own using 2.0 framework.

Before I start digging into this, has anyone here in community that has already played with this and has successfully queried an Oracle DB with this 2.0?

Can you share your code so I can modify it to my own case?

Thanks!!!

Site Reliability Engineer @ Kyndryl
9 REPLIES 9

Mike_L
Dynatrace Guru
Dynatrace Guru

The easiest way to draw inspiration for a data source is to grab the ones on the hub. If you go to any extension tile on the public hub and click on release notes you can download any extension there and see the yaml. The Oracle extension is built using the Oracle data source.

Mike

@Mike_L,

Strangely, for this one, there are no Release notes:

https://www.dynatrace.com/hub/detail/custom-database-extension/

Antonio Sousa

That one isn’t an extension. It is a tile that Dynatrace supports custom database queries through the sql datasource with links to the documentation on how to do it.

Mike

Where do I see the download option here in release notes?
Did not found neither in my extension config nor in the hub page:

Screenshot 2023-12-04 144148.pngScreenshot 2023-12-04 144113.png

Site Reliability Engineer @ Kyndryl

Good afternoon, I am in the process of migrating from version 1.0 to 2.0 of the Generic DB Query Plugin for the first time. I have gone through the documentation, but the steps to follow are still not clear to me. I have attempted to locate a comprehensive, step-by-step guide on how to create and deploy this extension. I've been navigating through VS Code, YAML files, and other tools, but it's apparent that authentications and certificate validations are necessary. If there is a detailed configuration guide available or if someone happens to have one, it would be immensely helpful for guidance on this matter. The configuration of the YAML file appears to be crucial, and any support or insights from the community would be highly appreciated. Thank you very much.

dannemca
DynaMight Guru
DynaMight Guru

I was able to replicate the Custom Query DB extension from 1.0 to 2.0 after Dynatrace updated their docs.

Here are the pages I have used that helped me achieve this:

How to deploy your first extension using VSCode: https://developer.dynatrace.com/extensions-v2/dynatrace-extensions-vscode/guides/getting-started/

Sample Yaml to run DB queries: https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/sql/sql-reference

It was quite simple to be fair. I have not yet tested in production, but at least now I have the proper guidance.

Site Reliability Engineer @ Kyndryl

In the next month or so we're going to release an observability clinic Youtube video on how to do this as well. Good to hear that you managed yourself!

Mike

Mike_L
Dynatrace Guru
Dynatrace Guru

Christmas came early 😊 A step by step video just came out: https://youtu.be/t9kHPKL9yKY?si=a4EI_F48Kd5Bga29

Mike
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