Ingestion the result of a query in a database

[Breno]

Hello,

I would like to know if it is possible to ingest data from the execution of a query in the database.

For example: select count(co_user) from tb_user

That way, I can put in a panel how many users there are in the tb_user table.

[PedroDeodato · Accepted solution]

Hey, @Breno ,

Short answer: Yes, it is 🙂

What you are describing is precisely the feature offered by the "Custom Database Queries" ActiveGate extension, available on the Dynatrace Hub!

On the description, you'll find:

"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."

and

"Example queries

• SELECT COUNT(*) FROM DAILY_PROCESSED_JOBS
• SELECT DEPARTMENT, EMPLOYEE_COUNT FROM DEPARTMENTS"

So, I'm pretty confident that it'll suit your needs!

Do check the documentation there on the Hub, as it is very helpful not just on Installation but also Configuration and getting it up & running to your desired use-case!

Hope this helps 😉 

[Breno]

Hi, @PedroDeodato 

Thank you!