A.12 Load Data into ICIJ Tables

After installing the Compliance Studio, you need to run the script. For more details, Importing OOB Graph Definition and related Metadata section in the OFS Compliance Studio Installation Guide.

The data pipeline does not currently support loading data directly from CSV files.

The following source tables are created during the Post Installation procedure.
  • ICIJ_NODES_ENTITY
  • ICIJ_NODES_INTERMEDIARY
  • ICIJ_NODES_OFFICER
  • ICIJ_NODES_OTHERS
  • ICIJ_NODES_ADDRESS
  • ICIJ_RELATIONSHIP
To create ICIJ tables, perform the following:
  1. Download zip file from the ICIJ’s website and copy the downloaded files to the local server.
  2. Log in to the Compliance Studio application.
  3. Navigate to the Compliance Studio server with the same URL by changing the port to 7008. (http://<hostname>:7008 from http://<hostname>:7001/cs/)
    The ICIJ Notebook is part of a built-in notebook, as shown below.

    Figure A-3 ICIJ Notebook


    Description of Figure A-3 follows
    Description of "Figure A-3 ICIJ Notebook"

  4. Open the Notebook, ICIJ CSV to DB/CSV Loader.
  5. Click Export Notebook to download the notebook.

    The notebook is saved in the local machine.

  6. Navigate to the Modeling drop-down list and select Pipelines.
  7. Click Add and select Objective from the list to display the Objective Details dialog box.
  8. Enter details in the Objective Name and Description fields in the Add Objective dialog box.
  9. Click Save.

    For more information on objective, see the Creating Objective (Folders) section in the OFS Compliance Studio User Guide.

  10. Click Add and select Draft from the list to display the Add Draft dialog box.
    Create New Model is the default setting in the Model Details dialog box.

    Note:

    The draft should be created inside the objective folder.
  11. Drag the toggle switch to select Import Dump.
  12. Drag and drop the file into the Import Dump File field or click in the box to open the file selector dialog and select a file.
  13. Click Import.
  14. Enter the details for the Draft Name and Description.
  15. Enter a tag in the Tags field.
  16. Click Import. A new model is created by importing the model data dump.

    For more information on importing workspace models, see the Import a Workspace Model Data into a New Model section in the OFS Compliance Studio User Guide.

  17. Ensure that the SQL loader (sqlldr) is running in the Compliance Studio.
  18. Enter the Target Schema Alias Name and the ICIJ CSV Folder Path and click the Run icon to run the paragraph.

    Figure A-4 Initialization Field Details


    Description of Figure A-4 follows
    Description of "Figure A-4 Initialization Field Details"

  19. Fill the names of CSV files in the required fields in each ICIJ source type. Ensure the name of the file is added with the .csv extension.

    Figure A-5 CSV Files Details


    Description of Figure A-5 follows
    Description of "Figure A-5 CSV Files Details"

  20. Click the Run icon to run the paragraphs for ICIJ source. You can simultaneously enter all the filenames and run the paragraph for all source files
    On successful execution, the data will be loaded into ICIJ tables.

    Note:

    The Notebook is accessible only by the Administrators.