topic Execute SQL queries on notebook in Automations

Execute SQL queries on notebook

soportetr — Thu, 04 Jul 2024 08:37:17 GMT

Hello everyone,

Is it possible to execute SQL queries on Dynatrace notebooks using the add code option?

If so, does anyone have any guide or example of doing so?

Thanks in advance

Re: Execute SQL queries on notebook

christian_kreuz — Mon, 13 May 2024 07:35:20 GMT

You could integrate with an external API via JavaScript and fetch - see https://docs.dynatrace.com/docs/observe-and-explore/dashboards-and-notebooks/dashboards-new/components/dashboard-component-code#example-1-simple-request-and-response-to-table for details.

Re: Execute SQL queries on notebook

soportetr — Tue, 28 May 2024 16:53:09 GMT

Hi @christian_kreuz,

And will there be any possibility to make the connection to any database (MySql, SQL Server, Oracle...) using this option?

Re: Execute SQL queries on notebook

christian_kreuz — Wed, 29 May 2024 07:44:23 GMT

Hi!

Our supported interface is HTTP(s) calls. Direct access to Databases is only possible only if the database-management-system offers you a HTTP/REST endpoint (or if you provide such an endpoint for your database yourself).

This is not specific to Dynatrace or functions though.