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.