Date of Award

Fall 11-15-2015

Document Type


Degree Name

Master of Science in Information Systems (MSIS)

First Advisor

Stephen Krebsbach

Second Advisor

Chris Olson

Third Advisor

Marilyn Halgerson


The South Dakota Board of Regents (SDBOR) system, comprised of the six public universities, has undertaken a project to migrate the Colleague Student Information System from a proprietary Unidata database to an Oracle database. The conversion to the Oracle database will allow the ITS Administrative Computing staff more options to create programs that access the Colleague Student Information System.

During the conversion of the existing Unidata programs, it was discovered that the migration was causing us to lose our ability to keep track of programs that were developed to access the Colleague system. In addition, while we are gaining the option of using different tools to develop programs, we are also losing our ability to easily search through developed programs to find a specific program or search for a program that might contain a certain aspect that is desired. Users across campus have also asked multiple times if a certain program might exist to extract information they are looking for. We determined that there was a need for a system that would allow program information to be stored and accessed by ITS Administrative Computing staff and staff members across campus who have access to run programs against the Colleague Student Information System.

An ITS Program Database was incorporated into the existing Project Request System to allow access to the database in a location that is already accessed by staff. The ITS Program Database contains SQL tables to store program information and uses ASP.NET and C# WebForms to access the program information from the SQL tables. Table structure, WebForm designs, programming languages, and programming structure was determined from the existing Project Request System.

The outcome of the ITS Program Database project was a system that is user-friendly and easily maintainable. The ITS Program Database is accessible through the DSU Portal and linked to the existing Project Request System that is already used by staff across campus. Campus staff members are able to access a list of programs they have access to run. They also have the ability to search through their list of programs to find a program based on search terms. This project has given the ITS Administrative Computing staff a tool that allows the tracking of completed projects to avoid duplicate creation and the ability to search for programs created with a variety of tools.