ADD_CDCG_WATCH_BDΒΆ

Add new CDCG-Watch(BD).

Table: DBIADM.DBI_CDCG_WATCH_BD (BDomain specific settings for CDC groups)

Parameter Name

Properties

Default Value

Parameter Description

p_cdc_group

(PK)(NN)

Name of the change data capture group as defined in DBI_CDCG_GROUPS.CDC_GROUP (foreign key)

p_bdomain

(PK)(NN)

Name of the business domain as defined in DBI_BDOMAIN_SETTINGS.BDOMAIN (foreign key)

p_src_db_name

Name of the source database

p_src_connection

Name of the connection to the source database. Connections are listed in Exasol system tables EXA_ALL_CONNECTIONS and EXA_DBA_CONNECTIONS.

p_bdate_change_offset

Offset in hours on top of the business day turnaround (as defined in dbi_bdomain_settings) in order to force a load. E.g. setting to 1 means a forced data load will be triggered 1 hour after the change of business day.

p_src_where_clause

An optional SQL WHERE condition to separate business domains.

p_active

(NN)

FALSE

Should this group be regular loaded? Possible values: true or false.

p_cdc_min_intv

Minimum interval between cdcg_sync runs in minutes

Example

EXECUTE SCRIPT api_dbiadm.add_cdcg_watch_bd
            ( 'XXXXXXXXXXXX'    -- p_cdc_group
            , 'XXXXXXXXXX'      -- p_bdomain
            , 'XXXXXXXXXXXX'    -- p_src_db_name
            , 'XXXXXXXXXXXX'    -- p_src_connection
            , 99                -- p_bdate_change_offset
            , 'XXXXXXXXXXXX'    -- p_src_where_clause
            , FALSE             -- p_active
            , 999999999999      -- p_cdc_min_intv
            );