we've generated XML files using HPuCMDstage.exe file, So how can we upload them to a staging database?
I know that we can directly upload to the staging database by changing the method to stream want to understand if there is any way to upload XML's
Jan 12, 2023 11:48 PM
I am not sure if there is a way for that. I always considered the XML output just for quickly reviewing what results the uCMDB API provided.
For production, I always use the "stream" method to have the data put directly into a staging DB (from where the reader will consume it).
Jan 13, 2023 02:22 AM
Thanks for the reply
The reason I'm looking for this option is, we're allowed to take data from uCMDB only once or twice a day. So if we have got the option to upload XMLs to staging, it will help us to some extent for testing and reduce the load on uCMDB.
Jan 13, 2023 03:15 AM
As @mfranz mentioned you can use the XML files to review the data, However is there any particular reason you are importing HPUD data twice daily? My observation there is negligible impact on the HPUD server for the import and will hardly take a few seconds for the import.
You can you use the "prestaged" method to import the existing XML files to staging DB.
Jan 13, 2023 07:38 AM