Back to Blog
Building the Connected Campus: How Strategic System Integration Transforms Higher Education
Brad McAllister
24 August 2025
7 min read
SITS:Visionautomation

In the rapidly evolving landscape of higher education technology, the ability to seamlessly integrate diverse systems isn’t just a technical skill—it’s a strategic imperative that can transform how universities operate and serve their students. Over the past six years at St Mary’s University, I’ve had the privilege of architecting and implementing technology solutions that demonstrate the power of thoughtful system integration, with SITS:Vision at the heart of our digital ecosystem.
The Challenge: Breaking Down Data Silos
Higher education institutions operate in a complex web of specialized systems, each serving critical functions but often operating in isolation. When I joined St Mary’s University as a Senior Full Stack Developer, I encountered a familiar challenge: SITS:Vision is designed for higher education providers to help manage all aspects of the student journey. From recruitment, student retention (e.g. absence management), to student outcomes (e.g. grade point averages), but realizing this vision required connecting it with the multitude of other systems that make a university function.
The reality is that SITS:Vision, also known just as SITS, is a database application used for course and student management in further and higher education institutions, developed and maintained by the Tribal Group. It is currently used by roughly 70% of the UK higher education sector, making it a cornerstone of university operations. However, its true potential is unlocked when it becomes the central nervous system connecting all campus technologies.
A Strategic Approach to Integration
My approach to system integration goes beyond simple data transfers. It’s about creating a unified ecosystem where student information flows seamlessly between systems, reducing administrative burden while improving the student experience. At St Mary’s, this meant orchestrating connections between over 20 applications, each serving specific institutional needs while contributing to a cohesive whole.
The Foundation: Active Directory Integration
The first critical step was implementing Active Directory integration for staff data management. This wasn’t just about single sign-on—it was about creating a single source of truth for staff information that could be leveraged across all connected systems. By integrating live HR data with SITS, we eliminated the manual effort of maintaining duplicate records and ensured consistency across all platforms.
Security and Access Control
With ACT Enterprise door control software integration, we extended the digital identity management beyond traditional IT systems. Staff and student data from SITS now seamlessly controls physical access to buildings, creating a truly integrated campus environment. This integration demonstrates how student information systems can extend beyond administrative functions to enhance campus safety and convenience.
Academic Resource Management
The integration with Exlibris library products (Alma and Leganto) showcased how SITS data could enhance academic resource management. By connecting student enrollment data with library systems, we created personalized learning experiences where students automatically gain access to course-specific resources, reading lists, and materials based on their SITS enrollment data.
Operational Excellence
Our MCR catering systems integration illustrates the breadth of possibilities when thinking creatively about data utilization. Student dietary requirements, meal plan enrollments, and event catering needs flow seamlessly from SITS to operational systems, reducing administrative overhead while improving service delivery.
The Learning Management Revolution
Perhaps one of the most impactful integrations was with Moodle LMS. By connecting SITS enrollment data with Moodle, we automated course enrollment, user provisioning, and grade passback processes. This integration eliminated the manual effort of maintaining course rosters while ensuring students have immediate access to their learning materials upon enrollment.
The synchronization works both ways—assessment data from Moodle can flow back to SITS, creating a comprehensive view of student progress and achievement. This bidirectional data flow is crucial for supporting student success initiatives and early intervention programs.
Managing Complex Transitions
One of the most challenging aspects of my role was leading the migration from a legacy student record system (QL) to SITS. This wasn’t just a technical migration—it was a fundamental transformation of how the university managed student data. The key was developing fresh export procedures that maintained system synchronization throughout the transition, ensuring no disruption to student services.
This experience highlighted the importance of phased implementation and robust data validation processes. Each integration required careful planning to ensure data integrity while maintaining system availability during the transition period.
The Power of Automation
By introducing automation for student union data and finance invoicing transfers using REST APIs, we demonstrated how modern integration techniques can streamline complex business processes. These automated workflows reduce manual effort, minimize errors, and ensure timely data updates across systems.
The implementation of enterprise version control through VersionSQL and Microsoft DevOps established CI/CD workflows that ensure reliable, repeatable deployments. This infrastructure supports the complex integration landscape by providing the stability and reliability required for mission-critical university operations.
Data Analytics and Business Intelligence
The creation of a robust Data Warehouse with Power BI Gateway represents the culmination of our integration efforts. By pulling together data from SITS and all connected systems, we enabled advanced analytics capabilities that provide insights into student success, operational efficiency, and institutional performance.
This integrated approach to data management transforms raw information into actionable insights that support strategic decision-making at all levels of the university.
Infrastructure Excellence
Supporting these integrations required managing a database estate of typically 45 SQL server instances. The successful upgrade from SQL Server 2012 to 2016 demonstrated the importance of robust infrastructure management in supporting complex integration environments. Each system in the integration landscape depends on reliable, performant database services.
Looking Forward: The Future of Higher Education Integration
The higher education technology landscape continues to evolve, with new challenges and opportunities emerging regularly. Over 140 institutions across 5 continents choose SITS:Vision – in fact over 60% of the UK HE market uses it! It is used by 12 of the 24 UK Russell Group of Universities including the University of Oxford. This widespread adoption creates opportunities for best practice sharing and collaborative development of integration solutions.
The move toward cloud-based solutions and API-first architectures presents new possibilities for even more sophisticated integrations. As universities increasingly adopt Software-as-a-Service solutions, the skills required for effective integration continue to evolve.
The Strategic Value of Integration Expertise
Effective system integration in higher education requires a unique combination of technical expertise, understanding of academic operations, and strategic thinking. It’s about seeing beyond individual systems to envision how they can work together to support the institution’s mission.
The ability to lead complex migrations, implement robust automation, and maintain large-scale database environments while ensuring seamless system interoperability represents a specialized skill set that’s increasingly valuable in higher education.
At St Mary’s University, our integrated technology ecosystem supports over 6,000 students and 1,000 staff members, processing millions of transactions annually while maintaining the reliability and security required for mission-critical operations. This success demonstrates the transformative power of thoughtful system integration in higher education.
Conclusion
The future of higher education technology lies not in isolated systems, but in integrated ecosystems that support every aspect of the student journey. By placing SITS:Vision at the center of a comprehensive integration strategy, we’ve created a technology environment that serves both operational efficiency and student success.
The skills required for this work—database management, system architecture, API development, and strategic planning—represent a unique combination that’s essential for universities looking to maximize their technology investments. As the higher education sector continues to evolve, the ability to create and maintain these integrated environments will become increasingly critical for institutional success.
Whether you’re planning a major system migration, implementing new integrations, or optimizing existing technology infrastructure, the lessons learned from building St Mary’s integrated campus ecosystem provide a roadmap for transforming higher education through strategic technology integration.