Overview
The Data Agent will read from the SQL Reporting/Archive Database. To do this we need a user to connect.
The agent can also connect to the Training SQL database to enable Training CAD system use during simulations
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 |
*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
