Services
Data services for multiple sectors
Pick a single service or hand us the whole data platform. Every engagement starts with a free consult and a written scope.
01
Scope a sync
Data synchronisation
Keep the systems your organisation runs on in step with each other, automatically, so nobody re-keys a record twice and every report starts from the same facts.
- Dynamics 365 CRM integration: accounts, contacts, leads, cases and custom tables kept in sync with finance, student and marketing systems
- One-way, two-way and hub-and-spoke sync between CRM, ERP, finance, HR, student, learning and custom systems
- Real-time (webhooks, change data capture) or scheduled runs
- Connectors via API, file drop, SFTP, email report or direct database, including systems with no API at all
- Field mapping, validation, de-duplication and conflict rules as configuration, not code
- Idempotent writes, automatic retries, exception queues and alerts when a record cannot be processed
- Verification that source and target match after every run
Typical syncs
| From | To | What |
|---|---|---|
| Dynamics 365 CRM | Finance, student system | Accounts, contacts, enquiries, cases |
| Student system | Dynamics 365 CRM | Families, enrolments, alumni, donors |
| Bank and payment feeds | Ledger, warehouse | Transactions, payouts, balances |
| HR / payroll | Identity, finance, rostering | People, roles, costs |
| Any source | Warehouse | Everything, with history |
02
API development & integration
When your data needs to reach partners, portals, mobile apps or other systems, a well-designed API is the cleanest way to do it. We build them, and we integrate the ones you depend on.
- REST and GraphQL APIs designed from your data model, with OpenAPI documentation
- Authentication and authorisation: OAuth 2.0, API keys, Entra ID, role-based access
- Versioning, rate limiting, caching and monitoring built in from day one
- Dynamics 365 Dataverse Web API, Power Automate and custom connectors for Power Platform
- Integration with third-party APIs: payment gateways, government services, SaaS platforms, partner systems
- Serverless or containerised hosting on Azure or AWS, sized to your traffic and budget
- Automated tests, staged rollouts and instant rollback
Every API ships with
- Interactive documentation
- A sandbox environment for your partners
- Request logging and usage dashboards
- Alerts on errors and latency
03
Plan a dashboard
Reporting & dashboards
With every system feeding one governed warehouse, reporting stops being a monthly scramble and becomes something managers can trust on any day of the month.
- Data warehouse on SQL Server, PostgreSQL or Snowflake, in Australian regions
- Clean, documented data models for finance, CRM pipeline, operations, HR, students and families
- Power BI, Tableau or Looker Studio dashboards designed with the people who will use them
- Scheduled report packs delivered by email, Teams or SharePoint
- Row-level security so each team sees only its own data
- Full history retained, so last year's report still reproduces
Common dashboards
| Area | Examples |
|---|---|
| Executive | KPI scorecard, budget vs actual, headcount |
| Finance | Cash, receivables, revenue, project margin |
| Operations | Throughput, SLAs, exceptions, capacity |
| Sales and service | Pipeline, retention, response times |
| Education / community | Enrolment, attendance, participation, outcomes |
04
Book a health check
Database maintenance & support
Databases are easy to forget until they are slow, full or gone. We keep them fast, backed up and current, on a schedule, with evidence.
- SQL Server, Azure SQL, PostgreSQL, MySQL, Oracle and MongoDB
- Health checks: backups, integrity, index and statistics maintenance, failing jobs, disk and growth
- Performance tuning: slow queries, indexing, blocking, configuration
- Backup strategy and regular restore testing, so recovery is proven, not assumed
- Patching, version upgrades and migrations, including on-premises to cloud
- Security review: access, encryption, auditing, least privilege
Maintenance plans
| Plan | Includes |
|---|---|
| Health check | One-off review with a prioritised findings report and fixes for the urgent items |
| Monthly care | Scheduled maintenance, monitoring, monthly report, business-hours support |
| Managed | Everything in monthly care plus upgrades, capacity planning and priority response |
05
Talk about your school
School system integration
Schools run a dozen platforms that each hold part of the truth about a student. We connect them so enrolments, classes, groups, rosters and attendance flow automatically and match everywhere.
- Student information systems: Veracross, Synergetic, TASS, Compass, Sentral, SEQTA
- Learning platforms: Canvas, Schoolbox, Moodle, including course, section and enrolment sync and grade pass-back
- Co-curricular and activities: Clipboard, with teams, sessions, rosters and attendance synced back to the student system
- Dynamics 365 CRM for admissions, enrolment pipeline, alumni and fundraising, synced with the student system
- Timetabling, identity (Entra ID / Google Workspace), finance and parent communication platforms
- Nightly and near-real-time syncs with reconciliation reports your registrar can read
- Reporting across all of it: enrolment, attendance, participation and outcomes in one place
Typical school syncs
| From | To | What |
|---|---|---|
| Veracross | Canvas | Students, staff, courses, sections, enrolments |
| Clipboard | Veracross | Activities, teams, rosters, session attendance |
| Canvas | Veracross, warehouse | Assignments, submissions, grades |
| Student system | Dynamics 365 CRM | Enquiries, families, alumni, donors |
| Student system | Identity, finance, comms | Accounts, fees, families |
| All of the above | Warehouse and Power BI | Reporting with history |
Not sure where to start?
Send us a short description of the systems you run and where the data gets stuck. We will suggest the smallest useful first step.