CofC Logo

Data Warehouse

Data Warehousing at the College of Charleston

The College's current administrative systems live in a Transaction (or Operational) Database called Banner.  Reporting from a transactional database can unnecessarily tax the system.  Because of this, the College has implemented a Data Warehouse called the Operational Data Store.  It is a stand alone system, so that querying and reporting from it will have no impact on Banner.  Data is updated nightly beginning at 1:00 AM so that each morning the data reflected in reports matches the data that was in Banner by 1:00 AM.  All Cognos reports utilize data from either Banner or DegreeWorks, the College's degree audit application and academic advisement tool.

If you have an ODS modification request, please submit your request.