Legacy permit tables to GIS
Permits in an older Oracle-based system are read nightly and added to an ArcGIS layer, with no change to the old application.
DatabasesConnector
Oracle Database integration
for city systems
Oracle Database sits behind many city permitting, utility billing, ERP and lab systems, often on servers inside the city network. Integrations have traditionally meant custom scripts, database links or nightly exports.
Pre-built connector
Oracle Database
- Tier
- Pre-built connector
- Category
- Databases
- Sign-in
- Database login over TLS
- Paging
- single response
- Default port
- 1521
§ Overview
What connecting Oracle Database does.
SentraBridge reads Oracle tables and views (12c and later, including 19c and 23ai, now 26ai) and writes with insert, update or upsert, including SDO_GEOMETRY points for GIS. Flows can start when rows change using a changed-at column. The relay reaches internal servers without inbound firewall rules.
- Tables and views: Read a table, view or a single SELECT query; insert, update or upsert rows.
- Changed rows: Start or filter flows on a changed-at column.
- SDO_GEOMETRY: Read and write point geometry for GIS.
What SentraBridge can do with Oracle Database
| 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 Oracle Database for.
Billing data to a reporting database
Account and payment views are copied to PostgreSQL so analysts don't query the production billing database.
Work orders to 311
Work orders created in an Oracle-backed system start a flow that updates the resident's Sentra 311 request.
Nightly CSV extract for a vendor
A view is exported as a dated CSV to SFTP for a vendor that needs a daily file.
§ How it works
How to connect Oracle Database
- 01Get accessCreate an Oracle user for SentraBridge; set Schema if tables belong to another user.
- 02Add the connectionGrant SELECT on read tables and INSERT/UPDATE on write tables.
- 03Preview real recordsConnect with the service name (like ORCLPDB1), not the SID; port 1521 by default.
- 04Turn it onInstall the relay inside the network if the database isn't reachable.
§ Often connected with
Oracle Database and the rest of city hall.
Systems cities commonly connect with Oracle Database, each with its own connector page.
Sentra 311§ FAQ
Oracle Database integration questions
Can SentraBridge connect to an Oracle database behind our firewall?
Yes. The relay runs on your network next to the database and only calls out to SentraBridge over HTTPS. You list which hosts it may reach.
Which Oracle versions are supported?
Oracle Database 12c and later, including 19c and 23ai (now Oracle AI Database 26ai). Connect with the service name, not the SID.
Can it trigger a flow when Oracle rows change?
Yes, with a changed-at column. SentraBridge reads rows changed since the last good run.
§ Next
Related connectors
Connect Oracle Database to the rest.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.