Overview
The Data Agent has two ways to connect to Tyler New World Enterprise CAD. The agent can connect to a replicated/reporting SQL database or process XML files created at the time CAD was closed. The replicated/reporting database can be cloud hosted or on premise.
SQL:
To do this we need a user to connect to the database. You should create a read only user. The frequency the query is run is configurable and is typically set to every 8-10 minutes.
To prepare for this connection, we need the following details.
Configuration | Explanation |
Host* | Host of the database |
Use Integrated Security** |
|
Username** | Database user |
Password** | Database password |
Database* | Database Schema to read from |
Action ID | To determine the user and machine that created a call, we will use a specific |
Append ORIID to Incident Number |
|
Hours back to look for data (default: 2) |
|
Agencies to include (comma-separated) | Agencies to include in pulled data. Agencies not listed are excluded.The data agent processes XML files Tyler is able to deliver from either Cloud or On-Premise deployments and place them in a local or shared directory.
*: Required. **: Either Integrated Security or (Username and Password) is required. |
TOGGLE: |
|
TOGGLE: | Not able to utilize if using stored procedure |
TOGGLE: |
|
| Name of the stored procedure to use. Data agent uses its own query if left blank. |
TOGGLE: |
|
TOGGLE: |
|
XML Files:
The data agent processes XML files Tyler is able to deliver from either Cloud or On-Premise deployments and place them in a local or shared directory.
โ ๏ธ Tyler Generic XMLs do not contain CAD positional data
Configuration | Explanation |
UNC Share / Directory* | A local directory path or UNC share path. A UNC share path begins with two backslashes ("\\"). |
Use Integrated Security** | When configured true, authenticate using gMSA instead of explicit credentials |
Username** |
|
Password** |
|
TOGGLE: | Whether to delete XML files after processing |
TOGGLE: | When configured true, only include incidents whose disposition is "Call Closed". |
TOGGLE: | When enabled, only process XMLs that contain the <CloseDateTime> tag. In progress XMLs do not contain this tag. |
TOGGLE: |
|
TOGGLE: |
|
|
|
*: Required.
**: Either Integrated Security or (Username and Password) is required.
