The Banner Operational Data Store, also known as Banner ODS, extracts information from the Banner and Degreeworks databases, reorganizes the information into a simplified format, and stores the information in the Banner ODS database. The reporting views and materialized views in the ODS database are used as the primary source for Banner data in the Enterprise Data Warehouse.
✓ Davidson College developers, data analysts, and other employees who have sufficient training and permissions
✓ Data source for integrations
✓ ETL processes
→ Work within the ODS requires a working knowledge of relational databases and familiarity with writing SQL queries and is limited to advanced developers.
→ The T&I Data Management team provides technical support for the EDW.
The ODS includes Confidential and Restricted data. As such, access to data within the ODS is governed carefully by adding users to specific database roles, and these roles in turn are granted privileges on certain database objects like tables and views.