This is the source configuration screen for the Hach WIMS Direct Server-Side Interface to Custom TRA LabWare LIMS.

In order to configure source connection from the interface, click Configuration and select Source Configuration.

The next screen will display parameters on two tabs. The first is Database Connection:

• Configuration Template - two possible templates are included in Custom TRA LabWare LIMS interface; one for User Defined and one for MS SQL Server. These will fill in the most common values for the database connection.
  
• DBMS Type - Select the LabWare LIMS system type from one of these:
  
• Oracle
• Microsoft SQL Server
• Microsoft Access
  
• OLE DB Provider - this will be filled in with Configuration Template and DBMS Type, and can be modified if needed.
  
• Data Source - this field specifies, in loose terms, the "Database/Datasource server name" where your LabWare LIMS system is configured to store data.
  
• Database Name - name of the database instance
  
• Username - The username you want to use to connect to the database. This user should have permission to access the database and tables that contain data.
  
• Password - The password associated with the Username and is used to connect to the database.
  

• Advanced Configuration - these permit adjustment of the command and connection timeout.

• Connection Timeout in Seconds - how many seconds the program should wait when establishing a connection.
  
• Command Timeout in Seconds - specifies how many seconds the program should wait for a query to complete before aborting the operation.

The second tab is Advanced Settings:

• Source Tables Owner - Owner or schema (Oracle) of the LabWare database tables, default is dbo for MS SQL Servers

• Customers - Add customers to this drop down list for the interface to limit its search, the values here must match the values in the LabWare database table SAMPLE under the field CUSTOMER and are also defined in the Hach WIMS variable setup for LIMS_LOC field.

• Import Hach WIMS Comments - Enables or disables importing LabWare LIMS test comments into Hach WIMS

Ignore Case - If Enabled, then both the source data identifiers and the Hach WIMS variable cross reference will be changed to upper case. If Disabled, then both the source data identifiers and the Hach WIMS variable cross reference are used as-is (case sensitive matching).

SOURCE DATA EXAMPLE:

The following query is executed against the LabWare Database to retrieve records to be imported into WIMS.  It utilizes the LabWare Sample, Result, and Test Tables and gets records where the RESULT.CHANGED_ON field is within the import data range. 

SELECT ISNULL(S.TRA_DATE_SAMPLE_COLLECTED,S.SAMPLED_DATE) AS SAMPLEDATE, ISNULL(S.TRA_COLLECTION_SITE,S.SAMPLING_POINT) AS SITE, ISNULL(S.CUSTOMER,'TRA_CRWS') AS CUSTOMER, R.FORMATTED_ENTRY AS RESULT,  R.UNITS AS UNITS, S.STATUS AS STATUS, T.ANALYSIS AS ANALYSIS, T.TEST_COMMENT AS COMMENT 

FROM SAMPLE AS S, RESULT AS R LEFT JOIN TEST AS T ON R.TEST_NUMBER=T.TEST_NUMBER 

WHERE R.SAMPLE_NUMBER=S.SAMPLE_NUMBER AND R.CHANGED_ON >= '2011-05-10 00:01:41' AND R.CHANGED_ON < '2011-05-11 00:01:44' AND R.REPORTABLE='T'

AND R.FORMATTED_ENTRY IS NOT NULL AND ( (S.STATUS='A' AND S.CUSTOMER IN ('TRA_CRWS','TRA_MOUNTAIN_CREEK_RWS','TRA_RED_OAK_CREEK_RWS','TRA_DENTON_CREEK_RWS','TRA_TEN_MILE_CREEK_RWS','TARRANT_COUNTY_WSP')) OR (S.STATUS IN ('A','C') AND LOGIN_BY='SCHEDULER') )

ORDER BY S.TRA_DATE_SAMPLE_COLLECTED