Printronix PrintNet Enterprise - Manual (Page 303)

Exporting Telemetry Data To A Microsoft SQL Database
303
Exporting Telemetry Data To A Microsoft SQL Database
Here is the set up for the Microsoft SQL database using ODBC connectivity:
1. Using Notepad, create an AutoID Data Manager properties file named
pm.txt that contains the following text:
# Microsoft SQL Connection Using ODBC
OdvJdbcDriver=sun.jdbc.odbc.JdbcOdbcDriver
OdvJdbcUrl=jdbc:odbc:odvsql
OdvJdbcDbName=events
OdvJdbcDbFields=PrinterAddress,DecodedData
2. Rename the file pm.txt to pm.pro and place it into the program
installation directory.
3. SQL database name is odvsql .
4. Table name is events .
5. Field names: PrinterAddress , DecodedData
6. Make sure the SQL ODBC driver is in the Windows Data Sources –
ODBC. You can use either Client or Server, dependiing on where the
AutoID Data Manager resides.
7. Use the same Jar files from the default AutoID Manager.
8. Make sure the SQL database has the same field names as pm.pro .
9. Make sure that you use window authentication .
10. Run the AutoID Data Manager and collect the telemetry data.
The collected telemetry data will be inserted into the odvsql database.