This article assumes that you have already launched the Campus Desktop through Citrix Workspace and have opened either Microsoft Access or Microsoft Excel. ODBC allows users direct, table-level access to the Banner databases.
See below for information on using the different methods available.
NOTE: Most views used will start with BANINST1, but may start with SATURN or other schemas. If you can't find your needed table/view, please contact ITS.
NOTE: If you wish to access the TEST or TREL Banner databases, select Advanced options, then type either DBQ=TEST or DBQ=TREL in the Connection String field.
NOTE: Most views used will use BANINST1 as the schema, but may start with SATURN or another schema.If you don't know the schema of the table/view you need, try BANINST1. If you need further assistance with this, please contact ITS.
NOTE: If you wish to access the TEST or TREL Banner databases, type either DBQ=TEST or DBQ=TREL in the Connection String field.