...

1. Load list of faculty and staff with mapped Archibus dept codes into Archibus

2. Move tables of buildings, spaces and space charges from Archibus into Axiom

Design

Components

Bold items are final/consumed views

1. Box

   1. https://tufts.box.com/s/769g7q2an711v7ylustmzsqr7bcojnpl

   2. https://tufts.app.box.com/file/1499128437018?s=cnnx4ymr5qjobzpv0rq8nrk9sp5pnxz1

   3. https://tufts.box.com/s/ybok7ycosjorb4purixrr2wvtln4tfri

2. Denodo VDP

   1. operations_facilities

      1. 01-base_layer

         1. 01-connections

            1. Box

               1. ds_box_org_mappings

            2. ds_archibus

         2. 02-base_views

            1. archibus

               1. bv_bl

               2. bv_rm

               3. bv_rmtype

               4. bv_rmpct

            2. box

               1. bv_box_org_mappings

      2. 02-transformation

         1. archibus

            1. agg_archibus_dept_code_min_hr_dept_number

            2. p_buildings_axiom

            3. u_hr2pr_exmployee_vw_pr_identities_archibus

      3. 03-integration

         1. archibus

            1. j_hr_org_mapping_archibus

            2. j_space_axiom

            3. j_space_charges_axiom

3. Denodo Scheduler

   1. findb_loadarchibus_buildings_axiom

   2. findb_loadarchibus_space_axiom

   3. findb_loadarchibus_space_charges_axiom

   4. archibus-unmapped-dp-ids-check

Vendor Connectivity

Because the vendor, Horizant, specifically wants to connect to Denodo from their end and pull data, rather than we push data to them, the following VIPs were created:

...

1. Connection is limited by IP address and port

2. Vendor is using a service account that will be regularly rotated

3. Connection is encrypted

4. Data is level 2 sensitivity

Vendor contact is sharwood@horizantsolutions.com