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 ...
    • Web Responder: Station View

      Purpose To explain the setup and functionality of a Station View. Station View provides a "First Due Station Monitor" that can be set up as a static display that scans through incident details or displays new incident information as it becomes ...
    • 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 ...
    • Assets Swap History: View Swap History Details

      Purpose The purpose of this article is to demonstrate how to view swap history details. Related Articles Equipment Swap Over from Fleet Overview Swapping Equipment When an Apparatus is Placed Out of Service Video Instruction 1. Select Swap History ...
    • 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. ...