NIM

Add a File system
  1. Go to Systems > Overview.

    2021-05-04_12-14-52.png
  2. Click Add.

  3. Select File for System Type.

  4. Enter a System Name.

    2021-05-04_12-17-45.png
  5. Click Save.

  6. The new System is added to the Configured Systems pane.

    2021-05-04_12-20-05.png
  7. Click configure_tables.pngConfigure for the system.

  8. Select a Drive - share.

  9. In the Directories pane, navigate to the folder that contains the data files.

  10. In the Files pane, select the checkbox for each data file to import.

    2021-05-04_12-55-36.png
  11. Optional: Configure the settings on the Parsing tab.

  12. Click Save.

This dataset can be used with a File system to simulate source system data, and thus to test many features in NIM. See Add a File system.

Many articles in the NIM documentation contain examples based on this dataset.

Download it here:

Configure it as follows:

  • Choose tables to collect: All tables

    2021-07-16_12-53-38.png
  • Assign primary keys to tables

    Table

    Key

    contracts

    contract_id

    departments

    organizational_unit

    employees

    employee_id

    employments

    employment_id

    job_titles

    job_code

    2021-07-16_12-54-41.png
    2021-07-16_12-55-20.png
    2021-07-16_12-56-58.png
    2021-07-16_12-57-17.png
    2021-07-16_12-57-34.png
  • Specify 1-N relations

    • contracts table

      • Foreign key employment_id (N) -> primary key employment_id of employments table (1)

      • Foreign key manager_id (N) -> primary key employee_id of employees table (1)

      • Foreign key department (N) -> primary key organizational_unit of departments table (1)

      • Foreign key job_code (N) -> primary key job_code of job_titles table (1)

      2021-07-16_12-55-04.png
    • departments table

      • Foreign key parent (N) -> primary key organizational_unit of departments table (1)

      2021-07-16_12-56-50.png
    • employees table

      • None

      2021-07-16_12-57-10.png
    • employments table

      • Foreign key employee_id (N) -> primary key employee_id of employees table (1)

      2021-07-16_12-57-24.png
    • job_titles table

      • None

      2021-07-16_12-57-43.png