Files from many partners
Local agencies and vendors send files in different formats on different schedules.
State agenciesWho we serve
Connect programs and partners.
Without another data store.
State programs exchange data with local agencies, vendors and the public. SentraBridge moves it through APIs, databases and SFTP files with every run logged, and keeps no copy of the records.
§ The problem
What gets in the way.
Open data that goes stale
Datasets on the open-data portal are updated by hand, so they fall behind the source system.
Data agreements
Every system that keeps a copy of shared data has to be covered by the data-sharing agreement.
§ How it works
How it works for state agencies
- 01ReceivePartner files from SFTP, or records from an API.
- 02CheckRules and value maps; bad rows go to a person.
- 03LoadUpsert into the program database.
- 04PublishPublic fields to the open-data portal.
§ What you get
Built for state agencies.
Open data publishing
Upsert records into Socrata / Tyler Data & Insights datasets on a schedule, with public fields only.
Learn more →Checks at the door
Rules and value maps clean and check partner data, and route bad rows to a person.
Learn more →Pass-through
Nothing is stored but settings, encrypted credentials and run metadata.
Learn more →Hosting options
CSP-hosted on US-based cloud infrastructure, or on agency servers, including air-gapped networks.
Learn more →A workspace per program
Each workspace keeps its own connections, flows, code tables, people and history apart.
Learn more →Lineage
Search a record ID and see every flow it went through.
Learn more →§ Examples
Flows that fit.
Generated from SentraBridge's ready-made templates.
OpenGov Permitting & Licensing → Socrata / Tyler Data & Insights
Publish OpenGov permits to the open-data portal
Nightly, upserts changed OpenGov permit records into a Socrata / Tyler Data & Insights dataset.
SFTP server → PostgreSQL / PostGISLoad the bank's daily payment file into the city database
Every morning, reads new payment CSV files from the bank's SFTP folder, cleans and checks them, loads them into a database table, and archives the…
Data quality alert (sub-flow)
A reusable sub-flow: other flows hand it the records that failed their checks, and it emails the data team a summary with a CSV attached.
§ Systems
Systems you likely run.
Each links to its connector page. Not listed? Any REST API, OpenAPI file, database or SFTP server works.
§ FAQ
Questions, answered
Can each program have its own workspace?
Yes. Workspaces keep connections, flows, code tables, people and history separate.
Does SentraBridge hold the data we exchange?
No. Records pass through in memory only. History keeps counts, timings and record IDs.
Can it run on agency servers?
Yes, including networks without internet access.
See your own systems connected.
We'll set up a workspace with your systems in a sandbox and build your first flow with you.