How to Add Custom queries to Data Push Jobs

In order for the integration to send your custom CI types and attributes to your Service Manager system, you must add your custom queries to the data push job between your Changes data store and your Service Manager data store. The following steps illustrate how to add an custom query named rdbmsData, which is described in the previous sections.

To add custom queries to a data push 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.
5. Click the name of your data push job. For example, SM Configuration Item Push job.
6. Click the Edit button .
7. Click the Add button.
8. Click Integration > SM Sync > rdbmsData.
9. Click OK to add the custom query.
10. Enable the Allow Integration Job to delete removed data option for the query.
11. Click OK to close the Update Job Definition window.