User`s guide

292 Guardall Director V4.74 User's Guide 21-0381E v4.7.4
15) Now, select the Guardall Director database
view(s) that you want to be available to you:
When ready, click [ OK ].
16) Your selected Guardall Director database
view(s) are now linked to your new database.
Now, you can apply the full power of your
database software and programming skills to
meet your requirements (set up database
queries, etc.).
Understanding the Data
 SID is an account identifier.
 The remaining initial columns (up to 3 or 4)
comprise the "Primary Key" that uniquely
identifies each row.
 For details on additional columns, refer to
the specific screens in the Director software
(and/or the applicable help topics).
 For more information, and details on
encoded values, search your Director CD for
a file pertaining to "Database Views".
Automated User-Import (Used for:
ERM Integration)
Introduction
Guardall Director provides an automated user
import feature--allowing it to be interfaced with
a personnel management system (Also called
:
"E
nterprise 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 Guardall 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;