no edit summary
''Tiffany Schoneboom & Joseph Koivisto (University of Maryland)''
*Starting in 2018, the Consortial Library Applications Support (CLAS) group at the University of Maryland began a data warehouse design and implementation initiative to better serve the reporting and analytics needs of University System of Maryland and Affiliated Institutions (USMAI) consortium member institutions. Working in conjunction with a data warehouse architect, members of the CLAS team and applications developers from the Software Systems Development and Research (SSDR) developed an applications architecture to support the storage, dissemination, and use of integrated library system data in a web-accessible portal. Instrumental in this endeavour was the development of an extract-transform-load (ETL) framework to facilitate the exchange of data between library systems and data warehouse data layers. In this presentation, we will provide a brief overview of the project background and the activities undertaken to ensure the usability of our platform by consortial members. Furthermore, this presentation will provide an in-depth look at the development of ETL methodologies, the design framework that informed development activities, and a status report on current design and testing.