MarkVision Professional 10.2
June 1, 2004
MarkVision Professional 10.2
Page 5
1. Overview
MarkVision Professional allows you to collect comprehensive data on the physical devices
(Printer Inventory) and on submitted jobs to the devices (Job Statistics). The MarkVision
Professional database consists of a number tables, each prefixed with the word RAW. The next
prefix determines the table’s function:
JA
Job Statistics
PI
Printer Inventory
DS
Device Status
DeviceStatus
Device Status
PRN
Master Printer data table
Device
Master Device data table
2. Configuring Database Driver
2.1 Supported
Databases
2.1.1 Windows
•
Oracle (all versions from 8i through 10g)
•
SQL Server (6.5, 7.0, 2000)
•
Microsoft Access (97, 2000, 2002)
•
Comma-separated
variable
(CSV)
NOTE:
The ‘Oracle’ database option is only available after installing the up-to-date MVP Plug-in
for Oracle JDBC Driver support.
2.1.2 UNIX
•
Oracle (versions 8i through 10g)
•
Comma-separated
variable
(CSV)
NOTE:
The ‘Oracle’ database option is only available after installing the Oracle JDBC Driver plug-
in.
2.2
Creating Windows System DSN
Before you can enable MarkVision Professional to collect printer inventory or Job Statistics
information on windows systems, you must first configure the ODBC data source. The system
ODBC settings can be accessed from the system control panel.
Example 1:
Start
→
Settings
→
Control Panel
→
Data Sources (ODBC)
for Windows NT 4.0
Example 2: S
tart
→
Settings
→
Control Panel
→
Administrative Tools
→
Data Sources (ODBC
for
Windows 2000 and beyond
Once in the ODBC settings dialog box, click on the System DSN tab. The following box should
appear.