Custom Extension Creator - SQL Server stored proc

[barryla]

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.

[AravindhanV]

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