Custom Extension Creator - SQL Server stored proc

barryla — Tue, 10 Feb 2026 07:53:32 GMT

Has anyone been able to execute a SQL Server stored procedure as part of query that need to be added to the custom extensions creator?

When I add the EXEC sql_storeproc command, it says that the statement need to start with a SELECT, although, the stored proc returns a set of information.

Re: Custom Extension Creator - SQL Server stored proc

AravindhanV — Thu, 26 Feb 2026 08:25:31 GMT

Dynatrace does not allow EXEC stored procedures in Extensions 2.0 because:

Only SELECT is permitted (for security & safety)
Stored procedures are unpredictable for metric ingestion
The extension framework is strictly read‑only

EXEC will return the multiple result set which may cause the metric flooding and along with it will create the unbound access to Backend systems.

With the security constraint being considered, INSERT, DELETE, UPDATE along with EXEC is not allowed and only SELECT is allowed.

Thanks

topic Custom Extension Creator - SQL Server stored proc in Extensions

Custom Extension Creator - SQL Server stored proc

Re: Custom Extension Creator - SQL Server stored proc