topic Re: Ingestion the result of a query in a database in Open Q&A

Ingestion the result of a query in a database

Breno — Wed, 02 Nov 2022 09:42:30 GMT

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.

Re: Ingestion the result of a query in a database

PedroDeodato — Mon, 31 Oct 2022 17:21:52 GMT

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 😉

Re: Ingestion the result of a query in a database

Breno — Mon, 31 Oct 2022 17:24:07 GMT

Hi, @PedroDeodato

Thank you!