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 our ERP, 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 and refreshed again mid-day beginning at noon. 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.