Strategies for Data Out from the ODS/API - Report Out

Owned by Vinaya Mayya
Last updated: Nov 11, 2019
2 min read

The SIG collected and discussed data out use cases in user story collection sheet to inform on possible technical solutions to maximize benefits to the community.  This document summarizes the activity, along with potential next steps.

The SIG reviewed the collected use cases and grouped them to following use case categories:

  • Analytics
    • Self-serve analytics e.g. PowerBI, Tableau, AWS QuickSight
    • Off the Shelf Analytics e.g. Schoolzilla, Hoonuit, Spotlight
    • Customized vendor analytics
  • ODS to ODS Data Synchronization
    • State Reporting
    • Collaborative ODS
  • Vendor Integration
  • Assessment vendors, transportation vendors, food service vendors
  • System Integration
  • Internal systems - Badge, transportation, food service
  • Notification Service

The SIG considered the following technical options and discussed what is covered today and what could be improved and implemented:

  • Composites
  • Change Queries
  • Bulk JSON Export
  • Analytics Middle Tier
  • GraphQL
  • Web Hooks

The SIG analyzed the collected use cases and determined that the following are the top priorities.

  • GraphQL OR Out of the box Composites
  • Change Queries (with Improvements)
  • Analytics Middle Tier (+ API)

Informed by the information SIG offered, The Alliance is considering on the following course of action: 

  • Implement out of the box Composites for each domain and ship it with core ODS / API. Partner with a community implementation to evaluate the solution. Transition to GraphQL informed by that experiment. 
  • Improve Change Queries Delete endpoints for ease of use. Currently delete endpoints require the change consumer to maintain a log of source ODS resource identifiers to track the records that have been deleted.  
  • For most of the solutions data out of ODS isn’t ideal (including change queries) expose another data store via ODS / API that is optimized for reporting and/or curated and validated. 
  • As Analytics Middle Tier evolves consider API support
  • Investigate Dynamic Profiles, though not a data out winner by numbers it could be an important tool in facilitating data privacy. 

Slides 

SIG - Story Collection Summary - Next Steps.pdf