Online Help for Administrators > Administration Console Screens > Generic Database

Generic Database

You can use the Generic Database page to configure generic databases from where you want to collect any type of data. This page is typically used to configure the Network Performance Server (NPS) to collect performance date from Network Node Manager i (NNMi). Using this page, you can schedule the data collection frequency, enable, or disable data collection, and also add or delete data collection connections based on your requirements.

Out-of-the-box, SHR supports configuration to generic data sources that use Oracle, Sybase, or Microsoft SQL Server database types. However, using this page, you can also configure SHR to connect to and collect data from other generic database types as well, such as MySQL, PostgreSQL, and so on. For a particular database type, you can specify the domain for which you want SHR to collect data such as system data, network data, and so on. For more information on how to configure such data sources, contact HP Support.

The Generic Database page includes:

Field Description
Host name IP address or FQDN of the generic database server.
Enable Collection Enable or disable data collection from a generic database.
Schedule Frequency Time (in hours) to synchronize the SHR database with the generic database.
Status

Status of an generic database connection and data collection.

Connection

Status of the generic database connection.

  • Indicates that the SHR host system is connected to the data source.
  • Indicates that the SHR host system is not connected to the data source.

Collection

Status of the collection showing the date and time of the latest collection attempt and the current status:

  • indicates that the data collection is in progress.
  • indicates that the data collection completed successfully in the previous attempt.
  • indicates that the data collection failed in the previous attempt.
  • indicates that the data collection was never started.
Configuration Modify an existing generic database connection.
Test Connection Test a generic database connection.
Delete Delete a generic database connection.
Create New

Create a new generic database connection.

Save Save specific generic database attributes.

Connection Parameters

Field Description
Host name IP address or FQDN of the generic database server.
Port Port number to query the database server.
TimeZone The time zone under which the database instance is configured.
Database type The type of database engine that is used to create the database. It can be Sybase IQ, Sybase ASE, Oracle, or MSSQL.
Domain Select the domain(s) for which you want SHR to collect data from the selected database type.
URL

The URL of the database instance. The syntax for the URL for each of the database types is:

  • Oracle: jdbc:oracle:thin:@<server>:<port>:<dbInstance>
  • MSSQL: jdbc:jtds:sqlserver://<server> <port>/<database>;instance=<dbInstance>
  • Sybase IQ: jdbc:sybase:Tds:<server>:<port>/<database>
  • Sybase ASE: jdbc:sybase:Tds:<server>:<port>?ServiceName=<dbInstance>

where <server>, <port>, <database>, and <dbInstance> are replaceable variables that must be filled by the user.

User name

Name of the generic database user.

Password

Password of the generic database user.

Collection Station This option is used for a collector installed on a remote system.

Use the Operations Manager page to:


© 2010 - 2013 Hewlett-Packard Development Company, L.P.