Skip to main content

CAD Connector - Motorola Spillman

Written by Alex Montgomery

Overview

The Data Agent will read from the Spillman FLEX DEX API. To do this we need a user to connect.

User Permissions: The User needs permissions to the following tables:

CADMasterCallTable (cdcall & tab_cdcall)

CADCallHistoryTable (cdhist & tab_cdhist)

CADUnitTable (cdunit & tab_cdunit)

NatureOfCallTable (tbnatur & tab_tbnatur)

GeobaseAddressIDMaintenance (gbaddr & tab_gbaddr)

OfficerNameCodeTable (apnames & tab_apnames)

MasterPersonnelTable (pemain & tab_pemain)

MainNamesTable (nmmain & tab_nmmain)

CADCallCommentsTable (cdccomnt & tab_cdccomnt)

LoginLog (aplilog & tab_aplilog)

rlmain & tab_rlmain

rlofficr & tab_rlofficr

xmlquery

MAKE SURE

  • Login with this user once

  • Make sure the user can login from the machine the service is running on

To prepare for this connection, we need the following details.

Configuration

* required

Explanation

Host*

Host of the Spillman FLEX DEX API. Full URL with protocol and port (e.g. https://cad.example.net:4444/DataExchange/REST)

User*

Spillman API user username

Password*

Spillman API user password

Agency*

Filter to a specific agency.

Time Reported Hours

How far back we should pull data in each query. Default is 48 hours.

Use pemain

Setting on where we should pull data about users. Depends on Spillman licensed modules

Use main radio log

Setting on where we should pull data about users. Depends on Spillman licensed modules

Use complainant information

Setting on will override caller name and caller phone with the complainant information from MainNamesTable

Considered login machine names

SQL Connection

An alternative to using the FLEX DEX API we are able to query a replicated database directly. To do this you will need to create a SQL read only user on the replicated database.

Configuration

Explanation

Host*

Hostname of SQL Database

Username*

SQL user username

TOGGLE: Use Integrated Security

Password*

SQL user password

Database*

Database Name

TOGGLE: Use CDCall Reported Time as Incident Date

When true, use the call reported time as the incident date in CommsCoach. When false, the default, use the "opened" time from the call history view.

TOGGLE: Use complainant information instead of caller information

TOGGLE: Exclude table "aplilog"

CDCall table view name override

CDHist table view name override

CDCComnt table view name override

GBAddr table view name override

RLMain table view name override

APLILog table view name override

APNames table view name override

CDUnitO table view name override

TOGGLE: Adjust for UTC/local time zone mismatch


​Note: Fields marked with an asterisk (*) are required.

SQL Server Configuration Notes

To ensure a successful and secure connection, verify the following:

  • Firewall Access: Ensure the server hosting the GovWorx Data Agent can reach the SQL Server over the appropriate network and port (typically TCP 1433).

  • Minimum Permissions: The provided database user must have read-only access to relevant tables, views, or stored procedures. Write access is not required or recommended.

  • Instance Visibility: If using a named instance, confirm SQL Server Browser service is running, or explicitly provide the port number.

Troubleshooting Tips

  • Login Failed? Verify the SQL user is enabled and not locked out.

  • Timeout Errors? Check network routes and firewall rules.

  • Invalid Database? Ensure the database field in the config matches the actual schema name.

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

Did this answer your question?