topic Migrate 'Generic DB Query Plugin' to extension 2.0 in Extensions

Custom Query Extension 2.0. Can I borrow yours?

dannemca — Tue, 05 Dec 2023 08:17:49 GMT

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

Re: Custom Query Extension 2.0. Can I borrow yours?

Mike_L — Mon, 04 Dec 2023 14:27:34 GMT

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.

Re: Custom Query Extension 2.0. Can I borrow yours?

AntonioSousa — Mon, 04 Dec 2023 15:09:45 GMT

@Mike_L,

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

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

Re: Custom Query Extension 2.0. Can I borrow yours?

Mike_L — Mon, 04 Dec 2023 15:33:46 GMT

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.

Re: Custom Query Extension 2.0. Can I borrow yours?

dannemca — Mon, 04 Dec 2023 18:16:41 GMT

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

Re: Custom Query Extension 2.0. Can I borrow yours?

Mike_L — Mon, 04 Dec 2023 18:49:44 GMT

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

Migrate 'Generic DB Query Plugin' to extension 2.0

carlos_carreno — Fri, 19 Jan 2024 19:49:35 GMT

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.

Re: Custom Query Extension 2.0. Can I borrow yours?

dannemca — Thu, 29 Feb 2024 16:57:03 GMT

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.

Re: Custom Query Extension 2.0. Can I borrow yours?

Mike_L — Thu, 29 Feb 2024 17:34:39 GMT

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!

Re: Custom Query Extension 2.0. Can I borrow yours?

Mike_L — Fri, 01 Mar 2024 20:29:45 GMT

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