This article assumes that you have already launched the remote desktop application (Windows App) and have opened either Microsoft Access or Microsoft Excel. ODBC allows users direct, table-level access to the Banner databases. Please go to Launching Campus Desktop for ODBC Connections (How-to) for more information.
NOTE: If you are a new ODBC user, or if you get an 'Invalid Username/Password' error, you may need to sync your password; please go to https://password.drake.edu/sync/ and log in to sync your password for ODBC use.
See below for information on using the different methods available.
- In the Link Tables dialog box, select each table/view to highlight it for use, then select OK.
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.
- Request to select a unique record identifier
- If you get a request to select a unique record identifier, click Cancel to continue.
- The new table/view will now display on the left side of the application.
- From the Ribbon Bar in MS Excel, select the Data tab.
- Then select Get Data, then From Other Sources, then From ODBC.
- From ODBC dialog box, select the Data Source Name Drake ODBC, then select OK.
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.
- If asked, enter the following:
- Oracle User Name - generally follows the format: first initial, middle initial, last name
- If you do not know your Oracle user name, please submit a BANNER/DUSIS Issue request
- Drake Password
- From the Navigator dialog box, select the table/view you wish to access, then select Load.
- If selecting multiple tables/views, check the Select multiple items check box before selecting tables/views.
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.
- If you receive the error: Restricted data type attribute violation, please use the steps in Connecting to MS Excel (Alternate Method) to access this table/view. Otherwise, the requested table/view should being loading.
Use this method if you are receiving errors when using the standard method
- From the Ribbon Bar in MS Excel, select the Data tab.
- Select Get Data, then From Other Sources, then From ODBC.
- In the From ODBC dialog box, select the Data Source Name Drake ODBC, then select Advanced Options.
- Enter the SQL statement to select the proper table/view, then select OK.
- SQL Statements are generally in the format "Select * [asterisk] from [Schema].[table/view name]" (e.g., "Select * from baninst1.as_du_advisor_major_tbl")
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.
- If asked, enter the following:
- Oracle User Name - generally follows the format: first initial, middle initial, last name
- Drake Password
- From the next dialog box, verify the expected information is displayed for the table/view you wish to access, then select Load.
Some applications may use the natural Windows interface to connect; if this is the case, use the process below.
- Enter Service Name
- There are three options for Service Name:
- PROD - This is the LIVE (PRODUCTION) BANNER DATABASE.
- You can also use DUSIS as a Service Name.
- TEST - TEST Banner database is recreated with cloned data from PROD each month.
- TREL - Test RELease Banner database is primarily used for upgrades and patches released by Ellucian, the vendor for Banner.
- Enter your Oracle user name
- Generally follows the format: first initial, middle initial, last name
- Enter your Drake password