How to Add a Custom Query to an Integration Job

In order for the integration to synchronize your custom CI types, attributes, and relationships between your Service Manager and UCMDB systems, you must add your custom queries to a data push or population job.

The following steps illustrate how to add an custom query named rdbmsData, which you created previously (see How to Create a Query to Synchronize the CI Type), to a data push job. The steps for adding a population query to a population job are similar.

To add a custom query to a data push or population job:

1. Log in to UCMDB as an administrator.
2. Navigate to Data Flow Management > Integration Studio.
3. Click the name of your Service Manager integration point. For example, sm_integration.

4. Click the Data Push tab.

   Note To add a query to a population job, click the Population tab instead.

5. Click the name of the integration job. For example, SM Configuration Item Push job.
6. Click the Edit icon .
7. Click the Add icon.

8. Click Integration > Service Manager > Push > rdbmsData.

   Note For population, navigate to Integration > Service Manager > Population, and click the population query instead.

9. Click OK to add the custom query.
10. Enable the Allow Deletion option for the query to allow the integration job to delete removed data.
11. Click OK to close the Update Job Definition window.