MSSQL 2.0 Extensions with Dynatrace

[mannepalli]

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.

[Fin_Ubels · Accepted solution]

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-monitor...
• 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-tutori... 

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!