Skip to main content
Direct SQL Access to Ed Controls

Your project data,
ready for analytics.

Connect PowerBI, Tableau, Excel, or any SQL-compatible tool directly to your Ed Controls project data. Clean relational schema, real-time sync, zero API complexity.

Get StartedView Schema
query.sql
SELECT
  p.name AS project,
  COUNT(DISTINCT a.id) AS audits,
  COUNT(DISTINCT t.id) AS tickets,
  ROUND(
    SUM(a.status = 'completed')
    / COUNT(a.id) * 100
  ) AS completion_rate
FROM projects p
LEFT JOIN audits a ON p.id = a.projectid
LEFT JOIN tickets t ON p.id = t.projectid
WHERE p.archived IS NULL
GROUP BY p.id
ORDER BY completion_rate DESC;
5 rows returned12ms
20+Relational tables
3xDaily sync
<50msQuery response
100%SQL compatible
Why ED Dataset Service

From document database
to actionable insights

Ed Controls stores data in a document database. We transform it into a relational schema you can query with any analytics tool.

Direct SQL Access

Connect any tool that supports MySQL or MariaDB. No API wrappers, no rate limits, no SDK required. Just write SQL and query your data.

Analytics-Ready Schema

Clean, normalized tables with indexed columns and proper relationships. Projects, audits, tickets, contracts, and users ready for reporting.

Automated Sync

Data synchronized multiple times per day with incremental and full sync options. Always work with the latest project information.

Database Schema

Clean, normalized data
designed for analytics

Your Ed Controls data is transformed from a document database into a relational model with indexed columns, proper foreign keys, and analytics-optimized table structures.

projects
PKid
name
status
startdate
enddate
latitude
longitude
+ more columns
audits
PKid
name
status
template
projectid
completiondate
+ more columns
tickets
PKid
title
status
responsible
projectid
dueDate
+ more columns
contracts
PKid
name
clientname
licenses
startdate
enddate
+ more columns
Explore the full schema
Compatibility

Works with every BI tool

Standard MySQL/MariaDB protocol. If your tool supports database connections, it works.

PowerBIFull setup guide available
TableauNative MySQL connector
ExcelVia Power Query / ODBC
LookerDirect database connection
MetabaseOne-click setup
Any SQL ToolMySQL/MariaDB compatible
Resources

Jump right in

Database Schema

Explore tables, columns, relationships, and indexes

Connect PowerBI

Step-by-step guide with ODBC setup and data modeling tips

Getting Started

Connect your first analytics tool in under 5 minutes

What's New

Latest features: audit labels, statistics dashboard, and more

Ready to get started?

Connect your analytics tools to Ed Controls data in minutes. No API keys, no SDKs, just a database connection.

View Setup GuideContact Support