Extend the platform, empower your team.
Make generic databases queries and send the data to Dynatrace as metrics.
This Activegate custom extension allows you to run queries against Oracle, MSSQL, MySQL, DB2, PostgreSQL, Informix or SAP HANA databases and send the results back to Dynatrace as metrics.
You can use this extension to bring in business data, job processing metrics, database and table statistics, anything that is stored in your Databases.
SELECT COUNT(*) FROM DAILY_PROCESSED_JOBS
SELECT DEPARTMENT, EMPLOYEE_COUNT FROM DEPARTMENTS
This extension utilizes JDBC to connect to the different databases, here are the versions of the JDBC drivers we utilize, please refer to the JDBC driver documentation regarding the database version they support.
There are two steps to install an Activegate extension:
Environment Activegate server - Extract the extension zip file to the plugin_deployment folder of the remote plugin module
unzip -o -d /opt/dynatrace/remotepluginmodule/plugin_deployment custom.remote.python.dbquery.zip
(Optional) For SAP HANA, place the ngdbc-2.14.7.jar file in the ../plugin_deployment/custom.remote.python.dbquery/jars/ directory.
Browser - Upload custom.remote.python.dbquery.zip file to your tenant
Settings > Monitored technologies > Custom extensions > Upload extension
Create an Endpoint for every database you would like to query.
This is done in Settings > Monitored technologies > Custom extensions > Generic DB Query Plugin
Settings > Monitored technologies > Custom extensions > Generic DB Query Plugin
You can run up to 10 queries at a time, to run more than 10 queries, create more endpoints for the same database.
The parameters are:
Dynatrace API Token
Api V2 - Metric Ingest
Custom device name
Oracle listener type
(Optional) JDBC - Connection String
(Optional) Java path
(Optional) Java extra arguments
Query (1-10) - Name
Query (1-10) - Query string
SELECT COUNT(*) FROM JOBS
SELECT JOB_ID, DURATION, STATUS FROM JOBS
(Optional) Query (1-10) - Schedule
(Optional) Query (1-10) - Value columns
(Optional) Query (1-10) - Dimension columns
(Optional) Query (1-10) - Extra dimensions
The data is sent using our Metric Ingest API, so you need to use the Data Explorer to create charts.
The metric name is always custom.db.query, the different queries are accessed via the Query Name dimension
If Send Statistics was enabled, you can also monitor your queries with the metrics:
Any errors running the queries will also be sent to this Custom Device as CUSTOM_INFO_EVENTS
Data management products, including database servers, developed by IBM.
Remotely monitor your Informix databases and get insight into crucial Informix metrics.
Automatically and intelligently observe, analyze and optimize how your the usage, health and performance of your database.
Observe, analyze and optimize the usage, health and performance of your database
No release notes
This solves several issues with metrics being reported out of schedules, metrics are reported strictly after they are queried from the Database
Metrics are always sent to the local Activegate for security reasons. If you need to send metrics to a different environment than where the AG is connected to, please stick to 3.2.9
This option was barely used, and needed to be removed to solve scheduling issues. If you need to use this option please stick to 3.2.9
If the java process emits any log lines on those levels, they are sent as Custom Events to Dynatrace
The data can still be found in the extension log files if required for troubleshooting.
Allow users to set extra jvm args such as -Xmx60m