...

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_archibus_buildings_axiom

   2. findb_archibus_space_axiom

   3. findb_archibus_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