How to Push Data from UCMDB to Executive Scorecard

1. Prerequisite - Set up Executive Scorecard

   Perform the steps "Activate the Integration" and "Connect to UCMDB on a Secured Connection" as described in the Executive Scorecard manual Content Reference Guide for the Integration with Universal Configuration Management Database.

2. Prerequisite - Ensure that the push adapter package has been deployed

   Note If you have installed UCMDB version 10.10 or later with CP14, the push adapter package is installed by default. You can skip this step.

   1. In UCMDB, go to Data Flow Management > Adapter Management.
   2. In the Resources pane, search for XSAdapter.
3. Create an integration point

   1. Complete the integration and adapter properties fields as shown in the following table:

      Field	Required	Description
      Integration Properties
      Integration Name	Yes	Enter a unique name for the integration point.
      Integration Description	No	Enter a description of the current integration point.
      Adapter	Yes	Click the button and select HP Software Products / Micro Focus Products > Executive Scorecard > Executive Scorecard.
      Is Integration Activated	Yes	Select this check box to create an active integration point. You clear the check box if you want to deactivate an integration, for instance, to set up an integration point without actually connecting to a remote machine.
      Adapter Properties
      Hostname/IP	Yes	The hostname or IP Address of the Executive Scorecard database.
      Port	Yes	1433 (the communication port of the Executive Scorecard database).
      Database	Yes	The staging database name of the Data Warehouse in Executive Scorecard.
      Schema	Yes	dws (the name of the database schema).
      Credentials ID	Yes	Do the following: Click the button. Select Generic DB Protocol (SQL) and click OK. Click the button to add new credentials. Enter the following information: Database Type: Select Microsoft SQL Server. Port Number: Leave the default value (1433). Connection Timeout: Leave the default value (20000). User Name and Password: Enter the user name and password for connecting to the Executive Scorecard Data Warehouse database. When finished, click OK.
      Data Flow Probe	Yes	The name of the Data Flow Probe on which the integration runs. Select a Data Flow Probe whose range includes the IP address of the Executive Scorecard database.
      Additional Probes	No	Select additional probes to use when pushing to AM in order to increase redundancy.

      For details about how to create an integration point, see "How to Set Up an Integration Point" in the Data Flow Management section of the UCMDB Help.

   2. Click OK.

   3. Click Test Connection. If the connection fails, verify that the information provided is correct.

   4. Click OK to close the dialog box and return to the Integration Studio.
4. Edit the existing integration job (optional)

   A default integration job called XS Push job is created when you create an integration point using the Executive Scorecard adapter. You can edit this job to change the default queries or the job's schedule.

   1. Select the integration point that you created in step 4 and click XS Push job.

   2. Click .
   3. Update the TQL queries listed or schedule as required.
   4. When you are finished, click OK.
5. Run the job

   1. In the Integration Studio, select the integration point that you created in step 4.
   2. Select XS Push job and click to run a full synchronization.