Overview
The Data Agent will read from the Motorola PremierOne Report Data Warehouse (RDW). To do this we need a user to connect. We read from the following tables:
MV_Incident
MV_IncidentUnits
MV_IncidentUnitOfficer
MV_IncidentComment
MV_ClonedIncidents
To prepare for this connection, we need the following details.
Configuration | Explanation |
Host | Host of the P1 RDW |
Use Integrated Security |
|
Username | Database user |
Password | Database password |
Database | Database Schema to read from |
Agencies |
|
Jurisdictions |
|
Use Report Number instead of Incident Number |
|
Use Time Offered for Call Received Time |
|
Use Incident Started DateTime for Call Received Time |
|
Use Initial Incident Type for Incident Type |
|
Filter Out Cloned Incidents |
|
Incident Type (NOT IN) |
|
MV_Incident view name override |
|
MV_IncidentUnits view name override |
|
MV_IncidentUnitOfficer view name override |
|
MV_IncidentComment view name override |
|
Exclude Location Description from Location |
|
Run Using Tables Instead of Views |
|