Welcome
Administration
Learn about how to configure, manage, and maintain HCL Detect environments. It includes details on system setup, user management, and permissions, ensuring seamless operation and efficient deployment of your continuous delivery processes.
Profile Management
Use CLI commands to create, update, query, and delete profile definitions used by Detect.
Command Details and JSON Payloads
get-default-attribute-column-mapping

Getting Started
Welcome to the documentation for HCL Detect, where you can find information about how to install, maintain, and use this service.
Installation
Learn more about HCL Detect installation and deploying core components of the product.
Administration
Learn about how to configure, manage, and maintain HCL Detect environments. It includes details on system setup, user management, and permissions, ensuring seamless operation and efficient deployment of your continuous delivery processes.
- Introduction
  Use this guide to administer HCL Detect, including user and role access, CLI-based configuration and management tasks, DEL reference topics, and support resources.
- User & Role Management
  This page explains how to manage roles and permission in HCL Detect.
- Configuration Management
  Use CLI commands to query and validate the infrastructure settings required for Detect operations.
- Metadata Management
  Use CLI commands to discover data sources, search tables, and retrieve column metadata for Detect integrations.
- Profile Management
  Use CLI commands to create, update, query, and delete profile definitions used by Detect.
- Feed Application
  Use CLI commands to create and manage feed applications, including filtering and troubleshooting scenarios.
- Feed Parser Mapping
  Use CLI commands to define and maintain feed parser mappings between incoming feed fields and Detect target attributes.
- Destination Management
  Use CLI commands to configure, validate, and manage destination endpoints for Detect event delivery.
- Crypto Management
  Use CLI crypto utilities to encrypt and decrypt sensitive values used in Detect configuration workflows.
- Troubleshooting & Common Errors
- Support & Contact Information
- Detect Expression Language
- Detect Expression Language Built-in Functions
Working with the System
The section provides comprehensive instructions for creating, configuring, and managing marketing events. It covers topics such as defining audience conditions, setting up triggers, deploying events, and tracking their performance. Additionally, this section includes explanations of key terminology and offers advanced options to optimize event management.
System Data Model
This section provides detailed information about the internal tables used within the Detect module. It includes descriptions of each table's structure, purpose, and relationships, aiding administrators and developers in understanding and managing the underlying database schema effectively.

`get-default-attribute-column-mapping`

Description

The get-default-attribute-column-mapping command retrieves the default mapping between database columns and profile fields for a specific table in a given datasource.

This command is typically used to prepare the payload for create-profile or update-profile.

Syntax

Windows

CliTool.bat get-default-attribute-column-mapping -d <dataSourceName> -t <tableName>

Linux

./CliTool.sh get-default-attribute-column-mapping -d <dataSourceName> -t <tableName>

Example

CliTool.bat get-default-attribute-column-mapping -d UnicaDetectDS -t CUSTOMER_PROFILE

Parameters

-d: datasource name
-t: table name

What to do with the output

Use the response as the base value for attributeColumnMappings in your create/update JSON payload.

Typically, you only need to edit:

attributeName
isKeyAttribute

Mapping Details


Database column side	Profile mapping side
`databaseColumn.name`	attributeName
`databaseColumn.typeCode`	JDBC/SQL type code
`databaseColumn.isPrimaryKey`	indicates source table PK
`isKeyAttribute`	indicates whether the mapping is the Detect profile key

This mapping ensures that each database column is correctly associated with its corresponding profile field, enabling seamless integration and data consistency.