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 * required | Explanation |
Host* | Hostname of SQL Database |
Username* | SQL user username |
Use Integrated Security |
|
Password* | SQL user password |
Database* | Database Name |
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. |
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 |
|