Purpose

1. To understand the Live Database View / CAD Mirror process
   

Live database view into a CAD mirror or a copy of CAD's database (read-only). First Due would access via a VPN or install a Connector. First Due would write the code to extract the dispatch information. CAD would be responsible for making the read-only view or CAD mirror accessible and timely. 

Pros 

1. Enables First Due to access all or most of the information CAD has of the incident.
   
2. As a "Mirror" or "View Only",  it does not require us to intrude into CAD neutralizing security concerns. 

Cons 

1. Requires a little bit of work from CAD to set-up but often less work than the below options.
   
2. Latency. CAD should push the data every 5 - 15 seconds. Longer gaps need to be avoided. 
   
   

NOTE - Any work required from CAD often requires approval. This approval process sometimes takes time. Please work on introducing First Due to your CAD connect ASAP. 

1. Provide a list of views that First Due Will be able to access for CAD data
   
2. Confirm the Database Type (MSSQL, PostgreSQL, MySQL etc)
   
3. Provide the schema/configuration for each view and there corresponding columns
   
4. Provide a dump of each of the views data (full dump is preferred but at a minimum 1000 records)
   
5. Confirm the method in which we can detect if a call is closed or open status (is_closed column, date_closed, etc).
   
6. Complete the provided CAD workbook