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

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>

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

<Please see attached file for image>

 
Test the results to ensure that it is retrieving the data required:

<Please see attached file for 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>

 
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>

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

<Please see attached file for 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>

 

Additional Information:

 

See the probe guide for more information. 

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

 

Environment

Release:
Component: CAUIM