Overview
GovWorx offers two ways to connect to Hexagon CAD depending on your particular deployment.
Direct Database Query
The Data Agent will read from a Hexagon replicated reporting database. Agent will run prebuilt read-only SQL queries on a customer determined time interval. To do this we will need a SQL reader user account to connect.
To prepare for this connection, we need the following details.
Configuration | Explanation |
Host | Host of the reporting database |
Username | Database user |
Password | Database password |
Database name | Database Schema to read from |
Use Integrated Security | Whether to use gMSA to authenticate to the database. Either enable this or supply both a username and password. |
Connect to availability group reader |
|
Include subtype in incident type | Report incident type as "{type}-{subtype}" |
Do not include system generated notes |
|
Use |
|
Use |
|
Lookback time in minutes (default: 30) |
|
Add EID to additional context | Depending on your configuration, either |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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
CSV file via SFTP
We have also worked with customers who want more control over the query to programmatically export and upload a CSV. See this article for more details on our SFTP flow.