8. Next Steps

8.1. How To Simulate Data Changes

  • Change data in the source database table.

  • Change data in the CSV-file and copy it again into the input directory.

    • Also change the BDate in the filename. By leaving the BDate as is but changing some attributes you can simulate technical historisations (TDate termination).

Check the view PSV_EMP_DR.PERSON for historisation effects.

8.2. RED_REGISTRY

In each RED schema (e.g. REDADM, DBIADM, SCURTY, etc.) you will find a view RED_REGISTRY. In there all the API calls are listed inorder to setup the configuration from scratch. You can use this for templating as well as a source for setting up the DWH from scratch within a CI/CD pipeline.

8.3. How to Remove All Metadata

Important

Suspend the framework first.

 1-- remove application status and actions
 2execute script api_redadm.remove_app_action('HR-ready', 'mail-emp-new');
 3execute script api_redadm.remove_app_discover_rule(<rule-ID>);
 4execute script api_redadm.remove_application('HR-ready');
 5execute script api_redadm.remove_app_act_exports('emp-new');
 6execute script api_redadm.remove_app_act_exp_fmt('csv-default');
 7
 8-- remove application mart (APB)
 9drop schema APB_HR cascade;
10
11-- remove SCURTY definitions
12execute script api_scurty.drop_user('CAESAR');
13execute script api_scurty.drop_user('HELENA');
14execute script api_scurty.remove_scol_discover_rule(<rule-ID>);
15execute script api_scurty.remove_tenant_group('DEPT');
16execute script api_scurty.remove_tenant_group('DIV');
17execute script api_scurty.remove_object_group('OG_HR');
18execute script api_scurty.rep_refresh;
19execute script api_redadm.refresh_time(null, array());
20execute script api_reppsa.refresh;
21
22-- remove PSA structures
23execute script api_redadm.empty_psa('PSA_EMP', 'PERSON', null);                                  -- cleans out data from PSA table
24execute script api_reppsa.remove_object('PSA_EMP', 'PERSON');                                    -- removes PSA and PSB tables and views in addition to metadata in REPPSA
25execute script api_redadm.remove_tsa_load_cycle('DBITSA', 'EMP_PERSON_WEST', null, null, null);  -- remove all related load cycles
26execute script api_redadm.remove_tsa_load_cycle('CFITSA', 'EMP_PERSON_EAST', null, null, null);  -- remove all related load cycles
27execute script api_redadm.refresh;
28
29-- remove DBI structures
30execute script api_dbiadm.empty_tsa('EMP_PERSON','DIV_WEST');
31execute script api_dbiadm.remove_loader_bd('EMP_PERSON','DIV_WEST');
32execute script api_dbiadm.remove_loader('EMP_PERSON');
33execute script api_dbiadm.remove_cdc_group('EMP_CDC', null);
34execute script api_dbiadm.refresh;
35
36-- remove CFI structures
37execute script api_cfiadm.empty_tsa('EMP_PERSON','DIV_EAST');
38execute script api_cfiadm.remove_loader_bd_column('EMP_PERSON','DIV_EAST', null);
39execute script api_cfiadm.remove_loader_bd('EMP_PERSON','DIV_EAST');
40execute script api_cfiadm.remove_loader('EMP_PERSON');
41execute script api_cfiadm.remove_bdomain_setting('DIV_EAST');
42execute script api_dbiadm.remove_bdomain_setting('DIV_WEST');
43execute script api_cfiadm.refresh;
44
45-- removes the BDdomains
46execute script api_redadm.remove_bdomain('DIV_EAST');
47execute script api_redadm.remove_bdomain('DIV_WEST');