How to Define Data Push Jobs in UCMDB

Data push jobs copy CI or CI Relationship records from your UCMDB system to your Service Manager system.

To define a CI or CI relationship push job, follow these steps:

1. Log in to UCMDB as an administrator.
2. Navigate to Data Flow Management > Integration Studio. UCMDB displays a list of existing integration points.
3. Select the Integration Point that you created for Service Manager. For example, sm_integration.
4. Click the Data Push tab.
5. Follow these steps to add a new data push job:
   1. Click the New Integration Job icon .

   Note UCMDB creates a default data push job when creating an integration point. The following table lists the default data push job and its queries. If needed, you can create, update, or remove queries for the push job. To access these out-of-the-box queries for push, go to Modeling > Modeling Studio > Resources, select Queries for Resource Type, and then navigate to Root > Integration > Service Manager > Push. For information about tailoring data push queries, see How to Create a Query to Synchronize the CI Type.

   Queries for CI / CI Relationship Push

   Integration job	Queries
   Integration job	Queries
   SM Push job	Out-of-the-box, the following queries are available for this job, which pushes CI records from UCMDB to Service Manager: SM Mainframe Push 2.0: pushes CIs of the mainframe type. SM Business Element Push 2.0: pushes CIs of the business application, and infrastructure service types SM Network Component Push 2.0: pushes CIs of the network component type. SM Running Software Push 2.0: pushes CIs of the running software type. SM Business Service Push 2.0: pushes CIs of the business service type. SM Computer Push 2.0: pushes CIs of the computer type. SM Storage Push 2.0: pushes CIs of the storage type. SM Switch Push 2.0: pushes CIs of the switch type. SM Net Printer Push 2.0: pushes CIs of the net printer type. SM Cluster Push 2.0: pushes CIs of the cluster type. SM Mobile Device Push 2.0: pushes CIs of the mobile device type. SM Local Printer Push 2.0: pushes CIs of the local printer type. Out-of-the-box, the following queries are available for this job, which pushes CI Relationship records from UCMDB to Service Manager: SM Layer2 Topology Relations Push 2.0: pushes compound CI relationships between nodes. SM Business Service Relations Push 2.0: pushes CI relationships whose upstream CI type is business service. SM CRG Relations Push 2.0: pushes CI relationships whose upstream CI type is cluster. SM Node Relations Push 2.0: pushes direct CI relationships whose upstream CI type is node.

   2. In the Name field, type a unique name for the job. For example, CI_Push_Job1.
   3. Click the Add Query icon to add existing queries to the job.
   4. Select the Allow Integration Job to delete removed data option for each query.
   5. Click OK to save the job.
6. Run the job manually to verify that the integration job works properly.

   Caution If you have a huge amount of CI data in your UCMDB system, and this is your first time to push CI /CI Relationship data to Service Manager, it is recommended to select the “Add the record” option instead of “Open a change” or “Open an incident” for “Action if matching record does not exist” in each Discovery Event Manager Rules definition. Failure to do so may cause unnecessary performance problems. For details, see How to Add Discovery Event Manager Rules.

   1. To push all relevant data for the job, click the icon.
   2. To push only data that was changed since the job last ran, click the icon.

   Tip You can stop a running push job by pressing the Stops the selected job icon .

7. Wait for the job to complete, and click the Refresh icon multiple times as needed until the job is completed.

   Note When the job is completed, the job status becomes one of the following depending on the results: Completed successfully, Completed, or Failed.

8. Click the Statistics tab to view the results; if any errors occur click the Query Status tab and Job Errors tab for more information. For details, see Troubleshooting Data Push Issues.
9. Click OK.

If the job is completed successfully, you can view the UCMDB CI data in Service Manager, and schedule the job so that it can run automatically.