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

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 the interface; one for MS SQL and one for Oracle. These will fill in the most common values for the database connection.
  
  
• Data Source - this field specifies, in loose terms, the "Database/Datasource server name" where your database system is configured to store data.
  
  
• 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 database system type, and can be modified if needed.
  
  

• 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 to the source server.
  
• 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 Facility List - Optional.  For customers with a large number of facilities this allows users to specify the facilities to pull data from.  This can greatly increase the speed of the interface.  Leave the list blank to search all facilities for data to pull. 
  
• Import Hach WIMS Comments - Enables or disables importing comments from Hach WIMS to Hach WIMS
• DefaultLastRunDate - Update if writing to CSV - Check this if you want the LastRunDate updated when writing output to CSV file
• Add Criteria to Source Query - Text in this box will be added to the Where Clause of the Source Query.  In this case this addition the query will filter the variable list.