Capabilities

Capabilities	Supported
Connector Capabilities
Read	Yes
Backfill	No
Bidirectional Capabilities
Incident Create	No
Incident Update	No
Narrative Update	No

Overview

The Data Agent connects to a Microsoft SQL Server database using either integrated security or a username and password.

Network Requirements: The server running the Data Agent should be able to connect to the CAD Reporting server over port 1433. This can be tested using PowerShell.

PowerShell Command:

Test-NetConnection -ComputerName {CAD Reporting Server name or IP} -Port 1433

Standard Data Fields

These are the standard data fields the Data Agent reads from Omnigo. The tables below show each GovWorx field and the Omnigo table column it comes from. The Data Agent reads closed incidents.

Note: Additional fields are considered enhancement requests.

Incident fields

GovWorx field	Omnigo source	Notes
Incident ID	`CADEvent.ID`
Incident Number	`CADEvent.IncidentNumber`
Incident Type	`CADEvent.Category, CADEvent.SubCategory`	Joined as Category-SubCategory. Uses the one that has a value when the other is empty.
Caller Number	`tPhone.Number`	The first person linked to the event. Uses the phone of the linked establishment when the person has none.
Caller Name	`FWPerson.FirstName, LastName`	The first person linked to the event. Uses tEstablishment.EstablishmentName when there is no person.
Agency	`CADEvent.Police, Fire, EMS`	Joined with commas.
Agency Type	`CADEvent.Type`
Incident Date	`CADEvent.OpenedDateTime`
Disposition	`CADEvent.DispositionCode`	Uses CADEventAgency.DispositionCode when empty.
Location	`FWAddress.StreetNo, Street, AptSuite`
Priority	`CADEvent.Priority`
Latitude	`CADE911Call.Latitude`
Longitude	`CADE911Call.Longitude`
Call Position	`FWLoginAudit.ComputerName`	The most recent login of the call taker.
Call Taker ID	`CADEvent.OpenedDispatcher`
Call Taker Name	`tUser.DisplayName`
Call Source	`CADE911Call.ServiceClass`
Call Received Time	`CADE911Call.CallDateTime`	The earliest CAD note timestamp setting replaces this with the earliest note time.
Closed At	`CADEvent.ClosedDateTime`	The Data Agent reads incidents by this date.

Notes

GovWorx field	Omnigo source	Notes
Note ID	`CADEventNote.ID`
Note Text	`CADEventNote.Note`
Note By	`CADEventNote.UserName`
Note Time	`CADEventNote.CreatedDateTime`

Responders and units

GovWorx field	Omnigo source	Notes
Unit Name	`CADActivityLog.Unit`
Personnel ID	`CADActivityLog.Unit`	The unit name.
Dispatched By	`CADActivityLog.Dispatcher`
Dispatched At	`CADActivityLog.CreatedDateTime`	The earliest entry with status DISPATCHED.
Enroute At	`CADActivityLog.CreatedDateTime`	The earliest entry with status ENROUTE.
Arrived At	`CADActivityLog.CreatedDateTime`	The earliest entry with status ARRIVAL.
Cleared At	`CADActivityLog.CreatedDateTime`	The earliest entry with status CLEAR.

Data Agent Settings

To prepare for this connection, we need the following details. These are settings in the GovWorx Data Agent configuration for this connector. A toggle is an on/off switch in that configuration.

Setting	Type	Explanation
`Host*`	Text	Host on which to find the database
`Use Integrated Security`	Toggle	Whether to use Windows Authentication for the SQL Server connection
`Username**`	Text	Database username. Provide when not using integrated security.
`Password**`	Password	Database password. Provide when not using integrated security.
`Database name*`	Text	Database name
`First-run lookback in hours used only when no last-run cursor exists yet (default: 1)`	Number	How far back the first run looks, when the Data Agent has no earlier run to continue from. Default: 1.
`Maximum lookback in hours`	Number	Caps how far back a stale cursor can reach so an idle or reconnected connector does not issue an oversized catch-up query. Default: 8.
`Use earliest CAD note timestamp for Received At`	Toggle	Toggle will use the earliest CAD note time as Call Received Time. Use it when the first note marks the start of the call better than the CAD pickup time. Call Pickup Time does not change. When no note has a time, Call Received Time stays as read from CAD. Default: off. This setting is on every CAD connector.

*: Required

**: Required unless Use Integrated Security is on.

CAD Connector - Omnigo