Overview

The university’s new space management, Archibus (implemented and maintained by a vendor called Horizant Solutions), requires some integrations to move data to and from Archibus.

The integrations are the following:

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_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:

lb-denodo-prod-horizon.it.tufts.edu
lb-denodo-stage-horizon.it.tuft.edu
lb-denodo-dev-horizon.it.tufts.edu

These VIPs will only allow connections from the following hosts over port 9999:

tuftsuat.horizantsolutions.com - 40.85.228.240
tufts.horizantsolutions.com - 172.203.163.243

This approach was approved by OIS for the following reasons:

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