Accessing the SQL Database

The ICPAM SQL database can be accessed by third-party Time and Attendance (T&A) systems to view personnel, time, and attendance, and user tracking data.

The database views are not visible by default. Use the MySQL Query browser to display the database views.

CAUTION!               Do not modify the SQL tables. Use the following instructions to browse the tables only. Changing the tables or data can result in ICPAM errors or system failures.

To view the ICPAM SQL database, complete the following procedure:

Step 1  If necessary, contact Identiv technical support to obtain the database username, password, host and schema.

Step 2        Install and launch the MySQL Query Browser, and enter the server and login information supplied by Identiv technical support.

Step 3        In the Schemata pane (right column), expand the vxdb entry and scroll down to the bottom of the list to display the entries for personnel_vw, time_attendance_vw, and user_tracking_vw.

my_sql_query_browser.png

Step 4            To view the database entries:

a.  Double-click on the table name to enter a query in the Query field.

b. Click the Execute button

The data is shown in the browsing area.

 

See the following for topics of the SQL data views:

·         Personnel View

·         Time and Attendance View

·         User Tracking View