MSSQL 2.0 Extensions with Dynatrace

mannepalli — Wed, 18 Sep 2024 13:39:49 GMT

I am tasked with developing a custom extension for Microsoft SQL Server 2.0 to facilitate data retrieval and visualization for a project. The objective is to execute specific queries to extract data into Dynatrace and subsequently analyze and present the information through interactive dashboards. I kindly request your assistance in creating this extension. If there are any comprehensive video tutorials or detailed documentation available that can guide me through the process, please provide me with the necessary resources. Your support in this matter would be greatly appreciated.

Re: MSSQL 2.0 Extensions with Dynatrace

Fin_Ubels — Thu, 19 Sep 2024 02:48:25 GMT

Hey Mannepalli,

For creating custom Dynatrace extensions there is extensive documentation available here https://docs.dynatrace.com/docs/extend-dynatrace/extensions20. Under that page there are a few key areas of interest that would be most relevant for you.

Extension YAML structure: https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/extension-yaml
Additional MSSQL info: https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/sql/microsoft-sql-monitoring
General SQL reference: https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/sql/sql-reference
Custom extension tutorial, it's for a WMI extension but a lot of the same still applies: https://docs.dynatrace.com/docs/extend-dynatrace/extensions20/data-sources/wmi-extensions/wmi-tutorial

Additionally there should be a custom extension creator app that currently focuses on SQL based extensions. This should allow for much easier setup and creation of an SQL based custom extension. This can be found in the hub as seen below.

Of the above I would start with the WMI extension tutorial to understand the general process and structure of what you are creating, and then from there I would look into the custom extension creator app and additional documentation provided.

Hope this helps!

topic MSSQL 2.0 Extensions with Dynatrace in Extensions

MSSQL 2.0 Extensions with Dynatrace

Re: MSSQL 2.0 Extensions with Dynatrace