How to Perform the SE Integration

This task includes the steps to perform SE-UCMDB integration.

1. Prerequisites.

   1. Configure database connection for the integration (PostgreSQL only)

      1. Download the latest JDBC driver for PostgreSQL from http://jdbc.postgresql.org/download.html (the package name is postgresql-9.3-1102.jdbc41.jar, for jdbc41) and place it on the UCMDB server in the following directory:

         <DataFlowProbe_Home>\runtime\probeManager\discoveryResources\db\postgresql

      2. Add the following line to the C:\HP\data\HPSEData\pg_hba.conf file on the SE PostgreSQL database server:

         host     all         report_user     all             trust

   2. Add the Storage Essentials server IP address to the Data Flow Probe IP ranges.

      In UCMDB, go to Data Flow Management > Data Flow Probe Setup. Choose the probe corresponding to the UCMDB server and add the IP address or the IP range of the SE database server (whether Oracle or PostgreSQL).

   3. Define credentials for the SE database (Oracle and/or PostgreSQL) using the Generic DB Protocol.

   4. Run the following jobs for Oracle and/or PostgreSQL:

      • For Oracle database, run one of the following sets of jobs to trigger SE discovery:

        • Set 1:

          • Network Infrastructure > Basic > Range IPs by ICMP (discovers the IP address of the SE server.)

          • Network Infrastructure > Host Connection > Host Connection by Shell/WMI/SNMP (discovers operating system information on the SE server)

          • Hosts and Resources > Basic Applications > Host Applications by Shell/SNMP/WMI (discovers the Oracle database instance used by SE)

          • Database > Oracle > Oracle Database Connection by SQL (discovers Oracle databases using the Generic DB Protocol (SQL))

        • Set 2:

          • Network Infrastructure > Basic > Range IPs by ICMP (discovers the IP address of the SE server)
          • Database > Oracle > Databases TCP Ports
          • Database > Oracle > Oracle Database Connection by SQL (discovers Oracle databases using the Generic DB Protocol (SQL))

      • For PostgreSQL database

        • Network Discovery > Basic > Class C IPs by ICMP (if we have provided single IP for the PostgreSQL server)

        • Network Infrastructure > Basic > Range IPs by ICMP (if we have provided range of IPs for the PostgreSQL server)
        • Database > PostgreSQL > Databases TCP Ports
        • Database > PostgreSQL > PostgreSQL Connection by SQL

2. Create a new integration point.

   For details on running integration jobs, see "Integration Studio" in the Universal CMDB Data Flow Management section of the UCMDB Online Help.

   1. Provide a name and description for the integration point.

   2. Under Integration Properties > Adapter, select the Storage Essentials adapter.

   3. Under Adapter Properties > Data Flow Probe, select the Data Flow Probe.

   4. Under Adapter Properties >Trigger CI instance select:

   1. Select Existing CI (if you have a valid, existing CI). The Select Existing CI pane appears. Select the CI or
   2. Create New CI (if you need to create a new CI). The Topology CI Creation Wizard appears. Complete the creation of the CI using the Wizard.

   Note For details on the Topology CI Creation Wizard, see "Topology CI Creation Wizard" in the Universal CMDB Data Flow Management section of the UCMDB Online Help.

   5. Verify the credentials for the chosen CI instance. Right-click Trigger CI instance and select Actions > Edit Credentials Information.

   6. Save the integration point.

3. Run the Storage Essentials job.