4.4.1.5.3 DJW List Reference Mapper Feed Configuration

Perform the following Steps to configure DJW List Reference Mapper Feed:

1. Navigate to the <Patch_Extracted_Path> folder and unzip the config.zip folder.
2. Navigate to <Patch_Extracted_Path>/config/dbconnectors folder and move the sentry-djw-connector.jar file to the following location: {domain_name}/config/fmwconfig/edq/oedq.local.home/dbconnectors.

   Note:

   Replace {domain_name} with the actual domain name used in your environment in steps 3 and 4 as well.
3. Navigate to <Patch_Extracted_Path>/config/commandarea folder and move the ows-dow-jones-downloader.jar file to the following location: {domain_name}/config/fmwconfig/edq/oedq.local.home/commandarea
4. Go to the {domain_name}/config/fmwconfig/edq/oedq.local.home/commandarea folder and perform the following steps:
   1. Open the download-djw.sh file.
      1. Replace the existing Reference Mapping URL with the following URL: https://djrcfeed.dowjones.com/list-reference-mapper
      2. Save and close the file.
   2. Open the download-djw.bat file.
      1. Replace the existing Reference Mapping URL with the following URL: https://djrcfeed.dowjones.com/list-reference-mapper
      2. Save and close the file.

      Figure 4-10 The download-djw.sh file

      
      

      

      
      
5. In the same file, go to the downloading full reference mapping data, replace djrc_wlrm_xml with djrc_listreferencemapper_xml, refer to the below image.

   Figure 4-11 Downloading full reference mapping data

   
   

   

   
   
6. Go to the EDQ URL and open the Director menu. The Director landing page appears.
7. In the Director landing page, click File > Open Package File. The Open window appears.

   Figure 4-12 The Director landing page

   
   

   

   
   
8. Navigate to the <Patch _Extracted_Path>\DXI folder, select the Watchlist Management_12_2_1_1_0.dxi file and click Open.

   Figure 4-13 The Open Window

   
   

   

   
   
9. Expand the Watch list Management_12_2_1_1_0.dxi project in the Project Browser pane.
10. Expand the Reference Data node and perform the following steps:
    1. Copy the DJW List Provider reference data and paste it into your Watchlist Management Project.

       Figure 4-14 The Project Browser Pane

       
       

       

       
       

       1. When the pop-up appears, select the Overwrite check box and click OK.
    2. Copy the DJW List Provider Static reference data and paste it into your Watchlist Management Project.

       Figure 4-15 The Reference Data list

       
       

       

       
       

       1. When the pop-up appears, select the Overwrite check box and click OK.
    3. Copy the DJW_List_Provider_Region reference data and paste it into your Watchlist Management Project.

       Figure 4-16 The Project Browser Pane

       
       

       

       
       

       1. When the pop-up appears, select the Overwrite check box and click OK.
    4. Copy the DJW_List_Provider_Sanctions reference data and paste it into your Watchlist Management Project.

       Figure 4-17 The Reference Data list

       
       

       

       
       

       1. When the pop-up appears, select the Overwrite check box and click OK.
    5. Copy the DJW_List_Provider_Sanctions reference data and paste it into your Watchlist Management Project.

       Figure 4-18 The Reference Data list

       
       

       

       
       

       1. When the pop-up appears, select the Overwrite check box and click OK.
11. Expand the Staged Data node and perform the following steps:
    1. Copy the DJW_Sanctions_List_Provider_Current staged data and paste it into your Watchlist Management Project.

       Figure 4-19 The Staged Data list

       
       

       

       
       

       When the pop-up appears, select the Overwrite check box and click OK.

12. Expand the Process node and perform the following steps:
    1. Copy the Stage DJW Sanction List References process and paste it into your Watchlist Management Project.

       Figure 4-20 The Project Browser Pane

       
       

       

       
       
    2. Copy the DJW_Sanction_List_References process and paste it into your Watchlist Management Project.

       Figure 4-21 Process list

       
       

       

       
       
    3. Copy the DJW_Keywords_Preparation process and paste it into your Watchlist Management Project.

       Figure 4-22 Process list

       
       

       

       
       
13. Expand your Watch list Management project in the Project Browser pane.
14. Expand Staged Data node and open the DJW_Sanction_List_References stage data. The Setup Snapshot window appears.

    Figure 4-23 The Setup Snapshot window

    
    

    

    
    
    1. On the Data Store page, select DJW and click Next.
    2. On the Table Selection page, select Sanction Preferences and click Next.
    3. On the Column Selection page, select the All Columns and click Next.
    4. Close the window.
