How Single lookup vs. Multiple lookup work in TrueSight Capacity Optimization (TSCO) ETLs

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    TrueSight Capacity Optimization


    Capacity Optimization


    BMC TrueSight Capacity Optimization 20.02, 11.5, 11.3.01, 11.0, 10.7,10,5, 10.3, 10.0


    In our environment we are importing data using the vCenter Extractor Service ETL.  We have a separate CMDB that has system configuration information I'd like to import into TrueSIght Capacity Optimization (TSCO).  What is the best way to update the existing entities in TSCO with this additional data?  What about building a new workspace domain hierarchy using existing entities in TSCO based upon relationship data imported through an Object Relationship CSV Parser or Object Relationship SQL Extractor?



    1. Multiple lookup fields ETLs. These ETLs populate different lookup fields in order to have a more accurate lookup. Some of the out of the box ETLs (like VMware) that populate multiple lookup fields populate also a special lookup field called _COMPATIBILITY_. If you write a custom ETL, it is recommended to populate this field
    3. Single lookup field: the ETL populate a single field, called DEFAULT.
       How lookup is performed  
    1. Multiple vs. Multiple: the lookup is performed using the field marked as STRONG and WEAK (
    3. Single vs. Single: the lookup is performed on the field DEFAULT
    5. Multiple vs. Single: the lookup is performed comparing the content of DEFAULT (coming from single lookup ETL) and _COMPATIBILITY_ (coming from multiple lookup ETL)
       How populate field in a custom ETL  
    1. If you define DS_SYSNAME giving only a value (e.g. host name) the ETL will create single lookup field DEFAULT populated with that value
    3. If you define DS_SYSNAME with a sequence like this LOOKUPFIELD1#LOOKUPVALUE1##LOOKUPFIELD2#LOOKUPVALUE2 and after define in STRONGLOOKUPFIELDS and WEAKLOOKUPFIELDS the kind of field, you will create a multiple lookup
      Just to give you an example, this is how the VMware ETL populate these values;  
    A common use case: VMware ETL and custom CMDB

    A common use case is the integration of a custom CMDB that share entity catalog with VMware ETL 

    There are two ways to do it:  
    1. Using multiple lookup
      If you are writing a custom ETL or your are using Object Relationship SQL Extractor, you can use the multiple lookup feature.
    3. Using single lookup field
      If you are using Object Relationship CSV that doesn't support multiple lookup field or there are conditions in which you have to share the lookup with another ETLs that doesn't support multiple lookup, you have to change the configuration of VMware ETL in order to populate the field _COMPATIBILITY_ with system name or host name, as showed in this screenshot



    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles