Description

Simple BVD adapter for Microsoft SQL Database

Intro

This is a simple BVD integration adapter for MSSQL, which can be used to fetch information from your Microsoft SQL Database in real time and feed it into BVD. This adapter uses the Pymssql module in Python and sends the data in json format prepared to be fed to a BVD dashboard.

How to use ?

Download the adapter

Clone out of GitHub or simply copy&paste the content of both python files on your system.

Preparations needed

This adapter was developed for Python 3.5, but will probably work with all Python versions above as well. You need to have a Python interpreter and the pymssql module installed.In addition, once started, it will keep sending data to your BVD instance. You need to map this data to some of your dashboards.

Install ?

There is no need to install the adapter.

How to Configure

Edit sqlbvdConnector.py to modify the parameters as required for your local BVD setup and the credentials or connection details of the Microsoft SQL Database:Database connection information:

server = "10.23.67.30:1456"; # Add Server with IP to access the DB, Eg: 10.23.67.30:1456

user = "UserName" # Add Username Here Eg: sqladmin

password = "Password" # Password

Query Definition

Define the Query that needs to be executed for the appropriate data pull: ( Example query below to send all critical event count from OBM database)

cursor.execute('select count(ID) from ALL_EVENTS where severity = %s', 'CRITICAL')

Time in seconds before next query execution:

sleep = 35

URL and apiKey of your BVD instance:

bvdUrl = 'https://foo'

bvdApiKey = 'bar'

How to Run ?

#>python3 sqlbvdConnector.py

This will keep pulling the query result from your sql database in nearly real time (depending on your setting for sleep) and send it to your BVD instance. Now that you have data arrived at your BVD instance you can simply map it to your BVD dashboards.Note: The name is used as BVD dimension

DOWNLOAD FROM GITHUB

There is no need to install the adapter.

Download Link : https://github.com/MicroFocus/ColorYourData/tree/master/connectors/MSSQL2BVD

Contact info

For any feedback, Enhancement or query, email me @ any below

raoofpmajeed@gmail.com

Minimum Requirements

This adapter was developed for Python 3.5, but will probably work with all Python versions above as well. You need to have a Python interpreter and the pymssql module installed.In addition, once started, it will keep sending data to your BVD instance. You need to map this data to some of your dashboards.

Suggested apps

Suggested for you are based on app category, product compatibility, popularity, rating and newness. Some apps may not show based on entitlements. Learn more about entitlements.

Releases

Release
Date
BVD collector for MS SQL Database 1.0
Jan 30, 2019
More info Less info
Product compatibility
Version 10.10 · 10.11
Version 2017.08 · 2017.11
Version 2018.02
Version 2019.11
Release notes

See the description for details

Languages
English

Resources

Unsubscribe from notifications

You are receiving release updates for this item because you have subscribed to the following products:
If you unsubscribe, you will no longer receive any notifications for these products.
Tip: to update your subscription preferences, go to Manage Subscriptions from your Dashboard, uncheck the products you no longer want to receive notifications for, and click 'Save'.

Marketplace Terms of Service

In order to continue, you must accept the updated Marketplace Terms of Service
Since you are downloading an app from the OpenText Marketplace, you need to accept the updated Marketplace Terms of Service before you can continue. Use the link to review the Marketplace Terms of Service. Once complete check the, "I accept the Marketplace Terms of Service" box below and click accept to continue your download.


Your download has begun...

Your download has begun

Related content and resources

Your browser is not supported!

Please upgrade to one of the following broswers: Internet Explorer 11 (or greater) or the latest version of Chrome or Firefox

release-rel-2024-5-1-6148 | Wed May 8 00:58:25 PDT 2024