Pre-Installation: Set Oracle Variables
About this task
Set the following in the Airflow UI (Admin > Variables)
| Airflow Variable | Example Value | Description |
|---|---|---|
| CDM_DATABASE | ORACLE | Target database type — must be set first |
| CDM_ORACLE_HOST | db.example.com | Oracle hostname or IP |
| CDM_ORACLE_PORT | <port> | Oracle listener port |
| CDM_ORACLE_SERVICE | ORCL | Oracle service name (TNS) |
| CDM_ORACLE_DDL_START_POINT | (empty or Step1) | Resume point for DDL execution |
| CDM_ORACLE_CANONICAL_PASSWORD | <password> | Password for canonical schema user |
| CDM_ORACLE_RAW_PASSWORD | <password> | Password for dev_raw schema user |
| CDM_ORACLE_LDZ_PASSWORD | <password> | Password for dev_ldz schema user |
| CDM_ORACLE_RDV_PASSWORD | <password> | Password for dev_rdv schema user |
| CDM_ORACLE_BDV_PASSWORD | <password> | Password for dev_bdv schema user |
| CDM_ORACLE_CS_360_DB_PASSWORD | <password> | Password for cs_360_db schema user |
| CDM_ORACLE_CDM_INGEST_PASSWORD | <password> | Password for cdm_ingest_db schema user |
| CDM_ORACLE_CDP_METADATA_PASSWORD | <password> | Password for cdp_metadata schema user |
| CDM_ORACLE_IM_CDP_DB_PASSWORD | <password> | Password for im_cdp_db schema user |
| CDM_ORACLE_CDM_PUBLISH_DB_PASSWORD | <password> | Password for cdm_publish_db schema user |
| CDM_ORACLE_CANONICAL_ETL_DB_USER | canonical_etl_db_user | Primary ETL service account username |
| CDM_ORACLE_CANONICAL_ETL_DB_USER_PASSWORD | <password> | Primary ETL service account password |
| CDM_ORACLE_MAX_AI_DB_USER | max_ai_db_user | MaxAI platform service account |
| CDM_ORACLE_CDP_ETL_DB_USER | cdp_etl_db_user | CDP ETL service account |
| CDM_CUSTOMER_SOURCE_ORACLE_SCHEMA | canonical | Source schema for Bespoke ETL |
| 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 Value |
|---|---|
| CDM_ORACLE_360_SCHEMA | CS_360_DB |
| CDM_ORACLE_BDV_SCHEMA | DEV_BDV |
| CDM_ORACLE_METADATA_SCHEMA | CDP_METADATA |
| CDM_ORACLE_INGEST_DB_SCHEMA | CDM_INGEST_DB |
| CDM_ORACLE_LDZ_SCHEMA | DEV_LDZ |
| CDM_ORACLE_ANP_SCHEMA | DEV_ANP |
| CDM_ORACLE_RDV_SCHEMA | DEV_RDV |
| CDM_ORACLE_RAW_SCHEMA | DEV_RAW |
| CDM_ORACLE_DIM_MODEL_SCHEMA | IM_CDP_DB |
| CDM_ORACLE_CDM_PUBLISH_DB_SCHEMA | CDM_PUBLISH_DB |
Procedure
Input defaults into Airflow administrative variables interface panel.