To configure your Hach WIMS Direct Server-Side Interface to Custom Q13415 LabVantage LIMS:

1. Open Source Configuration.
   
   
   
   
2. Setup the Database Connection Tab:
   
   
   
   Configuration Template: The template will set up default values for an Oracle database connection.
   
   DBMS Type: This is used to specify the source database backend. The options are Microsoft SQL Server or Oracle. You can use this to select the default OLE DB Provider for each database backend.
   
   OLE DB Provider: This specifies the OLEDB driver to use to make the connection to the database backend. If you do not know what this is, you can use the DBMS Type to pick the typical default Provider for you by picking your database backend type. Type in the provider you would like to use if the current one is unavailable.
   
   Data Source: This field specifies the location of the datasource. This is typically the computer name or IP address that houses the database. If you are running Microsoft SQL, your Data Source maybe instanced. If that is the case you may use ComputerName\InstanceName. Type in your data source.
   
   Database Name: The database that houses your source data. Type in the name of the database.
   
   Username: The user loggin that you wish to use for this interface's connection to the database. This is a user in the database security. This user will need read privledges on the selected database. Type in a username.
   
   Password: The password that corrosponds to the username specified. Type the password.
   
   Connection Timeout in Seconds: When connecting to the database, this number specifies, in seconds, how long to wait before timing out.
   
   Command Timeout in Seconds: When the interface issues a command to the database, this number specifies, in seconds, how long to wait before it decides that the database connection has timed out.
   
   Customizations: This section is used for adding additional fields to the constructed connection string. This field is for advanced users and is not required for a typical connection.
   
   
3. Setup the Advanced Settings Tab:
   
   
   
   
   Import Hach WIMS Comments: This option allows comments to be created in the Result Comments section for a datapoint in Hach WIMS. This is useful for situations where certain values could not be parsed. It is recommended to leave this On.
   
   Source Table Owner: This is the owner of the source.
   
   Source Table: This is the source table to retrieve data from.
   
   Use Collection Date for Manual Import: This option allows you to specify a date range of the SDATEST date in the database, which is the collection date, along with the date updated. To use this option, select the Enable option and then enter the Start Date and End Date range for the collection date. The interface will import data using the collection date range and updated date range.
   
   Ignore Case: This option will ignore case sensitivity when Enabled is selected. Setting to Disabled will make the interface case sensitive when performing cross-referencing between source data and Hach WIMS variable setup.
   
   
4. Return to the Database Connection tab and press the Test Connection Button.
   
   
5. Save Settings and Close.