Updating XI data programmatically
Posted: Tue Nov 15, 2016 7:03 am
Hi guys,
I have a couple of requirements to update data in XI that from what I can tell cannot be easily done within the UI, for example I want to update the host X/Y coordinates by calling an external API which will return location data when supplied with a hostname/IP, or I want to create some custom variables for hosts etc. At a couple of hundred hosts and needing to refresh this data fairly regularly I think the best way to do this is with an external script that runs on the XI server and writes the data into XI somehow, so my question is what is the best way to do this?
We're on 2014R2.7 at the moment so do not have access to the new APIs, but if that is the mest solution we could certainly upgrade. So I guess the options are write to the config files themselves, but not sure if XI will overwrite those changes and of course dealing with files isn't the cleanest. Then I guess we could write to the mySQL tables that XI is based on.
Any thoughts/suggestions?
I have a couple of requirements to update data in XI that from what I can tell cannot be easily done within the UI, for example I want to update the host X/Y coordinates by calling an external API which will return location data when supplied with a hostname/IP, or I want to create some custom variables for hosts etc. At a couple of hundred hosts and needing to refresh this data fairly regularly I think the best way to do this is with an external script that runs on the XI server and writes the data into XI somehow, so my question is what is the best way to do this?
We're on 2014R2.7 at the moment so do not have access to the new APIs, but if that is the mest solution we could certainly upgrade. So I guess the options are write to the config files themselves, but not sure if XI will overwrite those changes and of course dealing with files isn't the cleanest. Then I guess we could write to the mySQL tables that XI is based on.
Any thoughts/suggestions?