HID Asure ID 7.5 User Guide - Manual (Page 40)

Page 40 of 44 July 2014
Asure ID PLT-01485 Rev 2.0
9 Data Connection
9.1 Create a New Native Database – Access, SQL, Oracle
When you install Asure ID, it uses an Access database that stores configuration tables,
templates and cardholder data. To use SQL Server or Oracle as the native database, follow
these steps.
Step Procedure
1 Your System or Database Administrator runs a set of scripts to create all the database
objects required for Asure ID 7.
The Administrator directs the application to the database. If not finding the database,
generate a new database by selecting the required path. Upon the next start up, the new
database is accessed.
2 To install scripts:
Go to Program Files\HID Global\Asure ID\Scripts. Found are the following two files.
•
AsureID_MSSQL.sql
•
AsureID_Oracle.sql
The Administrator runs whichever set of scripts is applicable for the chosen database.
Furthermore, the Administrator creates a user that has Select, Insert, Update, Delete and Create
privileges.
3 After creating the required objects in the database, access the following.
[start]
[All Programs]
[HID Global]
[Asure ID]
[Data Connection Wizard]