15. Expand the Jobs node and open the Download, Prepare, Filter and Export All Lists Job. The Download, Prepare, Filter and Export All Lists window appears.
16. Create a new DJW - Sanction_List_Reference phase.
    1. Click the Create a New Phase
       
       
       
       icon. The Job Phase pop-up appears.

       Figure 4-24 The Job Phase window

       
       

       

       
       
    2. Enter the Phase name as DJW - Sanction_List_Reference.
    3. Click OK. By default, new phases appear at the end of the list.
17. Move the DJW - Sanction_List_Reference phase below the DJW - Stage reference phase in the list.

    Figure 4-25 List of Phases

    
    

    

    
    
18. Move the DJW_Sanction_List_references stage data from the DJW - Stage reference lists phase to DJW - Sanction_List_Reference phase and link Stage DJW Sanction List References and DJW_Sanction_List_References process.
    1. Click the DJW - Stage reference lists phase and delete the DJW_Sanction_List_references stage data and corresponding links.
    2. Click the DJW - Sanction_List_Reference phase.
    3. In the Tool Palette window, search for DJW - Sanction_List_Reference.

       Figure 4-26 The Tool Palette window

       
       

       

       
       
    4. Drag and drop the DJW - Sanction_List_Reference stage data to the DJW - Sanction_List_Reference phase.

       Figure 4-27 The DJW - Sanction List Reference phase

       
       

       

       
       
    5. From the Tool Palette window, drag and link the DJW_Sanction_List_References process to the DJW - Sanction_List_Reference stage data.

       Figure 4-28 The Tool Palette window

       
       

       

       
       
    6. From the Tool Palette window, search for Stage DJW Sanction List References process.
    7. Drag and link the Stage DJW Sanction List Referencesprocess to the DJW - Sanction_List_Reference stage data.

       Figure 4-29 The DJW - Sanction List Reference phase

       
       

       

       
       
19. Right-click DJW - Sanction_List_Reference stage data and select Configure connector.
20. On the Configure task pop-up, select both Enabled and Stage data check boxes and click OK.

    Figure 4-30 The Configure Task pop-up

    
    

    

    
    
21. Create a new DJW - Keywords_Preparation phase.
    1. Click the Create a New Phase
       
       
       
       icon. The Job Phase pop-up appears.

       Figure 4-31 The Job Phase window

       
       

       

       
       
    2. Enter the Phase name as DJW - Keywords_Preparation.
    3. Click OK. By default, new phases appear at the end of the list.
22. Move the DJW - Keywords_Preparation phase below the DJW - Sanction_List_Reference in the list.

    Figure 4-32 List of available phases

    
    

    

    
    
23. Add the DJW_List_Providers stage data to the DJW - Keywords_Preparation phase and link DJW_Keywords_Preparation process.
    1. Click the DJW - Keywords_Preparation phase.
    2. In the Tool Palette window, search for DJW_List_Providers stage data.
    3. Drag and drop the DJW_List_Providers stage data to the DJW - Keywords_Preparation phase.
    4. In the Tool Palette window, search for DJW_Keywords_Preparation process.
    5. Drag and link the DJW_Keywords_Preparation process to the DJW_List_Providers stage data.

       Figure 4-33 The DJW - Keywords Preparation phase

       
       

       

       
       
24. Right- click DJW_List_Providers stage data and select Configure connector.
25. On the Configure task pop-up, select Enabled? and Stage data? check boxes and click OK.

    Figure 4-34 The Configure Task pop-up

    
    

    

    
    
26. Go to the {domain_name}/config/fmwconfig/edq/oedq.local.home/runprofiles folder and perform the following steps.
    1. Open the watchlist-management.properties file.
       1. Navigate to the DJW setup section add the following commands. phase.DJW\ -\ Sanction_List_Reference.enabled = Y

          phase.DJW\ -\ Keywords_Preparation.enabled = Y

       2. Save and close the file.

          Perform following step only if you are using the watchlist-management - TF.properties file, otherwise skip it.

    2. Open the watchlist-management - TF.properties file.
       1. Navigate to the DJW setup section add the following commands.

          phase.DJW\ -\ Sanction_List_Reference.enabled = Y 
          phase.DJW\ -\ Keywords_Preparation.enabled = Y

          ii. Save and close the file.

          Figure 4-35 The watchlist-management.properties file