×
 
 
  •  
$helper.renderConfluenceMacro('{bmc-global-announcement:$space.key}')

   

This documentation supports releases of BMC Helix Continuous Optimization up to December 31, 2021. To view the latest version, select the version from the Product version menu.
BMC Helix Continuous Optimization 21.3 ... Administering Administering the Capacity Optimization environment Managing and maintaining ETL and System Tasks Maintaining ETL tasks Working with ETLs

Handling ETL lookup name

When an ETL creates a system, the Continuous Optimization loader uses the values of the following properties:

  • ds_sysnm for the lookup name.
  • sysnm for the name displayed in the console.

By default, if an ETL extractor with a single lookup table populates sysnm and ds_sysnm fields with FQDNs, before the data is loaded into the database, the ETL loader removes the domain suffix from sysnm and leaves ds_sysnm as it is.

To remove the domain suffix from ds_sysnm

  1. Navigate to Administration> ETL & SYSTEM TASKS > Add > Add ETL.
  2. Click Advanced to view the advanced configuration options.
  3. Expand Loader configuration and set Remove domain suffix from data source name to true, as shown in the figure:



To include the domain suffix in sysnm, set Leave domain suffix to system name to true.


Was this page helpful? Yes No Submitting... Thank you
Last modified by Bharati Poddar on Jun 23, 2021
administration tasks etls

Comments

Log in or register to comment.

Gathering ETL logs
Importing and exporting ETL packages
© Copyright 2019 - 2022 BMC Software, Inc. © Copyright 2019 - 2022 BladeLogic, Inc.
Legal notices

Powered by Atlassian Confluence and Scroll Viewport

© Copyright 2005-2024 BMC Software, Inc. Use of this site signifies your acceptance of BMC’s Terms of Use . BMC, the BMC logo, and other BMC marks are assets of BMC Software, Inc. These trademarks are registered and may be registered in the U.S. and in other countries.