Using Object Access Reporting

What is Object Access?

Object Access is the reporting environment that was supplied by SCT with the Banner system. It is a technical architecture designed to meet customer ad hoc reporting needs. The theory behind Object Access is to combine the relevant information you use most from the Banner tables into one location. This location is called a view. Then, using the reporting tool of your choice, you can use the Object Access views to create reports. This architecture eliminates the need for extensive SQL knowledge to combine information from several tables into one report, because the information is already combined.

Components of Object Access.

Object Access is a set of views that are organized by Banner module subject area (General, Student, Finance, Financial Aid, Human Resources, Alumni/Development, Accounts Receivable). These views form the framework of Object:Access by bringing related information to one location as described above. Each view contains several fields of related information from various Banner tables. A single view can contain up to 255 pieces of information which are called “attributes” of the view.

How Does It Work?

Oject Access works works because of ODBC connectivity, short for Open DataBase Connectivity, a standard database access method. The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC manages this by inserting a middle layer, called a database driver, between an application and the DBMS. The purpose of this layer is to translate the application’s data queries into commands that the DBMS understands. For this to work, both the application and the DBMS must be ODBC-compliant — that is, the application must be capable of issuing ODBC commands and the DBMS must be capable of responding to them.

Using Excel

ODBC and sql*net must be installed on your computer.  If the software has not been installed on your computer, contact the Help Desk (ext. 2255). Make sure that you convey that you need to have your computer configured to use Excel with Banner / Oracle data (install Oracle Sql*net, MS ODBC and an oracle tnsnames file in the appropriate directory).

  1. Launch Microsoft Excel.
  2. In Excel choose Data.
  3. Choose Import External Data.
  4. Choose New Database Query.
  5. Choose <New Data Source>.
  6. Click OK.
  7. In area 1 of the Create New Data Source dialog box, type in a name for your data source. Choose Microsoft ODBC for Oracle for the driver.
  8. Click Connect.
  9. Enter your User ID, your Banner INB password, and the data base. Click OK.
  10. Click OK.
  11. Choose the data source.
  12. Choose the Table that you want to use.
  13. Choose the columns in the table that you’ll want to use by clicking on the appropriate table, then clicking on the > to move the columns that you want to query to the right pane.
  14. Click Next.
  15. Define any filters that you want to apply.
  16. Click Next.
  17. Define the sort conditions that you want to use.
  18. Click Next.
  19. Select Return Data to Microsoft Excel.
  20. Click Finish.
  21. Place the data in an existing worksheet (if appropriate), or create a new worksheet.
  22. Click OK.
  23. Format and analyze the data as appropriate.