topic Re: Ingest data from Database Oracle in Custom Solutions Spotlight

Ingest data from Database Oracle

dcappare — Mon, 31 Jan 2022 09:37:24 GMT

Hi all,

I need an information about the possibility to ingest some data from a database ORacle and built a custom metric on a specific column value.

I read more articles about the database performance monitoring but nothing about my question.

Thanks in advance for the support

Re: Ingest data from Database Oracle

AntonioSousa — Sat, 29 Jan 2022 21:46:43 GMT

You will have to do that with an extension or directly invoking the API. Completely doable.

Re: Ingest data from Database Oracle

AgniLanka — Sat, 29 Jan 2022 23:17:34 GMT

Which extension we are referring to?

Re: Ingest data from Database Oracle

dcappare — Sun, 30 Jan 2022 07:30:31 GMT

Thank Antonio,

can you indicate me about what extention are you talking about?

And about api do you refer about the api mention in this link:

https://www.dynatrace.com/support/help/how-to-use-dynatrace/databases/database-insights
It seems only for performance metric db.

Thanks for your support

Re: Ingest data from Database Oracle

AntonioSousa — Sun, 30 Jan 2022 11:40:42 GMT

Since you are trying to get and ingest some specific column value, you'll most probably have to develop some extension yourself.

But take a look first at:
https://www.dynatrace.com/hub/detail/custom-database-queries/

If that doesn't meet your needs, you might have to develop an extension. Take a look at a list of examples to get some ideas:
https://community.dynatrace.com/t5/Dynatrace-tips/Activegate-Extensions/m-p/113705

You might always take a look at https://github.com/NTTDATA-EMEA/dynatrace-sql-plugin to get some more ideas.

Re: Ingest data from Database Oracle

NicoleMT — Thu, 13 Nov 2025 20:42:04 GMT

HI @AntonioSousa ,
Currently, there is already an Informix extension available in Dynatrace, but it provides only very basic metrics. I would like to include additional Informix metrics (for example, fragment usage and checkpoint duration) to have more complete visibility of database performance.

Could you please advise what is the best way to achieve this?

Should I extend the existing Informix extension by adding new SQL queries and metrics definitions?
Or would it be better to create a separate custom extension to collect these additional metrics?
Is there an API-based alternative that could be used instead?

Any guidance or best practices on how to properly extend Informix monitoring in Dynatrace would be very helpful.

Thank you i