Live Database View / CAD Mirror

Live Database View / CAD Mirror

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. 

In order complete the development of a dispatch connector for First Due we require the following information:
  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

    • Related Articles

    • Connecting First Due to CAD

      Purpose This article reviews the various types of connections that First Due uses when setting up CAD links Importance of Connecting First Due to CAD The following are just a few of the many benefits of enabling First Due to receive dispatches from ...

    • Activities: Activities Log - Daily View tab Overview

      Purpose To give an overview of the Daily View within the Activities Log. Video Directions 1. Navigate to Activities then select on Activities Log. 2. Click on Daily View tab. 3. Advance through prior days or upcoming days by clicking on the arrows. ...

    • CAD Reconciliation

      Purpose To demonstrate the features and navigation of the CAD Reconciliation Report. This report will break down information from a CAD connection and incident documentation. Video Directions 1. Click on Reports. 2. Click on Incidents. 3. Change the ...

    • Incident Type (CAD to NFIRS) Mapping Template

      Purpose To provide the Incident Type (CAD to NFIRS) Mapping Template and instructions for use. Overview The Incident Type (CAD to NFIRS) Mapping Template is designed to assist in the auto-population of NFIRS incident types in your incident report ...

    • Activities Log: Calendar Tab Overview

      Purpose To explain the features of the Calendar view within the Activities Log. Video Directions 1. Navigate to Activities, click on Activities Log. 2. Click on Calendar tab. 3. Use the search fields to customize what appears in the Calendar view. ...