Skip to main content

Ed‑Fi Data Management Service: Moving to a Relational Backend

· 15 min read
Vinaya Mayya
Senior Technical Program Manager - API

Overview

The Ed‑Fi Data Management Service (DMS) is evolving toward a relational backend, shaped by community feedback and real‑world implementation experience. Building on the proven Ed‑Fi ODS/API foundation, DMS modernizes the storage layer to address long‑standing operational challenges—such as wide composite keys and complex joins—through targeted structural changes.

By prioritizing a relational backend, DMS preserves the core strengths of the ODS: predictable schemas, strong referential integrity, and compatibility with relational tooling. The result is a service that feels familiar to teams with ODS experience and lowers the cognitive and migration cost of adoption.

What This Means for Implementers

If you work directly with the ODS database today, DMS's data store will feel familiar, but with important structural differences:

  • You still work with the same Ed‑Fi entities and natural keys
  • Joins are simpler and narrower due to surrogate keys
  • Person identity is clearer and no longer mediated by ODS-only integers
  • Optional document caching can accelerate API reads

The sections below explain why these changes exist and how they affect database design and operations.

This post is written for database administrators, backend developers, data engineers, and solution architects who work with the Ed‑Fi ODS/API at the database level and are evaluating or planning a transition to DMS. Familiarity with the ODS schema and relational database concepts is assumed.

Introducing Fiona: A Helpful AI Assistant in the Ed-Fi Community Slack

· 2 min read
Robert Hunter, Jr
Robert Hunter, Jr
Software Engineer
Stephen A. Fuqua
Director, Software Engineering

We’re excited to announce the initial launch of Fiona, a helpful AI assistant available in the Ed-Fi Alliance community Slack workspace.

Fiona is designed to help educators, technologists, and administrators get quick answers about Ed-Fi technology, education data standards, APIs, implementation guidance, and related tools.

📢 Upcoming Ed-Fi OneRoster® Support in ODS/API 7.3.2

· 3 min read
Vinaya Mayya
Senior Technical Program Manager - API
Nathan Gandomi
Manager, Programs

The Ed-Fi Alliance and 1EdTech® are working together to better align standards and simplify rostering across the K–12 EdTech ecosystem.

State, regional, and local education agencies, vendors, and managed service providers (MSPs) are asking for simpler, more consistent ways to roster students and provision learning tools at scale. Today, managing multiple rostering patterns across states and products introduces friction — and slows down onboarding at the moments when students and teachers need systems to “just work.”

The Ed‑Fi Alliance and 1EdTech® have partnered to address that challenge through a coordinated solution that brings OneRoster 1.2 capabilities directly into the Ed‑Fi ODS/API. As part of this effort, we are preparing the Ed-Fi OneRoster API release and subsequent enhancements in ODS/API 7.3.2. Together, these updates streamline deployment and security, making it easier than ever for agencies to provide a OneRoster-compliant endpoint using data they already have.

Using API Tools to Review Data in the Ed-Fi ODS/API

· 6 min read
Stephen A. Fuqua
Director, Software Engineering

Overview

User Story: as an education agency staff member, I want to view the data loaded into the Ed-Fi ODS/API, so that I can compare to my local source of truth and ensure the correct information has been loaded.

Solutions: Use an API client to access the ODS/API, using key/secret credentials issued by the platform host. The ODS/API's Open API files ("swagger.json" metadata) provide documentation of available resources, and there are many robust tools that can read this file to pre-create HTTP requests for you. Bruno is currently my favorite such tool; Postman and Swagger UI are more well-known alternatives.

What about database access as an alternative? And how do these API clients help solve this problem? Read on for more on these topics.

Roadmap Update for the Ed-Fi Data Standard and Technology Suite

· 4 min read
Stephen A. Fuqua
Director, Software Engineering

The Ed-Fi Alliance continues to advance its mission of enabling interoperability and scalable data solutions for education agencies. At the recent Ed-Fi Alliance Summit 2025, we shared updates from the Ed-Fi Technology Roadmap, highlighted recent releases, and previewed what’s coming in the next few years.