Page 1 of 1

Question on external tool integration: API vs DB.

Posted: Tue Aug 15, 2017 1:10 pm
by 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

Re: Question on external tool integration: API vs DB.

Posted: Tue Aug 15, 2017 2:22 pm
by 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.
yo_marc wrote: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.

Re: Question on external tool integration: API vs DB.

Posted: Thu Aug 17, 2017 1:10 pm
by 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.

Re: Question on external tool integration: API vs DB.

Posted: Thu Aug 17, 2017 1:21 pm
by bolson
Closing topic as resolved.

Thank you for using the Nagios Support Forum.