You must configure the connection 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.  For Oracle, choose User Defined.

DBMS Type - Select the database system type from one of these: 

• Oracle
• Microsoft SQL Server

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 Result 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 NS which is not a value that can be entered into WIMS (i.e. NS is not a WIMS symbol) the NS 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 Source records to WIMS variable cross reference fields.