# Custom Database Query

**URL:** <https://community.dynatrace.com/t/custom-database-query/38922>\
**Category:** Extensions\
**Tags:** databases, extensions\
**Created:** [March 21, 2023, 9:29am UTC](https://community.dynatrace.com/t/custom-database-query/38922 "2023-03-21T09:29:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![mizso74](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mizso74/32/41729_2.png) [@mizso74](https://community.dynatrace.com/u/mizso74)\
**Post date:** [March 21, 2023, 9:29am UTC](https://community.dynatrace.com/t/custom-database-query/38922/1 "2023-03-21T09:29:29Z")

</div>

Hi&nbsp;[@Mike\_L](https://community.dynatrace.com/user/11520),

Is there any plan to upgrade the custom DB query to extension 2.0 framework?

Thanks in advance for your replay.

Best regards,

Mizső

---

<div class="post-metadata">

**Author:** ![jegron](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/jegron/32/12797_2.png) [@jegron](https://community.dynatrace.com/u/jegron)\
**Post date:** [March 21, 2023, 11:32am UTC](https://community.dynatrace.com/t/custom-database-query/38922/2 "2023-03-21T11:32:11Z")

</div>

Hello&nbsp;[@Mizső](https://community.dynatrace.com/user/47783)&nbsp;,

I am looking for too. I have several stored procedure to run with Framework 2.0.

For your information, you can run custom Extension 2.0 for MSSQL and Oracle :

> **[SQL data source reference](https://docs.dynatrace.com/docs/ingest-from/extensions/develop-your-extensions/data-sources/sql/sql-reference)**
>
> Learn about SQL extensions in the Extensions framework.

This limits applies :

- _Only SELECT queries are available_
  - _MySQL queries can also begin with SHOW GLOBAL STATUS_

- _Only one query can be executed at a time_
- _Queries containing comments are rejected_
- _To prevent data integrity violations (manipulating, changing, or deleting data), the SQL data source executes the queries in rolled-back transactions. For this reason, databases that don’t support transactions are not supported as a SQL data source._

Also there is already this following datasources in the schema :

“sqlOracle”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json” --\>&nbsp;[Oracle Database monitoring configuration — Dynatrace Docs](https://www.dynatrace.com/support/help/extend-dynatrace/extensions20/data-sources/sql/oracle-monitoring)&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; “sqlServer”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json”&nbsp;--\>&nbsp;[Microsoft SQL Server monitoring configuration — Dynatrace Docs](https://www.dynatrace.com/support/help/extend-dynatrace/extensions20/data-sources/sql/microsoft-sql-monitoring)&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; “sqlPostgres”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json”&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; “sqlMySql”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json”&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; “sqlSnowflake”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json”&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; “sqlHana”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json”&nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; “sqlDb2”: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; “$ref”: “sql.schema.json”&nbsp; &nbsp; &nbsp; &nbsp; },

---

<div class="post-metadata">

**Author:** ![mizso74](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mizso74/32/41729_2.png) [@mizso74](https://community.dynatrace.com/u/mizso74)\
**Post date:** [March 21, 2023, 12:27pm UTC](https://community.dynatrace.com/t/custom-database-query/38922/3 "2023-03-21T12:27:22Z")

</div>

Hi&nbsp;[@jegron](https://community.dynatrace.com/user/47129),

Thanks very much for share this information. We are going to test the Oracle extension.

Best regards,

János
