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.
|
Collection |
Status of the collection showing the date and time of the latest collection attempt and the current status:
|
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. |
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:
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: