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 & 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 |
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 |
User* | SQL user username |
Password* | SQL user password |
Database* | Database Name |