Operational Data Store (ODS)
The Operational Data Store (ODS) is a repository of Banner data that has been formatted for querying and reporting purposes. The ODS database is separate from the Banner database. Therefore, running complex queries will not slow Banner performance.
Not all information in Banner will appear in ODS, and Banner entries do not immediately appear in ODS. It is updated (or refreshed) nightly between 2:00 am and 7:30 am. Also, ODS is read-only so users can’t accidentally delete information in ODS.
Hyperion is a tool that is used to query ODS and other University data. It is part of an Oracle performance management package. Hyperion gathers information from ODS and other University databases and allows users to generate spreadsheets, reports, charts and pivot tables.
Users may access Hyperion through Internet Explorer on a PC. Other browsers and Macs provide limited functionality.
Users may use pre-existing “canned” queries or create their own. For further information go to Training and Support.