Reporting database for dashboards
Records from 311, permitting and work orders are upserted nightly into SQL Server for Power BI reports.
DatabasesConnector
SQL Server integration
for city databases
Microsoft SQL Server and Azure SQL run many city systems: finance and HR reporting, older permitting and work order apps, and the reporting databases IT builds for dashboards. Most sit inside the city network.
Pre-built connector
Microsoft SQL Server
- Tier
- Pre-built connector
- Category
- Databases
- Sign-in
- Database login over TLS
- Paging
- single response
- Default port
- 1433
§ Overview
What connecting SQL Server does.
SentraBridge reads tables or a read-only query, writes with insert, update or upsert, and handles geometry and geography columns. Connections are encrypted by default. Flows can start on Change Tracking, and the relay reaches servers behind the firewall.
- Tables: Read a table or single SELECT query; insert, update or upsert rows.
- Changed rows: Read only changed rows with a changed-time column or SQL Server Change Tracking.
- Geometry and geography: Read and write spatial columns.
What SentraBridge can do with Microsoft SQL Server
| resource | read | write | changes only | fields |
|---|---|---|---|---|
| Tables | read a table or a read-only query | insert, update, upsert | yes (changed-time column) | Any table you grant |
§ Use cases
What cities connect SQL Server for.
Work orders from an in-house app
Rows changed in a department's own SQL Server app start a flow that updates the 311 request.
Load a staff spreadsheet
CSV files dropped in SharePoint are loaded into a SQL Server table and archived.
Points for GIS
Rows with coordinates are written with a geography column so the GIS team can map them.
§ How it works
How to connect SQL Server
- 01Get accessCreate a SQL login for SentraBridge; Windows logins aren't supported in containers.
- 02Add the connectionGrant SELECT on read tables and INSERT/UPDATE on write tables.
- 03Preview real recordsEnter host, port (1433 by default) and database; encryption is on by default.
- 04Turn it onFor on-premises servers, install the relay on the network.
§ Often connected with
SQL Server and the rest of city hall.
Systems cities commonly connect with SQL Server, each with its own connector page.
Sentra 311§ FAQ
SQL Server integration questions
Can SentraBridge connect to an on-premises SQL Server?
Yes, through the relay. It runs inside your network, calls out over HTTPS, and reaches only the hosts you list. No inbound ports open.
Can a flow start when SQL Server rows change?
Yes. Use SQL Server Change Tracking, or a changed-time column polled on a schedule.
Does it support Windows authentication?
No. Use a SQL login. Windows logins aren't supported from containers.
Does it work with Azure SQL?
Yes. The same connection works with SQL Server and Azure SQL.
§ Next
Related connectors
Connect Microsoft SQL Server to the rest.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.