Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Student Information System - Database

    campusM Logo wh bkg sm1.png

    Product Information

    Category Student Information System (SIS)
    Sub-category  
    Website  
    Product version Database
    Documentation  
    API Documentation  

    About Student Information Systems

    A student information system (SIS), student management system, school administration software or student administration system is a management information system for education establishments to manage student data. Student information systems provide capabilities for registering students in courses, documenting grading, transcripts, results of student tests and other assessment scores, building student schedules, tracking student attendance, and managing many other student-related data needs in a school. A SIS should not be confused with a learning management system or virtual learning environment, where course materials, assignments and assessment tests can be published electronically. 

    The SIS can include features that can be considered as an enterprise resource planning or ERP system for a corporate customer. As such, many of the issues with ERP system selection methodology, implementation, and operation of an ERP system apply too..

    Integration Overview

    The campusM integration with Student Information Systems provides several services. Click on each of the services below to find out more information:
    • Class Schedule (Timetable): displays students’ class schedule by month (on web), weekly (on app), allows student to view details for a specific class
    • Finances: displays students’ finance transactions
    • Grades: displays students’ final grades by semester
    • My Advisor: displays students’ personal advisors and their contact details
    • Holds: displays student's current holds including a link to Banner for additional information
    Click on each of the above services for detailed information.

    Integration Method

    • Database tables or views

    Prerequisites 

    There are several prerequisites to the campusM integration with a Student Information System:
    Prerequisite Additional Information
    Provide Database Connection Details
    • Hostname
    • Port
    • Database name
    • Username
    • Password
     
    Ensure the Connect Layer server(s) can connect to the database and run queries  
    Provide Database View names for each of the following:
    • Class Schedule
    • Grades
    • Finances
    • My Advisor
    • Holds
    Please see individual services’ to review the specific supported database view structure 
    Provide a minimum of three (3) test accounts containing  comprehensive and typical data, including the following:
    • Class Schedule
    • Grades
    • Finances
    • My Advisor
    • Holds
     
    Provide ID mapping and lookup method:
    • Username or numerical student ID 
    • LDAP lookup or SAML attribute
     
    • Was this article helpful?