Sources and connectors
Every system the CDR connects to, how data is extracted, whether it is automated and scheduled, and what licensing or configuration it needs.
Required source systems (RFI section 1.9)
| RFI item | Source type | Connected in this repository | Status |
|---|---|---|---|
| A | On premises SQL Server | Tyler Munis, CAD, HR | Connected |
| B | PostgreSQL | Legacy performance metrics database (PerfDB) | Connected |
| C | Tyler Munis | Financials, Utility Billing, HR | Connected |
| D | Cityworks | Work orders and assets | Connected |
| E | EnerGov | Permits, inspections, code | Connected |
| F | ArcGIS / GIS | Parcels feature service | Connected |
| G | SharePoint | Parks program registrations list | Connected |
| H | Flat files | Landing folder with schema checks | Connected |
| I | SaaS systems | 311 CRM REST API | Connected |
Connector register
| System | Source type | Integration method | Automated | Schedule | Provided by | Licensing and configuration | Status |
|---|---|---|---|---|---|---|---|
| Tyler Munis (Financials, Utility Billing, HR) Uses the Munis reporting replica, not the transactional database. Tyler Data and Insights API is an alternative. | On premises SQL Server | Database connection with change data capture on the Munis reporting database | Yes | Nightly; hourly possible | Native connector | No added license; Tyler read access to the reporting database | Connected |
| EnerGov (Permits, Inspections, Code) Mapping versioned; schema change detection on every run. | SQL Server and REST API | API incremental by modified date, falling back to database view | Yes | Nightly; 15 minutes possible | Native connector | Tyler API access may require an EnerGov API license | Connected |
| Cityworks (Work orders, Assets) Geometry carried from the Esri asset layers. | SQL Server and REST API | REST API incremental; Cityworks database view for history | Yes | Nightly | Native connector | Cityworks API user | Connected |
| 311 CRM (SaaS) Near real time path tested at 15 minute micro batches. | SaaS REST API | API incremental with webhook for near real time | Yes | Every 15 minutes | Native connector | Vendor API key | Connected |
| CAD incident summaries Police and Fire approve the view definition. | On premises SQL Server | Change data capture on a summary view with no criminal justice information | Yes | Nightly | Native connector | None; CJIS data stays in CAD | Connected |
| Legacy performance metrics database (PerfDB) Retired after acceptance; kept read only for 90 days. | PostgreSQL | Database connection, full extract | Yes | Nightly until retired | Native connector | None | Connected |
| ArcGIS Enterprise and ArcGIS Online Writes back curated layers to ArcGIS as hosted feature layers. | ArcGIS / GIS | Feature service query (REST), geometry kept as spatial type | Yes | Weekly; on edit possible | Native connector | ArcGIS named user or API key | Connected |
| SharePoint Online lists and libraries Only named sites are granted. | SharePoint | Microsoft Graph export of lists and files | Yes | Daily | Native connector | Entra ID app registration with Sites.Selected | Connected |
| Flat files (CSV, Excel, JSON, Parquet) Files rejected when headers or types change. | Flat files | Secure landing folder (SFTP or storage container) with schema checks | Yes | On arrival | Native connector | None | Connected |
| Other SaaS (e.g. Laserfiche, NEOGOV, recreation software) Confirmed per system in Phase 0. | SaaS systems | REST API connector or vendor export | Yes | Nightly | Third party connector where no native one exists | Connector subscription where third party | Planned (Phase 2) |
| Power BI Row level security passes through. | Analytics and reporting | Direct connection to the curated layer and semantic model | Yes | Scheduled refresh or DirectQuery | Native | Power BI Pro or Premium per user, already licensed by the City | Connected |
Freshness by dataset
| Dataset | Connector | Method | Last extract window ends | Rows extracted to date |
|---|---|---|---|---|
| Parcels | ArcGIS Enterprise | Feature service snapshot | 11/11/2026 02:00 | 18,400 |
| CAD incident summaries | CAD (SQL Server) | CDC | 11/11/2026 02:00 | 38,600 |
| Work orders | Cityworks | API incremental | 11/11/2026 02:00 | 22,545 |
| 311 service requests | 311 CRM (SaaS) | API incremental | 11/11/2026 02:00 | 30,400 |
| Code enforcement cases | EnerGov | API incremental | 11/11/2026 02:00 | 2,350 |
| Inspections | EnerGov | API incremental | 11/11/2026 02:00 | 16,464 |
| Permits | EnerGov | API incremental | 11/11/2026 02:00 | 8,307 |
| Employees | HR (SQL Server) | Batch full | 11/11/2026 02:00 | 11,503 |
| Accounts payable invoices | Tyler Munis | CDC | 11/11/2026 02:00 | 15,300 |
| Utility bills | Tyler Munis | CDC | 11/11/2026 02:00 | 329,988 |
| Legacy performance metric values | Performance metrics database (PostgreSQL) | Database full | 11/11/2026 02:00 | 168 |
| Parks program registrations | SharePoint Online | File (Graph export) | 11/11/2026 02:00 | 3,240 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.