How do I store Nimsoft collected data in an external database?

book

Article ID: 34992

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

Introduction

 The adogtw probe  (ADO Database Gateway) can be used in a number of ways -- in this example it will be used to query a database and publish the information on the Nimsoft Bus with a specific Subject. The Information will then travel across the Bus to the Central Hub at which point another copy of the adogtw will be subscribed to the Subject. The Message will then be taken off the Bus and written to another database.
 

Background:  

Sometimes you need to send data to another database. You could either have the external database run sql statements to access the data in the nimsoft database on a regular basis or you can have UIM send the data to the external database on a regular basis. 

Environment:  

 

Any version of UIM.

Instructions:

Follow this procedure:

Create a Publisher profile and specify what database to connect to, and how often the Profile is to run:

<Please see attached file for image>

User-added image

  Run a simple SQL query or a long query that can be stored in a SQL script file:

<Please see attached file for image>

User-added image
 
Test the results to ensure that it is retrieving the data required:

<Please see attached file for image>

User-added image
 

Publish a message onto the Nimsoft bus with the Subject “DB_Info” and associate the SQL query column names with Nimsoft variables that are also part of the message:

<Please see attached file for image>

User-added image
 
The Profile will run at the frequency specified and post a message onto the BUS.
The message then travels on the BUS from the Server that ran the test to the Primary Nimsoft Hub.
Here we can see the message on the bus, with the subject and the user data (udata) specified:

<Please see attached file for image>

User-added image

Create a Subscriber profile and specify what database connection to use for writing the data to:
 

<Please see attached file for image>

User-added image
 
Specify what subject the adogtw is to look for on the Bus. When found, write the data to the configured table and fields:
 

<Please see attached file for image>

User-added image

 

Additional Information:

 

See the probe guide for more information. 

https://docops.ca.com/ca-unified-infrastructure-management-probes/en

 

Environment

Release:
Component: CAUIM

Attachments

1558722450268000034992_sktwi1f5rjvs16wg1.jpeg get_app
1558722448369000034992_sktwi1f5rjvs16wg0.jpeg get_app
1558722446237000034992_sktwi1f5rjvs16wfz.jpeg get_app
1558722444168000034992_sktwi1f5rjvs16wfy.jpeg get_app
1558722441450000034992_sktwi1f5rjvs16wfx.jpeg get_app
1558722439379000034992_sktwi1f5rjvs16wfw.jpeg get_app
1558722437326000034992_sktwi1f5rjvs16wfv.jpeg get_app