cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Custom DB query

Mizső
DynaMight Leader
DynaMight Leader

Hi @Mike_L,

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

Thanks in advance for your replay.

Best regards,

Mizső

Dynatrace Community RockStar 2024, Certified Dynatrace Professional
2 REPLIES 2

jegron
DynaMight Champion
DynaMight Champion

Hello @Mizső ,

 

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 : 

https://www.dynatrace.com/support/help/extend-dynatrace/extensions20/data-sources/sql/sql-reference

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": {
        },
        "sqlServer": {
        },
        "sqlPostgres": {
            "$ref": "sql.schema.json"
        },
        "sqlMySql": {
            "$ref": "sql.schema.json"
        },
        "sqlSnowflake": {
            "$ref": "sql.schema.json"
        },
        "sqlHana": {
            "$ref": "sql.schema.json"
        },
        "sqlDb2": {
            "$ref": "sql.schema.json"
        },
 
 
Observability Engineer at Phenisys - Dynatrace Professional

Mizső
DynaMight Leader
DynaMight Leader

Hi @jegron,

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

Best regards,

János

Dynatrace Community RockStar 2024, Certified Dynatrace Professional

Featured Posts