Interlogix VEREX Director - Manual (Page 361)

21-0381E v4.9.1 Welcome Report Control Admin Sys Config Tech-Ref 353
Introduction
VEREX Director provides an
automated user import feature--
allowing it to be interfaced with a
personnel management system
(Also called: "Enterprise
Resource
Management").
Caution: This requires source
data with very specific structure.
Notice: For tasks involving the
'ErmUserImport' and
'ErmUserImportResult' tables, this
feature requires connecting using the
"ImportUserLogin" login name and password.
Conceptual Aspects
 Link/Database Query: Allows looking at
what's in the Director database (through the
database 'views' provided). This is covered
previously/above.
 ErmUserImport and ErmUserImportResult
Tables: The ErmUserImport table can be
updated by your custom software, and then
polled on a regular basis (configurable) by
the Director software, thus allowing user
information to be updated automatically.
When the information is imported, results
and errors will be posted to the
ErmUserImportResult table--providing
feedback on how things went.
Note: It is your responsibility to delete data as
needed to keep this table at a manageable size.
 Director's Automatic User Import Feature:
This allows setting up VEREX Director to
automatically poll the ErmUserImport table
(details to follow).
Software Interface ("Middleware") Tasks
The ERM interface typically includes custom
software that:
 Queries the database to verify present
content, and/or run custom reports;
 Writes data-commands (Add/Edit/Delete) to
the ErmUserImport table;
 Checks the ErmUserImportResult table for
errors,
(and deletes processed information to keep
the file to a manageable size);
 Prompts an IT / system operator to fix any
errors in the source data/commands.
Required Data Format
Refer to the "Director ERM User Import"
document which is included on the VEREX
Director CD.
Typical Systems (i.e., not running SQL
Server)
"Query User Login" information is required to
allow linking to the database. For a system set
to be managed under SQL server, you will be
prompted automatically for this during the
installation. With a typical system (i.e., NOT
using SQL server), you'll need to set this
through the table repair utility.
Details / Steps: See "User-Logins" (previous).
Setting Up Automated User Imports
Notice: As a precaution before setting up this feature,
ensure you have an up-to-date backup copy of the
database.
For details, refer to "Backing up or Restoring the
Database".
1) Select [Management] in the 'tree'.
2) Select Database Maintenance , and open
User Import .
3) Then, refer to the item-descriptions for this
screen while making your selections.
Screen Reference
Automated User-Import (Used for: ERM Integration)
[Management] Database Maintenance

User Import 