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

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_load_buildings

   2. findb_load_space

   3. findb_load_space_charges

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:

...