IBM Tivoli Integration Composer Administrator Guide

1 Administrator Guide Version 7, Release 2for IBM Tivoli Asset Management for IT, IBM Tivoli Service Request Manager,IBM Maximo Asset Management for Energy Optimization, andIBM Tivoli Change and Configuration Management DatabaseIntegration ComposerThis edition applies to version 7, release 2 of IBM Tivoli Integration Composer and to all subsequent releases and modifications until otherwise indicated in new editions. Copyright International Business Machines Corporation 2007, 2009. All rights reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM using this information and the product it supports, read the information in Notices on page 181.

2 Copyright IBM Corp. 2007, 2009iiiAbout This Publication.. viiIntended audience .. viiChapter 1: Introduction to Integration Composer .. 1 Integration Composer Overview.. 1 system Requirements.. 2 Integration Composer Components .. 2 Import Process .. 4 Integration Composer Adapters.. 5 File Structure .. 6 Mapping Process.. 8 Error Management and Performance Monitoring.. 9 Naming and Reconciliation Service Logs .. 10 Viewing Mapping Information in the Database .. 10 Database Errors .. 10 Monitoring Performance .. 11 Introduction to Data Schemas .. 12 Classes, Properties, and Instances.

3 12 Class Hierarchy .. 13 Key Properties and Relations .. 15 Chapter 2: Access and Navigation .. 17 Accessing the User Interface .. 17 Navigating the User Interface .. 17 Chapter 3: Defining Source and Target Data Sources .. 21 Defining a New Data Source .. 21 Browsing a Data Source .. 24 Browsing a Data Source by Structure .. 24 Browsing a Data Source by Data .. 26 Choosing Specific Instances to View .. 27 Viewing Properties of a Data Source .. 28 Searching the Tree View.. 30 Closing a Connection to a Data Source .. 31 Deleting a Data Source .. 32 Chapter 4: Mapping Data Sources.

4 33 Mappings Overview .. 33 Mapping Functions .. 34 Mapping Execution .. 34 Mapping Window Features .. 36 Mapping Window Actions .. 38 Mapping Process.. 39 Creating a New Mapping .. 39 Opening an Existing Mapping.. 41 Viewing Mapping Errors .. 43 Exporting and Importing a Mapping .. 43 Exporting a Mapping .. 44 Importing a Mapping.. 44 ContentsivIntegration Composer : Administrator GuideDeleting a Mapping .. 45 Deleting Mapping Last Scan History .. 46 Executing a Mapping .. 47 Executing Mappings with an Edited File .. 48 Executing Mappings from a Command LIne.

5 50 Creating Effective Mappings .. 52 Unique Identifiers for Deployed Asset Data .. 52 Mapping Key Properties .. 52 Mapping Data for Units of Measurement.. 52 Mapping Data for Sites and Organizations .. 52 Mapping Data for Deployed Asset Conversion Applications .. 53 Mapping Data for Files .. 54 Chapter 5: Creating Data Schemas .. 55 Understanding Integration Composer Data Schemas .. 55 Creating Data Schemas .. 56 Define a New Data Schema Window .. 56 Data Schema Window .. 56 Classes Section .. 57 Database Tables Section .. 59 Tables in Class Section .. 60 Select Action Menu.

6 60 Working with Classes and Tables in the Data Schema Window .. 61 Creating a New Data Schema .. 62 Guidelines for Creating Data Schemas .. 62 Defining a Data Schema .. 62 Renaming the Root Class.. 65 Adding a Class .. 66 Adding Properties to a Class .. 68 Adding a Child Class .. 71 Adding a Relationship .. 72 Adding a Reference Class .. 73 Designating a Primary Key .. 74 Designating an Alternate Key.. 75 Defining a Generated Value Property .. 76 Defining Data Schema Properties .. 78 Changing an Existing Data Schema .. 80 Opening an Existing Data Schema.. 81 Changing Class Attributes.

7 84 Filtering Class Data .. 86 Changing Properties in a Class.. 90 Renaming a Class .. 91 Renaming a Class Property .. 92 Deleting a Class.. 93 Deleting a Class Property .. 94 Deleting a Relationship .. 95 Viewing Link Properties .. 96 Deleting a Data Schema .. 97 Importing a Data Schema .. 98 Exporting a Data Schema .. 100 Chapter 6: Creating Expressions .. 101 Understanding Expressions .. 101 When Expressions Are Required .. 101 Syntax of Expressions .. 102 Creating Expressions.. 103 Drag and Drop .. 103 Typing an Expression .. 103 ContentsvSelecting a Deciding Class.

8 103 Setting Up Multiple Cases.. 104 Expression Builder .. 105 Using an Arithmetic Operator .. 107 Using a Literal .. 107 Deleting Expressions .. 108 Appendix A: Expression Functions, Literals, and Operators .. 109 Functions .. 109 All Functions .. 109 Date/Time .. 109 Logical .. 110 Mapping.. 110 Mapping Execution Flow .. 111 Math .. 111 SQL .. 112 Text .. 113 Literals .. 115 String .. 115 Boolean .. 116 Char .. 116 Integer .. 117 Floating-Point .. 117 Operators .. 117 Arithmetic Operators .. 117 Assignment Operator.. 118 Comparison Operators.

9 118 Logical Operators .. 118 Unary Operators .. 119 Order of Calculations .. 119 Appendix B: Initialization Files .. 121 Integration Composer Properties File ( ).. 121 IBM Tivoli Maximo Database-Related Properties .. 122 IBM Tivoli Integration Composer -Related Database Properties .. 122 IBM Tivoli Integration Composer Application Properties .. 124 IBM Tivoli Integration Composer Mapping Execution Properties .. 124 IBM Tivoli Integration Composer Application Bidi Properties .. 127 Login Properties File ( ) .. 128 Connection Properties File ( ) .. 128IT Asset Initialization Properties File ( ).

10 128 Deployed Asset Initialization Properties File ( ) .. 129 Logging Properties File ( ).. 129 Log4j Root Loggers.. 130 Loggers Used by Integration Composer .. 131 Asset Manager XML File .. 131 Appendix C: Data Schemas and Mapping Files .. 133 Appendix D: Naming and Reconciliation Service (NRS) .. 135 Integration Composer and GUIDs .. 136 Configuring Integration Composer for NRS .. 138 Logging NRS-related Events .. 138 Appendix E: IT Asset Initialization .. 141IT Asset Initialization Overview .. 141IT Asset Initialization Process Components .. 143 Prerequisite Tasks Checklist.