Overview
The Data Agent has two ways to connect to Tyler New World Enterprise CAD. The agent can connect to a replicated SQL database or process XML files created at the time CAD was closed.
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. |
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.
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** |
|
Delete files after being processed | Whether to delete XML files after processing |
Use disposition as call closed filter | When configured true, only include incidents whose disposition is "Call Closed". |
Use closed time as call closed filter | When enabled, only process XMLs that contain the <CloseDateTime> tag. In progress XMLs do not contain this tag. |
*: Required.
**: Either Integrated Security or (Username and Password) is required.