University of California Santa Barbara Modernizes Student Information System -- Campus Technology

University of California Santa Barbara Modernizes Student Information System

By Leila Meyer
03/12/13

The University of California Santa Barbara (UCSB) has completed a strategic modernization initiative of its student information system (SIS). The university's existing SIS was a mainframe system running a Software AG ADABAS database in a Natural application environment with Entire X Broker middleware. The project involved converting the legacy system to the Microsoft .NET framework and a SQL Server database.

"UCSB needed a solution that allowed them to retain the proven functionality of their existing system while modernizing the look and feel," said Scott Miller, president and CEO of Ateras, the company that migrated the system. "It was also important to enable UCSB to leverage cost efficient new technologies, while eliminating the mainframe and vendor license fees."

Ateras used its own rapid program modernization solution, eavRPM, to change the green screen user interface of the core applications to a browser-based interface that uses ASP.NET Web forms. The company also used its DB-Shuttle migration solution to automatically convert the ADABAS database to SQL Server and batch-convert the Natural programs to the C# programming language, while retaining the existing logic and functionality of the Natural programs. The SIS modernization project didn't require any production code freezes. ATERAS used DB-Shuttle to import production code changes into the converted system periodically.

"The code and data conversion approach allowed us to preserve all business rules, exceptions, jobs, and interfaces that have been defined over three decades, while transforming the core information systems to the latest technologies," said Lubomir Bojilov , CTO and executive director of Student Information Systems & Technologies at UCSB, in a prepared statement. "This will allow us to step on a solid modern platform for designing and developing the next generation of applications, platforms, workflows, and data and analysis services."

The final migrated SIS is native to the Microsoft software stack and uses the features of ASP.NET, ADO.NET, C#, and object-oriented design. It contains no proprietary code and UCSB does not have to pay ongoing license fees to Ateras. The university's personnel can maintain the software in Microsoft Visual Studio and access the database using existing SQL Server tools.

The project was completed in two years and modernized 6,900 components, 1,460,000 lines of code, and 1,350,000 ADABAS database records.

About the Author

Leila Meyer is a technology writer based in British Columbia. She can be reached at [email protected].

E-Mail this page

Printable Format

Featured

CSU Shares AI Learnings in Systemwide Survey

In a systemwide survey of more than 94,000 faculty, staff, and students, California State University recently documented widespread AI use across its 22 campuses.
White House Releases National Policy Framework for AI

The White House has released a four-page AI policy framework aimed at setting a national approach to AI, with priorities including child safety, intellectual property protections, truth and accuracy guardrails, and worker training for an AI-driven economy.
Internet2: Closing the Access Gap for Research Cyberinfrastructure

Internet2's Research Engagement Team brings CIOs and other campus technology leadership together with research computing and data facilitators, forming a community that enables research cyberinfrastructure at institutions of all types and sizes.
It's Time for Higher Ed to Get Serious About AI Strategy

Without a coordinated strategy that involves multiple academic and administrative units across the entire campus, colleges risk wasting resources, duplicating efforts, and ultimately failing to deliver on the promise of deploying technology to improve learning and operations.