*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
- Move to Metadb software version 1.4
- once Metadb version 1.4 is released, work with hosting team to set up plans for testing new version on a separate Metadb Test database
- support reporting users as CUL moves to Metadb 1.4
- implement new data privacy features available in Metadb 1.4
- provide information sessions on new features
...
- Expand and Maintain CUL's collection of reporting queries on the cul-folio-analytics GitHub repository
- create new queries as needed and updated the code in existing queries
- update queries to reflect updates to Metadb tables after Sunflower
- reduced dependence on derived tables by revising queries to use JSON code extracts
- optimized query code to improve performance
- created modified versions of derived tables for CUL report needs and automate them to run daily
- Expand Migrate Report Automation
- waiting on developers to be assigned to a Spring 2026 software development sprint so Reporting Team can test Temporal for report automationdelayed by Temporal migration, so will start in spring 2026
- continue to support 30+ reports currently automated through DBeaver application
Consider new reporting applications over DBeaver EE considered other options, but agreed this is still the best tool for our team to use to create and manage code for report queries, derived tables, and dashboards - Contribute to Metadb Software Improvements
- Create Index Data
on data extraction project for Metadb version 1.4 - Review hosting team tickets Derived Table updates
- tickets for Metadb software issues as they arise
- Assess derived table updates needed for each FOLIO software release
- Work with EBSCO hosting team to optimize data synchronization efficiency (reducing number of tables via table exclusions) for Metadb
Worked - Work with Lauren Seney, Reporting PO from Index Data, to develop software development plans to support patron privacy and data anonymization in Metadb software development
- Create, Review, and Update Documentation for Queries and Dashboards
- documentation pages for both queries and dashboards created, reviewed, updated, and archived on the FOLIO Reporting Confluence site on an ongoing basis
- documentation for SQL queries created, reviewed, and updated in Markdown README.MD files on the CUL FOLIO Analytics GitHub repository on an ongoing basis
...