Question on external tool integration: API vs DB.

[yo_marc]

Hello Support team,

I am working on a project that will reference monitoring data in Nagios XI and display it on a custom reporting dashboard.

Does Nagios have a suggestion on whether customers ETL this data using the API, or through a database connection?

A Database ETL is easiest for us, so I am also curious to know if database table or field names changes ever take place during XI upgrades.

We would obviously have to perform our due-diligence during XI upgrades using either method... but any input would be greatly appreciated.

Thanks!
-marc

[scottwilkerson]

The recommended method would be to use the API.

That said you can use DB connections to the nagios database to get much of the info, however this may get much more tedious.

A Database ETL is easiest for us, so I am also curious to know if database table or field names changes ever take place during XI upgrades.

Not typically, however I not going to say never and put the developer in a box they cannot get out of. I will however say it would never be in a bugfix release, it would be part of an upgrade to the ndoutils backend.

[yo_marc]

That's very helpful, thank you!

I totally understand on the 'never say never' - If we go the DB route, I'll be sure to especially look out for ndoutil updates.

[bolson]

Closing topic as resolved.

Thank you for using the Nagios Support Forum.