User`s guide

352 VEREX Director V4.73 User's Guide 21-0381E v4.7.3
Introduction
VEREX Direc tor provides an automated user
import feature--allowing it to be interfaced with
a personnel management system (Also called
:
"E
nterprise Resource Management").
Caution
: Thi s requires so urce 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 a s
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 int erface typically includes cu stom
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 w hich is include d 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 s erver), you'll need to set this
through the table repair utility.
Details / Steps: See "User-Logins" (previous).
Automated User-Import (Used for: ERM Integration)