Ingest data from Database Oracle

[dcappare]

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

[AntonioSousa]

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

[AgniLanka]

Which extension we are referring to?

[dcappare]

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

[AntonioSousa · Accepted solution]

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.

[NicoleMT]

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