Edge Documentation

This page provides details for configuring Netcool/Omnibus adapters in AppBoard. For information on creating the database adapter, or other AppBoard adapters, see AppBoard Data Sources

This adapter retrieves data from a Netcool/Omnibus database using SQL queries to create a data set. This is frequently used to transform data through the use of SQL to prepare data for use in AppBoard.

In many cases, you will want to pass a parameter value into a query rather than using a static query definition. AppBoard provides a system of variable expressions, called SHIM, that can be used for this purpose. For instructions on this option, see SHIM Expressions.

Database Data Source Configuration

Configure Database Connection Settings

The table below details the settings you can configure for a Tivoli Netcool/Omnibus Data Source:

Name	Description
host	The hostname or IP address referring to the Netcool/Omnibus database.
port	The TCP port of the Netcool/Omnibus database.
dbname	The name of the Netcool/Omnibus database. Default:"NCOMS"
connectTimeout	Time (in seconds) after a timeout occurs to wait before attempting to re-establish the connection. Setting this value too low can impact the performance of the system.
timeout	Time to wait (in seconds) before timing out on connecting to the datasource. If there is latency between AppBoard and the database, due to network configuration, this value may need to be increased.
username	User name credential used to connect to database.
password	User password credential used to connect to database.

Query

You can configure one or more queries in each Netcool/Omnibus adapter configuration. Each configured query will have a different name, and result in a different Data Collection with that name. When naming a query, only alphanumeric characters, underscores, and hyphens are permitted.

Queries - Entity Settings Screen:

Name	Description
Name	Name of this SQL query entity. Note: if editing the name all references internal to AppBoard are updated automatically, however in some cases Data Processing Scripts may have hardcoded references that will break as a result of the rename. In cases where AppBoard can detect this an error message is presented to the administrator identifying the affected scripts.
Description	A summary of the purpose of the query and any details or notes to provide for the system administrator
Cache Timeout (seconds)	Maximum time a response from the database is kept before discarding.
SQL Query	SQL statement defining the records to be returned by the query
Data Processing Script(s)	List of one or more Data Processing Scripts to be run on the query.