User`s guide

348 VEREX Director V4.73 User's Guide 21-0381E v4.7.3
Introduction
Director's "Database Query" feature allows you
(or your cus tom softw are) to link to the
database, and view or use the data as desired.
(This pertains to read-only database 'views '
(provided) that mirror the contents of the
database.) This allo ws setting up c ustom
reports (e.g., setting up your ow n cu stom
queries in M S Access, or using a program
such as "Cry stal Reports". Database 'v iews'
are also used with the auto user-import feature
(ERM integration).
Notice: To generate custom queries and reports, you
need to create a ne w (blank) d atabase, and link to
the Director database as discussed below.
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).
Auto-User Update (ERM Integration)
: This feature uses
the "Import
UserLogin' instead for any tasks involving
the 'ErmUserImport' and 'ErmUserImportResult' tables.
Linking to the Database to Generate
Custom Queries and Reports
The follo wing example and screens pertain to
using MS Access to link to the database.
1) In MS Access, open the File menu, and
select N
ew. Tip: From now on, I'll condense
menu selections (e.g., F
ile, ÖNew).
Double-click "Database".
2) In the next screen, give it a suitable name.
T hen, click [Create].
3) Select: File, ÖGet External Data, ÖLink
Tables like this:
Linking to the Database (Used for: Custom Query/Reporting; ERM Integration)