Any views expressed within media held on this service are those of the contributors, should not be taken as approved or endorsed by the University, and do not necessarily reflect the views of the University in respect of any particular issue.

Enterprise Architecture

Enterprise Architecture

Discussion and news from the Enterprise Architecture (EA) service

Estates data in data warehouse ready for testing

Following a pilot ingest of organisational hierarchy data, we are now loading fresh building space and building maintenance data in the new Enterprise Data Warehouse (EDW), and presenting it in a range of 22 reports. Once the testing phase is over, the reports will be available in BI suite.

The data is extracted from the source systems, Archibus and the Org Hierarchy database, every day or every week, depending on how fast a particular type of data changes. It is then stored in a foundation layer where it is stored long term, ready to be integrated with other data. From there, the data is presented in an access layer for consumption. At the moment, the access layer can be viewed in BI suite, but we’re working on making it available directly in PowerBI and QlikView/Sense too.

Both listings and diagrams of what fields are in the access layer at the moment, are available from the architecture repository.

Other data will follow into the enterprise data warehouse shortly; most immediately staff and finance data as a consequence of the implementation of the new core system.

Leave a reply


Report this page

To report inappropriate content on this page, please use the form below. Upon receiving your report, we will be in touch as per the Take Down Policy of the service.

Please note that personal data collected through this form is used and stored for the purposes of processing this report and communication with you.

If you are unable to report a concern about content via this form please contact the Service Owner.

Please enter an email address you wish to be contacted on. Please describe the unacceptable content in sufficient detail to allow us to locate it, and why you consider it to be unacceptable.
By submitting this report, you accept that it is accurate and that fraudulent or nuisance complaints may result in action by the University.