Custom Query Extension 2.0. Can I borrow yours?

[dannemca]

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!!!

[Mike_L · Accepted solution]

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.

[AntonioSousa]

@Mike_L,

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

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

[Mike_L]

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.

[dannemca]

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

[Mike_L]

It needs to be the public hub: https://www.dynatrace.com/hub/detail/oracle-database/#release-notes

[carlos_carreno]

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 · Accepted solution]

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.

[Mike_L]

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_L]

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