Overview
The Data Agent will read from the SQL Reporting/Archive Database. CSI will create a SQL view for the GovWorx Data Agent to query. To do this we need a database reader user to connect.
To prepare for this connection, we need the following details.
Configuration | Explanation |
host* | Host of the reporting database |
user* | Database user |
password* | Database password |
database* | Database Schema to read from |
Incident SQL View* | Database SQL View Name for CAD Incident data |
Responders SQL View* | Database SQL View Name for CAD Responder data |
Notes SQL View* | Database SQL View Name for CAD Narrative/Comments data |
*Required Field |
|
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