imported>Jason.nicholls: 1 revision

2015-04-30T10:59:29Z

1 revision

← Older revision	Revision as of 10:59, 30 April 2015
(No difference)

imported>Jason.nicholls: /* Query */

2015-01-06T07:57:46Z

Query

New page

{{DISPLAYTITLE:Netcool/OMNIbus Data Adapter}}
[[Category:AppBoard 2.6]]
This page provides details for configuring IBM Tivoli Netcool/OMNIbus adapters in AppBoard. This data adapter retrieves information directly from an OMNIbus ObjectServer.

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 [[appboard/2.6/builder/shim_expressions|SHIM Expressions]].

{{Note|This data adapter requires the Sybase jConnect 5.5 (jconn2.jar) for JDBC database driver - see the [[appboard/2.6/admin/db_drivers|Loading Database Drivers]] page for more information.}}

== Data Source Configuration ==

=== Configure Connection Settings ===

The table below details the settings you can configure for a <b>Tivoli Netcool/OMNIbus</b> Data Source:

{|class="wikitable"
!Name
!Description
|-
|'''Timeout'''
|The maximum duration (in seconds) to establish a successful connection. Setting this value too low, in the case where OMNIbus cannot service the connections fast enough, will result in degraded performance.
|-
|'''Username'''
|User name credential used to connect to database.
|-
|'''Password'''
|User password credential used to connect to database.
|-
|'''Host'''
| The hostname or IP address referring to the Netcool/OMNIbus database.
|-
|'''Port'''
| The TCP port of the Netcool/OMNIbus database. Default value is <tt>4100</tt>.
|-
|'''Database Name'''
| The name of the Netcool/OMNIbus database. Default value: <tt>NCOMS</tt>
|}

=== 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.

{{Note|When creating a new adapter, or upgrading an existing adapter from a previous version of AppBoard the <tt>alertsstatus</tt> entity is protected and cannot be renamed.}}

<b>Queries - Entity Settings</b> Screen:

{|class="wikitable"
!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.
|-
|'''Query Timeout (seconds)'''
|Maximum time (in seconds) to wait before timing out an executing SQL query. By default this is not set and the global default applies (see <tt>appboard.jdbc.queryTimeout</tt> in appboard.config). To disable the timeout set the value to zero, or to override the global default set to a positive value. Note: this option uses a feature of the JDBC driver and whether it is supported and the actual behaviour will depend on the driver.
|-
|'''[[appboard/2.6/builder/caching_and_polling|Cache Timeout (seconds)]]'''
|Maximum time (in seconds) a response from the database is kept before discarding and re-querying for new data. If set to zero then no caching is performed at all.
|-
|'''SQL Query'''
|SQL statement defining the records to be returned by the query.
|-
|'''[[appboard/2.6/builder/data_processing_scripts|Data Processing Script(s)]]'''
|List of one or more Data Processing Scripts to be run on the query.
|}

Appboard/2.6/builder/data sources/third party/omnibus - Revision history

imported>Jason.nicholls: 1 revision

imported>Jason.nicholls: /* Query */