CI and CI relationship push using Python Script Directly to MS SQL Database

Mohammed Hussain 3 months ago

I am creating an external python script to directly push CIs and CI relationships in JSON object (called via uCMDB REST calls) to tables in MS SQL database like (Node-->running software), (Node-->installed software) May i know how can i achieve this as i also need to have a logic in script to only push delta sync (changes, additions or deletions ) post full Insert is done. (INSERT/UPDATE ) in database. Please help how i can use this in case of CI and CI relationship push to database using a python script.

Tags:

Python

Discovery

uCMDB

rest

Top Replies

Keith_Paschal 3 months ago +1 suggested

Mohammed; You're getting JSON out of the REST API in UCMDB and trying to deserialize that and stuff it into a MSSQL database? So, you're making a copy of the UCMDB database and creating your own schema…

Suggested Answer

0 Keith_Paschal 3 months ago

Mohammed;

You're getting JSON out of the REST API in UCMDB and trying to deserialize that and stuff it into a MSSQL database? So, you're making a copy of the UCMDB database and creating your own schema to do so? You would have to make sure you handle some relationship table along with individual CI tables. Can I ask what your use case is for doing this? (It sounds like you're building your own UCMDB database from the JSON output from the REST API in UCMDB, which would be very complicated, at best.

-- Hope this helps!

Keith Paschal

UCMDB Worldwide Support Lead
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 lukaspl 2 months ago

You should check this:

docs.microfocus.com/.../PushAdptOvrvw
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Menu

Universal Discovery & CMDB

CI and CI relationship push using Python Script Directly to MS SQL Database

Tags:

Top Replies

Suggested Answer

Resources