User`s guide

21-0381E v4.7.3
Welcome Report Control Admin Sys Config
Tech-Ref
345
Overview of Features
VEREX Dire ctor provides a number of
advanced database features:
• Database Query
: Provides database 'views',
allowing you ( or other software) to link to the
Director database to perform custom rep orting
tasks; • Automated User I mpor
t: Allo ws the
Director softw are to be interfaced w ith a
personnel management system (Also called
:
"E
nterprise Resource Management");
• SQL Server Support
: Allows your company's
IT department take charge of the data base
under SQL Server.
Note: These features are optional and/or depend on
your software licensing. Details: "System Capacities"
(previous).
Tip: Many o f the topics in this section ( >>)
either work together or apply to more tha n one
database feature. As such, it is very usef ul to
read all of these topics at least once before
you attempt to set up any of this.
SQL Server Support
Tips: This feature is NOT r equired to enable an y
other fe atures. Advanced dat abase featur es are
limited only b y software version and licensing. T his
feature has also been r eferred to as "Open
Database". Thi s term is being phased out d ue to
misinterpretation.
Introduction
Beginning with v4.7 for a typical installation,
the Director database uses SQL server
Express ( which is included) . You also have
the option of letting your company's IT
department take charge of the Director
database und er SQL Server (e.g., including
maintaining backups, etc.). With the initial
release of Director v4.7, SQL Server 2000 and
2005 are supported. In this case, the VEREX
Director datab ase will be p laced on your SQL
Server PC during softw are installation. This is
intended only for larger systems that are
already using SQL server to manage other
databases.
SQL Versions supported:
Version (2005) Note
Express Typical installation (managed by
the Director software).
Standard
Workgroup
Enterprise
SQL server installation option
(managed through SQL server).
Installing with SQL Server Support
During soft ware installation (and/or if yo u run
the database-generator utility on its o wn), you
will be aske d if you wish to manage the
database through a SQL-Server PC. If you
select "Yes", you will be asked for a numb er of
"User Logins" and passwo rds. These are
discussed in the following section ( >> ).
Using the DB-Generato r to S witch to SQL Serv er
Support: Befo re running the database gene rator
utility, ensur e you have an up-to-date backup of the
database (created with the cur rent/newest version of
Director soft ware), as this will be needed t o res tore
your data there after. Notice : If you accidentally
select SQL se rver support d uring a softw are
upgrade, s witching back to the standard a pproach
may re quire re moving and reinstalling the VE REX
Director software. You will be prompted accordingly
if this applies to you.
Advanced Database Features