Pre-Installation: Set SQL Server Variables

About this task


Variable	Example Value	Description
CDM_DATABASE	SQLSERVER	Target database type
CDM_SQLSERVER_HOST	sqlserver.example.com	SQL Server hostname
CDM_SQLSERVER_PORT	port	SQL Server port
CDM_SQLSERVER_DATABASE	cdm_db	Target SQL Server database name
CDM_SQLSERVER_CANONICAL_ETL_DB_USER	canonical_etl_db_user	ETL service account
CDM_SQLSERVER_CANONICAL_ETL_DB_USER_PASSWORD	<password>	ETL service account password
CDM_SQLSERVER_DDL_START_POINT	(empty or step ID)	DDL resume point
CDM_SQLSERVER_DIM_MODEL_SCHEMA	Schema	Schema name for IM_CDP_DB schema
CDM_CUSTOMER_SOURCE_SQLSERVER_SCHEMA	Schema	Schema name for canonical schema
CDM_SQLSERVER_DDL_SCHEMA	Schema	contains details such as ID, filename, username, and password used for DDL execution.
SCRIPTS_BASE_PATH	/opt/unica/cdm/scripts	Base directory containing CDM ETL and orchestration scripts
UNICA_VENV_PYTHON_PATH	/opt/unica/venv/bin/python	Python executable path for the CDM virtual environment
CDM_360_ML_DBT_PROJECT_DIR	/opt/unica/cdm/dbt/360_ml	DBT project directory for Customer 360, Campaign 360, Flowchart 360, and ML models
CDM_360_ML_DBT_LOG_PATH	/opt/unica/cdm/logs/dbt/360_ml	Log directory for 360 and ML DBT execution logs
CDM_ANP_RDV_BDV_DBT_PROJECT_DIR	/opt/unica/cdm/dbt/anp_rdv_bdv	DBT project directory for ANP, RDV, and BDV transformation models
CDM_ANP_RDV_BDV_DBT_LOG_PATH	/opt/unica/cdm/logs/dbt/anp_rdv_bdv	Log directory for ANP, RDV, and BDV DBT execution logs

Schema name variables (defaults):


Variable	Default
CDM_SQLSERVER_360_SCHEMA	CS_360_DB
CDM_SQLSERVER_BDV_SCHEMA	DEV_BDV
CDM_SQLSERVER_METADATA_SCHEMA	CDP_METADATA
CDM_SQLSERVER_INGEST_DB_SCHEMA	CDM_INGEST_DB
CDM_SQLSERVER_LDZ_SCHEMA	DEV_LDZ
CDM_SQLSERVER_ANP_SCHEMA	DEV_ANP
CDM_SQLSERVER_RDV_SCHEMA	DEV_RDV
CDM_SQLSERVER_RAW_SCHEMA	DEV_RAW
CDM_SQLSERVER_CDM_PUBLISH_DB_SCHEMA	CDM_PUBLISH_DB

Procedure

Configure environmental entries using the Airflow administrator setup screen.