How to Define Population Jobs in UCMDB

A CI/CI relationship population job copies certain types of CIs/CI relationships from Service Manager to UCMDB.

To define a CI or CI relationship population job:

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. Open an integration point.
4. Click the Population tab, and add a new job as follows.

   Note UCMDB creates several default population and data push jobs when creating an integration point. The following table lists the default population jobs and their queries. If needed, you can create, update or remove queries for each job. For information about tailoring population queries, see Create a Query to Populate the CI Type.

   Queries for CI / CI relationship population

   Integration Job	Queries for CI / CI relationship population
   SM Configuration Item Population job	Out-of-the-box, the following queries are available for this job, which populates CI records from Service Manager to UCMDB: SM Business Service Population: Populates CIs of the bizservice type. SM RunningSoftware Population: Populates CIs of the RunningSoftware type. SM Computer Population: Populates CIs of the computer type.
   SM Relations Population job	Out-of-the-box, the following queries are defined for this job, which populates CI Relationship records from Service Manager to UCMDB: SM Biz To Biz With Containment: Populates CI relationships in which a bizservice CI contains another. SM Biz To Biz With Usage: Populates CI relationships in which a bizservice CI uses another. SM Biz To Computer With Containment: Populates CI relationships in which a bizservice CI contains a computer CI. SM Biz To Computer With Usage: Populates CI relationships in which a bizservice CI uses a computer CI. SM Computer To Computer With Connects: Populates CI relationships in which a computer CI connects to another.

   1. Click the New Integration Job button .
   2. Type a Name for the integration job. For example, CI_Population_Job1.
   3. Click the Add Query button to add existing queries to the job (see the above table).
   4. Select the Allow Integration Job to delete removed data check box for the query.
   5. Click OK to save the job.
5. Run the job manually to see if the integration job works properly.
   1. To populate all relevant data for the job, click the button.
   2. To populate only CI data changes since the job last ran, click the button.
6. Wait for the job to complete, and click the Refresh button multiple times as needed until the job is completed.

   Note When the job is completed, the job status becomes one of the following: Succeeded, Passed with failures, or Failed.

7. Click the Statistics tab to view the results, and if the job failed, click the Query Status tab and Job Errors tab for more information. For details, see Troubleshooting Population Issues.
8. Click OK.

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