Graph Use Case

This section describes the post-installation steps for Graph use case.

To perform post-installation activity for Graph:

1. Navigate to the <COMPLIANCE_STUDIO_INSTALLATION_PATH>/deployed/ficdb/graphmetadata/bin directory.
2. To initialize the OOB graph (FINANCIAL_CRIME_GLOBAL_GRAPH) schema, execute the following.

   ./InitializeECMSchema.sh -w <ecm_schema_wallet_alias>

3. To initialize the graph schema, execute the following.

   ./InitializeGraphSchema.sh -gw <graph_wallet_alias> -es <ecm_schema_name>

   Auto Scheduling of Transactional Tasks in the Graph Batch

   This section explains how to set up batch deltas to run for a specified period of time relative to the system date.

   If you are initializing "FINANCIAL_CRIME_GLOBAL_GRAPH" schedule with matching component enabled, then execute the following command.

   ./InitializeOOBGraphBatchScheduleECM.sh -ew <datasource name of the ECM atomic schema> -sdg <Start-day-gap> -edg <End-day-gap> -gd <graph_datasource> -u <complianceStudioUserName>

   The sample script for Weekly, Monthly, Yearly and, Periodically is given in the following table.

   Table 3-3 Schedule Transactional Task

   Batch Schedule	Sample Script
   Weekly (7 Days)	./InitializeOOBGraphBatchScheduleECM.sh -ew <datasource name of the ECM atomic schema> -sdg 7 - edg 0 -gd <graph_datasource> -u <complianceStudioUserName> For example, SYSDATE/ Current Date is 20/12/24 and you need to load one week data then use the following logic. Start Day Gap: 2024_12_20 - 7 = 2024_12_13 End Day Gap: 2024_12_20 - 0 = 2024_12_20 The transaction data from 2024_12_13 (12:00:00 AM) to 2024_12_19 (11:59:59 PM) will be considered for processing. As 2024_12_20 is the current date, complete data for the same date is not yet available in the Banking Domain for processing.
   Monthly (30 Days)	./InitializeOOBGraphBatchScheduleECM.sh -ew <datasource name of the ECM atomic schema> -sdg 30 - edg 0 -gd <graph_datasource> -u <complianceStudioUserName>
   Yearly (365 Days)	./InitializeOOBGraphBatchScheduleECM.sh -ew <datasource name of the ECM atomic schema> -sdg 365 - edg 0 -gd <graph_datasource> -u <complianceStudioUserName>
   Periodically	./InitializeOOBGraphBatchScheduleECM.sh -ew <datasource name of the ECM atomic schema> -sdg 21 -edg 1 -gd <graph_datasource> -u <complianceStudioUserName> For example, Suppose today's date is 2024_12_20 and users want to load data from 2024_11_29 to 2024_12_18 (both dates are inclusive). You are running a batch on 2024_12_20, therefore end-day-gap should be given as edg=1 and start-day-gap should be given as -sdg=21 where number of days between two dates is 22.

   If you are initializing "FINANCIAL_CRIME_GLOBAL_GRAPH" schedule with matching component disabled, then execute the following command.

   ./InitializeOOBGraphBatchScheduleECM.sh -ew <datasource name of the ECM atomic schema> -gd <graph_datasource> -sdg <Start-day-gap> -edg <Enddaygap> -u <complianceStudioUserName> -sm

4. Perform the following steps after applying patch 8.1.2.9.7:
   1. Navigate to the path: /scratch/fccstudio/CS81297_APR_CPU/compStudio_13041141/OFS_COMPLIANCE_STUDIO/deployed/mmg-home/mmg-load-to-graph/graph-service/utility/bin
   2. Run the policy_manager.sh shell script.

      ./policy_manager.sh sync -s <src_datasource> -t <tgt_datasource> -o <objective_id>

      For example: ./policy_manager.sh sync -s CS -t GS -o 853e4164-0968-4cb6-a6f3-2b4930614a8b

   3. Open the sys database and provide the following grants:

      GRANT EXECUTE ON DBMS_RLS TO GRAPH SCHEMA;
      
      GRANT EXECUTE ON DBMS_REDACT TO GRAPH SCHEMA;
      
      GRANT SELECT ON REDACTION_POLICIES TO GRAPH SCHEMA;
      
      GRANT SELECT ON REDACTION_COLUMNS TO GRAPH SCHEMA;
      
      GRANT EXECUTE ON SYS.DBMS_SESSION TO GRAPH SCHEMA;
      GRANT CREATE ANY CONTEXT TO  GRAPH SCHEMA;