Possibility to visualize data in postgress by querying

[Jomon]

Hi i am new to dynatrace. Actually I was using grafana before for monitoring purposes. In dynatrace is there is any option to view data from a postgres table by using sql queries. As of now i could able to find the performance metrices of postgres

[Julius_Loman · Accepted solution]

Hi!

welcome to Dynatrace 🙂 Sure there are options for both.

For metrics - just use this extension 2.0 - https://www.dynatrace.com/hub/detail/postgresdb-remote-monitoring/
For data collected using queries defined by you, you can use this extension https://www.dynatrace.com/hub/detail/custom-database-queries/ or you can create your own Extension 2.0 using the Postgres SQL data source - see more here https://www.dynatrace.com/support/help/shortlink/extensions20

[Jomon]

I have received the above error while establishing the postgres connection. What could be the reason? The Dynatrace Token which i have provided is taken from the 'Access token' tab from settings and with API v2 scope type.

[Julius_Loman]

Please check the log files on the activegate. Did you also unzip the extension on the activegate?