Utility integration hub
Hypothetical. Not a client, not a result.
// The problem
A multi-utility billing water, sewer and district energy runs a billing system, a meter data head-end, GIS, a work order system and finance software that do not talk, so staff export and import files every night.
// What we would build
An internal integration hub that joins the five systems through one API: meter reads flow to billing, new accounts reach the work order system, and service addresses stay in step with GIS. Each connector is built on the system's published API or export; we check yours before we quote. We run it for you, with monitoring and alerts.
// What is in it
- One internal API in front of billing, meter data, GIS, work orders and finance
- Meter reads checked and passed to billing, with exceptions held for review
- New and closed accounts passed to the work order system the same day
- Webhooks so a system hears about a change instead of waiting for a file
- Monitoring, alerts and a log of every message, run on a support plan
// Stack
- Node.js
- PostgreSQL
- OpenAPI
- Billing and meter data APIs
- ArcGIS REST API
- AWS Canada
// estimate
- Build
- ≈ US$60,200 to US$92,000, delivered within 15 weeksCAD 85,700 to 131,000
- Hosting
- ≈ US$176 a monthCAD 250 a month
- Support
- ≈ US$5,010 a monthCAD 7,135 a month
Prices in your currency are estimates from today's Bank of Canada rate. All invoicing is in CAD or USD.
Timeline by milestone
- API contract agreed
- 2.9 to 3.9 weeks
- Core resources built
- 2.9 to 4.9 weeks
- Security, gateway and connections
- 1.9 to 2.9 weeks
- Docs, SDKs and load tests
- 1.4 to 1.9 weeks
- Launch and first callers
- 0.9 to 1.4 weeks
Outside our hands, and added to the calendar
- Billing system API access from your vendor
- 1 to 4 weeks
How it is paid
- Deposit 20%
- CAD 17,140 to 26,200
- API contract agreed 8.7%
- CAD 7,455.90 to 11,397.00
- Core resources built 26.2%
- CAD 22,453.40 to 34,322.00
- Security, gateway and connections 17.5%
- CAD 14,997.50 to 22,925.00
- Docs, SDKs and load tests 8.7%
- CAD 7,455.90 to 11,397.00
- Launch and first callers 8.9%
- CAD 7,627.30 to 11,659.00
- Holdback, 30 days after launch (10%)
- CAD 8,570 to 13,100