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 UPDATE: Jan. 23, 2019 - Hyperion is a tool that is used to query Operation Data Store (ODS) and other University data.  This tool has reached its useful potential and will be disengaged this year.  

Binghamton University Information Technology Services is currently analyzing and converting existing Hyperion queries and reports into the new SAS Business Intelligence platform.  Once all of the Hyperion queries have been converted, the system will be shut down. This should occur in the next few months. Contact the Help Desk with any questions.

Users may access Hyperion through Internet Explorer on PC and other browsers and Macs provide limited functionality.

Hyperion Log In

SAS UPDATE: Jan. 23, 2019 - Binghamton University has invested in the more efficient, state of the art Business Intelligence platform, SAS, which will be used for building custom reporting dashboards. It will be instrumental for querying the Operation Data Store (ODS).  As this environment is developed, training will be available through the University Training Center.  In conjunction with several University departments, ITS is currently transforming older Hyperion reports into the new SAS format.  


Metadata is data about data. This particular "data dictionary" lets users know what data they will find in the various ODS views (or tables). It lists each field's ODS name, a brief description of the data, the type of data (name, text, date, etc.) and the Banner form and field that the data comes from.

The metadata for the BU ODS tables is now available on the portal. To access the metadata, click 'Other.' Then, enter criteria in the search box.


You are able to keyword search the metadata, using the search field. In addition, you can enter an asterisk (*), thus returning a list of all tables, whereby the user can click on the individual table name to view it's content.