Search for	Example	Results
A single word	`cat`	Topics that contain the word "cat". You will also find its grammatical variations, such as "cats".
A phrase. You can specify that the search results contain a specific phrase.	`"cat food"` (quotation marks)	Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase.

Search for	Operator	Example
Two or more words in the same topic	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Universal DiscoveryContent Pack 28.00 (CP28)

Integrate > Third Party Integrations > Microsoft IAMUI Integration > Microsoft IAMUI Integration > How to Push Data from UCMDB to IAMUI

How to Push Data from UCMDB to IAMUI

Prerequisites
- Microsoft IAMUI is already deployed and configured in your organization.
- You have the following credential related information for accessing the SQL server or Azure SQL server database for IAMUI: username, password, URL, port, and schema name.
Set up UCMDB
Create a UDDI Registry CI named iamui_trigger and run the IAMUI Cleanup Job Trigger (or IAMUI Import Job Trigger) TQL query.
1. In UCMDB UI, go to Modeling > IT Universe Manager.
2. In the Related CIs tab window, click New CI .
  
  The New CI dialog opens.
3. In the Select CI Type pane, select UDDI Registry.
4. In the Define New CI Properties pane, type iamui_trigger for the Name property.
5. Specify other properties if necessary.
6. Click Save.
7. Go to the Modeling Studio > Resources.
8. In the Resources tab window, select queries as resource type, expand Root > Integration > IAMUI > Push > IAMUI Cleanup Job Trigger.
9. Double-click IAMUI Cleanup Job Trigger, and then in the right pane, click Calculate Query Result Count .
  
  Make sure the returned result is greater than 0, like the following:

Create an integration point

Define the integration point as follows:

Log in to UCMDB as an administrator.
Navigate to Data Flow Management > Integration Studio. A list of existing integration points is displayed.
Click New Integration Point . The New Integration Point dialog box opens.

Complete the Integration Properties and Adapter Properties fields as shown in the following table:

Field (*Required)	Description
Integration Properties section
*Integration Name	Type the name (unique key) of the integration point.
Integration Description	Type a description of the current integration point.
Adapter	Click and then select Third Party Products > IAMUI Push Adapter.
Is Integration Activated?	Select this option to indicate the integration point is active.
Adapter Properties section
*Hostname/IP	The host name or IP address of the remote machine.
*Port	The port number of the SQL server. Default: 1433.
*Credentials ID	Credentials for the SQL Server user that you created in Generic Protocol. Click the Select Credential Id button. The Generic Protocol is already selected in the Protocol pane and in the Credentials list. Note Other credentials are not supported. Ensure that the account has Read access to Microsoft IAMUI. To configure the credential for this integration point, Ensure the Generic Protocol is selected, and then click . The Generic Protocols Parameters dialog box opens. Provide values for the following fields and click OK: Network Scope: Use the default value `ALL`. User Label: Type a label for the credential. Username: Provide the user name for the Microsoft SQL server user account. Password: Click and provide the password for the Microsoft SQL server user account. Click OK twice.
*DB Type	Type of the database. Select one from the drop-down list. The available values include SQL Server and Azure SQL Server.
Azure Connection String	(Applicable for Azure SQL Server only) The connection string used in Azure for connecting to Azure. The value is ignored if not Azure. For examples of the Azure connection string, see Connecting with SSL Encryption.
*Data Source Id	The data source ID to indicate the source of the data push. It must end with xxx_<number>, for example, ucmdb_1.
*Schema Name	The name of target DB schema to push data to.
*Data Flow Probe	The name of the Data Flow Probe/Integration service used to execute the synchronization from.
Additional Probes	Select additional probes to use when pushing to IAMUI in order to increase redundancy.

Click Test connection to make sure there is a valid connection.
Click OK.

The integration point is created and its details are displayed.
Note
- Your settings are not saved to the server until you click OK.
- You can edit this integration point by selecting the Integration Point name in the Integration Point pane and then clicking .

Push CI Data from UCMDB to the IAMUI database

Log in to UCMDB as an administrator.
Navigate to Data Flow Management > Integration Studio. A list of existing integration points is displayed.
Select the integration point that you created for IAMUI.
Run the job manually to see if the integration job works properly.

Go to the Data Push tab, click the Full Synchronization button to push all the relevant data for the job.

Note Delta Synchronization is not supported for the UCMDB-IAMUI integration.
Wait for the job to complete. Click the Refresh button to check the status of the job.
When the job is completed, the job status becomes one of the following depending on the results:
- Completed successfully
- Failed
Click the Statistics tab to view the results; If any errors occur, click the Query Status tab and Job Errors tab for more details.

If the job completes successfully, you can view the UCMDB CI data in the SQL server or Azure SQL server database for IAMUI.

Send Help Center feedback