The Time and Attendance optional component provides a generic interface directly to a SQL or Oracle database. All logic is contained in this service and you do not have to reconfigure the Doors.NET system.
This service connects Doors.NET to the Time and Attendance database. As cardholders are granted access at designated readers (setup is in the wizards below), the transaction is logged initially at the Doors.NET database and then this service duplicates that entry in the Time and Attendance database along with an in/out designation. This allows the Time and Attendance software to use its own database for reports without any modification.
The Doors.NET Time and Attendance integration consists of two modules; Configuration Wizard and a background Database Update Task. The Configuration Wizard is used for the initial setup. This allows you to designate "IN" and "OUT" readers, specify the location of the Time and Attendance database, and specify what parts of each Doors.NET access granted message should be copied into the Time and Attendance database. The Background Database Update Task runs silently in the background providing one copy of each Doors.NET access granted message into the Time and Attendance database as the events occur in real time.
Note: Prior to setting up the Time and Attendance Sync Service you must already have a 32-bit system DSN. This ODBC source must have the fields that you wish to be populated when the designated IN and OUT readers are used. You must also have the authentication credentials for connecting to the database.