1 of 30

2 of 30

Fusion Dance:

Delivering OneRoster via the Ed-Fi Data Standard in the Field

Eric Hilfer - 1EdTech

Rosh Dhanawade - Education Analytics

3 of 30

4 of 30

History of the Work

​

Project Design

​

Solution Building and Delivery

​

Next Steps

​

Agenda

5 of 30

History of the Work

6 of 30

About

As a mission-driven non-profit, we are at the intersection of data and analytics to improve outcomes for students and the education system.

​

We work with state education agencies, collaboratives, and districts, including:

6

7 of 30

About the Partnership

7

  • 1EdTech and the Ed-Fi Alliance are working together to develop a coordinated rostering approach and scalable pathways for richer data integrations
  • The collaboration aims to
    • Enhance data driven decision-making
    • Maximize educator time for teaching
    • Align with data-driven policies to unlock state and federal funding
    • Reduce fragmentation across disparate EdTech products at both state and local levels
  • This is a community-driven initiative. Mutual community members are already building valuable integrations and there is support for a growing set of use cases enabled by rostering.

8 of 30

History of the Work

8

9 of 30

History of the Work

9

10 of 30

History of the Work - EA in TX

10

  • Solution needed for members of the Texas Education Exchange

​

  • App to create OneRoster 1.1 CSV

​

  • Data Moves from

Ed-Fi API ->

Enable Data Union (EDU) OneRoster Model ->

CSV Served in an application that Exchange users log into ->

CSV Delivered to OneRoster 1.1 Consumer

​

  • EDU Package requires configuration based on geography specific Ed-Fi specifics

11 of 30

Project Design

12 of 30

Project Design - Governance

12

  • How can Ed-Fi Governance and OneRoster Governance co-exist?

​

  • What are the ways in which any governance can be enforced?

​

  • Technical Artifacts to coalesce governance decisions

13 of 30

Project Design - Technical

13

MVP of an API-based OneRoster provider for Ed-Fi

  • Materialized views
  • Establish clear mapping conventions
    • Develop a detailed field-by-field mapping guide between OneRoster and Ed-Fi to ensure consistent data exchange
  • Align descriptors and enumerations
    • Develop an approach to configure Ed-Fi descriptors to match OneRoster's terminology
  • Implement robust identifier strategy
  • Address differences in authorization approaches

14 of 30

Project Design - Technical

14

15 of 30

Solution Building

16 of 30

Solution Building - Principles

16

Design Principles

  • Stay within the ODS database
  • Minimize excess structure creation
  • Leverage Descriptor Mapping domain flexibility
  • Adopt patterns that could translate from Postgres to MSSQL

Execution

  • Mapped OneRoster codes to Ed-Fi Core Descriptors
  • Deployed Materialized Views in Postgres with scheduled refreshes
  • Deploy companion API for integration with OneRoster consumer
    • Tested with OneRoster conformance testing suite

Next Steps

  • Porting to MSSQL and addressing lack of Materialized Views feature
  • Accommodating OneRoster scopes via the Ed-Fi API

17 of 30

Delivery - Demo

17

18 of 30

Delivery - Swagger UI

18

19 of 30

Delivery - Swagger UI

19

20 of 30

Delivery - Code

20

21 of 30

Get Involved

21

  • SEAs: SY 26-27 commitments to adopt the Ed-Fi OneRoster API

​

  • MSPs and Data Providers: align to integration

​

  • Steering Committee: governance and adoption

22 of 30

Next Steps

23 of 30

Next Steps

23

Hardening

Database-level and API integration tests.

​

Ensures data transformation accuracy

​

🔒

OAuth Provider

Ed-Fi integrated OAuth provider

​

Seamless login experience

🔒

Expansion

MSSQL and Data Standard 4.0

​

Unlocks broader pilot testing

​

​

📈

Auth Alignment

Integrate with Enrollment and Employment based Ed-Fi Authorization

🛡️

Multi-Tenancy

Support multiple Ed-Fi database instances via OneRoster API

​

Enables datahub and regional deployment

​

🏢

24 of 30

Next Steps - OneRoster Profile for Ed-Fi

24

25 of 30

Next Steps - OneRoster Profile for Ed-Fi

25

26 of 30

Next Steps - OneRoster Profile for Ed-Fi

26

27 of 30

Next Steps - Events

27

​

1EdTech Member Assembly

  • November 18-20, 2025
  • North Charleston, South Carolina

​

Learn More: 1EdTech | Ed-FI Collaboration

​

​

Contact RosteringProject@1edtech.org to get involved.

28 of 30

29 of 30

Scan the QR code below to submit any questions that didn’t get answered during the session or that you would like to follow up on!

30 of 30

Check out EA’s other sessions at Ed-Fi Summit!

30

Monday, October 6

Using the Ed-Fi Technology Suite to Support an Education-to-Workforce District Network

2:15 – 3 p.m. | Encino Room

​

​

​

A Practical Look at AI Tools in

Interoperable Systems

4:30 – 5:15 p.m. | Sabino Room

​

​

​

Fusion Dance: Delivering OneRoster via the Ed-Fi Data Standard in the Field

4:30 – 5:15 p.m. | Encino Room

​

​

​

Streamlining and Managing 30+ State and Local Assessments in South Carolina

4:30 – 5:15 p.m. | Zapata Room

​

​

​

Tuesday, October 7

Leveraging the Ed-Fi Technology Suite and the

Ed-Tech Collaboratory for Research

11:15 a.m. – 12 p.m. | Villa Room

​

​

​

Domain Expansion: Special Education and

the Ed-Tech Collaboratory

1:30 – 2:15 p.m. | Zapata Room

​

​

​

Turbocharging Ed-Fi ODS/API Deployments with EDU’s Speed and Efficacy

1:30 – 2:15 p.m. | Encino Room

​

​

​

Wednesday, October 8

Ingesting Data into the Ed-Fi ODS: A Deep Dive into Earthmover Bundles for Assessment

9:15 – 10 a.m. | Encino Room

​

​

​

Designing for Impact: Educator-Led

Product Development

10:15 – 11 a.m. | Sabino Room

​

​

​