This is the source configuration screen for the Hach WIMS Direct Server-Side Interface to Aspen 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 Aspen LIMS interface; one for MS SQL and one for MS Access. These will fill in the most common values for the database connection.
  
• DBMS Type - Select the Aspen 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 Aspen 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:

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

• Table field definitions

• Hach WIMS Facility - Identifies the field in Aspen that contains the Hach WIMS facility datatable name

• Hach WIMS VARID - Identifies the field in Aspen that contains the Hach WIMS VARID

• Sample Date Stamp - Identifies the field in Aspen that is used to set the Sample collection date/time.  This date/time is used as the date/time to store WIMS results at. 

• Source Tables Owner - Owner or schema (Oracle) of the Aspen database tables
  

• Ignore Case when matching between Source Identifiers and WIMS Variable Cross References - 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).

• Number of days for NT Service to go back from Start Date - This enables the NT Service to look back a number of days prior to the Last Ran Date for any data points that may have been updated but missed by previous imports.