Online Help for Administrators > Getting Started > Configuring and managing data collection > Managing collection from generic databases > Create a generic database connection

Create a generic database connection

  1. In the Administration Console, click Collection Configuration > Generic Database.
    The Generic Database page opens.
  2. Click Create New.
    The Connection Parameters dialog box opens.
  3. In the Connection Parameters dialog box, type the following values:

  4. 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 The name of the system where the collector is installed.
  5. Click OK.
  6. Click Save.

    A Saved Successfully message appears in the Information message panel.

Data collection for the newly created data source is enabled by default. In addition, the collection frequency is scheduled for every one hour.


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