Example exporting telemetry data to a microsoft, Access database – Printronix PrintNet Enterprise User Manual
Page 300
300
Chapter
7
Telemetry Data Export To 3rd Party Databases
Microsoft
®
Access™
OdvJdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
OdvJdbcUrl=jdbc:odbc:odv;UID=odvuser&PWD=odvpassword
OdvJdbcDbName=events
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData
NOTE: Date
is a reserved word in Microsoft Access.
Microsoft Excel
OdvJdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
OdvJdbcUrl=jdbc:odbc:odv
OdvJdbcDbName=[Sheet1$]
OdvJdbcDbFields=CaptureDate,FailureCode,DecodedData
Example Exporting Telemetry Data To A Microsoft
Access Database
This example shows how to create an Access database, connect it to the
AutoID Data Manager, and have the AutoID Data Manager export captured
telemetry data to the database.
To create an Access database:
1.
Open Microsoft Access.
2.
Select
File
New Database
to create a new database named
odv
.
(Use the
Blank
database template.)
3.
Click
New
to create a new table. Select
Design View
.
4.
Name the first field
ID
and define it as an
AutoNumber
field. This is
required since the database must have a unique key value for each
record. Each record sent from the AutoID Data Manager will be appended
to the database and the data in this field will be one greater than the value
in the previous record.