Custom Database Query

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ő

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 :

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”: {            “$ref”: “sql.schema.json” --> Oracle Database monitoring configuration — Dynatrace Docs        },        “sqlServer”: {            “$ref”: “sql.schema.json” --> Microsoft SQL Server monitoring configuration — Dynatrace Docs        },        “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”        },

Hi @jegron,

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

Best regards,

János