ED Dataset Service Documentation
Welcome to the ED Dataset Service documentation! This service provides direct database access to Ed Controls data for analytics and reporting tools.
What is ED Dataset Service?
The ED Dataset Service creates dedicated MySQL/MariaDB databases containing your project data in a structured format optimized for analytics tools like PowerBI, Tableau, Excel, and other business intelligence platforms.
Quick Start
Get connected to your data in just a few steps:
- Getting Started - Set up your first database connection
- Database Schema - Understand the data structure
- Analytics Tools - Connect your favorite tools
Key Features
- Direct Database Access: Connect any tool that supports MySQL/MariaDB
- Real-time Data: Access live data from your Ed Controls projects
- Structured Schema: Clean, normalized tables optimized for analytics
- Security: Dedicated databases with unique credentials per dataset
Supported Data Types
The service provides access to:
- Projects: Project information, dates, and locations
- Audits: Audit data, questions, answers, and templates
- Tickets: Issues, tasks, and custom field data
- Contracts: Contract information and project associations
- Users: User data and project participants
- Maps: Site maps and spatial data
Analytics Tools Integration
Connect with popular tools:
- Microsoft PowerBI
- Tableau
- Excel
- Google Data Studio
- Looker
- Any MySQL/MariaDB compatible tool
Next Steps
Ready to get started? Check out our Getting Started Guide to create your first database connection.