The generic LIMS Interface can be used with the Thermo SampleManager^TM (tested with Ver 11.2 SP1 running on SQL 2012 database) LIMS system.  See https://www.thermofisher.com/order/catalog/product/INF-11000 for more information on SampleManager. 

Example Query - Used in the Source Configuration, Advanced Settings Source Query field:

 Sample Manager stores the results in the RESULTS, TEST, and SAMPLE tables.

Select  Sampled_Date as SAMPDATE, SAMPLE.SAMPLING_POINT + ':' +SAMPLE.SAMPLE_TYPE AS SAMPLOC, TEST.ANALYSIS AS ANALYTE, RESULT.TEXT AS FINAL, RESULT.UNITS, RESULT.COMMENTS as RESULTCOMMENT, SAMPLE.SAMPLE_TYPE AS SAMPLETYPE,  TEST.DATE_COMPLETED , TEST.STATUS,

RESULTSTATUS = CASE WHEN TEST.STATUS ='C' THEN -6144 WHEN TEST.STATUS='A' THEN -4196 ELSE -6144 END

FROM SAMPLE, TEST, RESULT

WHERE SAMPLE.ID_NUMERIC=TEST.SAMPLE

AND TEST.TEST_NUMBER = RESULT.TEST_NUMBER

AND TEST.DATE_COMPLETED > '1/5/2017' AND TEST.STATUS IN ( 'A','C')