You must configure the connection and query to the Source LIMS database in order for the interface to work.

1. Click Configuration and select Source Configuration from the main menu:

2. Configure the connection to the LIMS Database

Configuration Template - two possible templates are included in the interface; one for MS SQL and one for
User Defined. These will fill in the most common values for the database connection.

DBMS Type - Select the database 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 source
database 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.

Connection Timeout in Seconds - how many seconds the program should wait when establishing a
connection to the source database server.

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

View Applied Connection String button will expose the currently applied connection string to source. Copy and
Paste operation can then be performed for use as a .udl file or with the Hach WIMS SQL_Console.exe program.

3. Configure the advanced settings.

Import Invalid Results as Hach WIMS Comments - When importing a result if the result is not a valid value for WIMS, import the result as a result comment. For example, the Result in LIMS is BB (for broken sample bottle) which is not a value that can be entered into WIMS (i.e. BB is not a symbol) the BB is imported as a Result Comment and the value in WIMS is left blank. NOTE: Will overwrite any existing result comment.

Ignore Case when matching between Source Identifiers and WIMS Variable Cross References - enable this
setting when you need to ignore case during matching to WIMS variable cross references.

Source Query: SQL Statement (query) that returns the LIMS Results to be imported. The SQL must return the following fields:

• SampleLocation - The Sample Location.
• SampleTest - The test/analyte for the result.
• SampleDate - The sample/collection date. The result will be stored in WIMS on this date/time.
• SampleResult - The value (result), only valid WIMS results will be imported. The general rule is if you can't enter the value in a WIMS data entry form it cannot be imported.
• SampleUnits - The result units (i.e. mg/L, %, ppb, etc...).
• SampleQualifier_1, SampleQualifier_2, and SampleQualifier_3 - These are three qualifiers that are combined and added to result comments.
• SampleDetectFlag - This is the detection flag of the result. If the value is 'N', it is converted to 'ND' - otherwise it is set to a blank.

You will need to use the "AS" SQL syntax to alias a field in your table to the required field names. For example:

Select dt_location.sys_loc_code as SampleLocation, dt_sample.sample_date as SampleDate, rt_analyte.chemical_name as SampleTest, ....

You can use the 'Concat' SQL statement to combine fields, such as the qualifier field with your result:

Oracle: SELECT CONCAT(Qualifier,Result) as SampleResult, ...

MS SQL: SELECT dt_result.lab_qualifiers + dt_result.result_numeric as SampleResult, ...