The Hach WIMS Direct Server-Side Interface to Custom TRA LabWare interface transfers lab results from an MS SQL LabWare LIMS system using custom queries specifically to meet a customers needs. The interface connects directly to the LabWare database and retrieves all records for specified customers in a specified date range. These records are then each matched to a variable setup in Hach WIMS where the lab result is imported and stored.

NOTE: This replaces OPSSQL_TRA_LABWARE which used three fields in OPSSQL: UD1, UD2, and UD3 (User Defined fields). The new Hach WIMS interface has to use the LIMS fields: LIMS_LOC, LIMS_TEST, and LIMS_UD1. These are directly one to one matched:

UD1 -> LIMS_LOC
UD2 -> LIMS_TEST
UD3 -> LIMS_UD1