SQL data source
Dynatrace provides you with a framework that you can use to extend your observability into data acquired from a database using SQL queries.
We assume the following:
- You possess sufficient database subject matter expertise to create an extension. In particular, you know how to build and execute SQL queries.
- You're familiar with Extensions 2.0 basic concepts and the general structure of the extension YAML file.
Learn about the prerequisites and scope of the supported technologies. For limits applying to your extension, see Extensions 2.0 limits.
Supported Dynatrace versions
- Dynatrace version 1.239+
- Environment ActiveGate version 1.237+
Supported database providers
- Oracle
- Standalone servers
- Multitenant (CDB/PDB)
- Database versions 12c-21c
- AWS RDS
- Microsoft SQL Server
- IBM DB2
- MySQL
- PostgreSQL
- SAP Hana
- Snowflake
Remote monitoring
The SQL data source supports remote database access using various authentication schemes. While basic authentication is supported, more advanced schemes such as Kerberos and NTLM are also supported for Microsoft SQL data source.
Create extension
-
See Oracle Database monitoring configuration to learn how to create an Oracle Database–specific monitoring configuration.
-
See Microsoft SQL Server monitoring configuration to learn how to create a Microsoft Database–specific monitoring configuration.
-
See IBM Database monitoring configuration to learn how to create an IBM Database–specific monitoring configuration.
-
See MySQL monitoring configuration to learn how to create a MySQL Database–specific monitoring configuration.
-
See PostgreSQL monitoring configuration to learn how to create a PostgreSQL Database–specific monitoring configuration.
-
See SAP Hana Database monitoring configuration to learn how to create a SAP Hana Database–specific monitoring configuration.
-
See Snowflake Database monitoring configuration to learn how to create a Snowflake Database–specific monitoring configuration.