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');
43
44-- removes the BDdomains
45execute script API_REDADM.REMOVE_BDOMAIN('DIV_EAST');
46execute script API_REDADM.REMOVE_BDOMAIN('DIV_WEST');