Consolidate Entities - Cross-CP Lookup

A Content Pack (CP) includes several entities. Some entities have relationships with other entities in the same Content Pack. In such cases, the ETL process looks up for the relational entities in the same Content Pack.

In some cases, you may need to develop several Content packs for the same entities. For example, the AWS and AWSCW integrations are performed using two different Content Packs including similar entities.

To set up the priority order:

1. Go to $ITBA_HOME$\ContentPacks\$DATASOURCE_NAME$\CONF\dataSourceParamsConfig.xml.

   Note The configuration file is optional. Without the configuration file, the ETL process follows the regular look up way, meaning that one entity looks up the other entity in the same Content Pack with the same instance and the instance ID is replaced automatically by the ETL service.

2. Modify the file, and save it.

   The entity uses first the value in the first instance, for example PPM_1, if there is no such value, it uses the value in the second instance, for example PPM_2, or if there is no such value, it uses the default value. You can have more than two <ParamValue Value=... Instance Name=.../> lines.

   The format must be as follows:

   <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
       <Entities DataSourceName="PPMCT">
           <Entity EntityName="LOCATION_CSTM">
               <Parameter DefaultValue="" Name="MD_CP_ID_FOR_LOOKUP">
                    <ParamValue Value="1" InstanceName="PPM_CSTM"/>
               </Parameter>
           </Entity>
       </Entities>
   

   where:

   • DataSourceName is the name of the Content Pack that is installed.
   • EntityName is the entity for which you must do a cross_CP lookup.
   • Parameter DefaultValue is the default value if you did not configure the parameter value.
   • Parameter Name is the name of the parameter that you use in the SSI layer.
   • ParamValue is the value for the parameter that is used for the SSI layer customization.
   • InstanceName is the data source instance used for the cross -CP lookup.