Data Source: This field specifies, in loose terms, the "Database/Datasource server name" where your Cimplicity system is configured to store data. For MS SQL this is in the form of host\sql_instance_name.

Database Name: This is the name of the database that contains the Cimplicity data.

Database Type: Currently only MS SQL Server is supported

OLE DB Provider: This specifies which "database driver" the interface will use when connecting to the Cimplicity database. If connecting to MS SQL 2005 or later, use the native client to connect. Specify SQLNCLI as the provider. NOTE: You will need to have the Microsoft SQL Native Client installed for this to work. If connecting to MS SQL 2000, specify SQLOLEDB as the provider.

Username: The username you want to use to connect to the Cimplicity database. This user must have the rights to view the database tables that contain the data.

Password: The password you use to login into the database.

Connection Timeout in Seconds: How many seconds the program should wait when establishing a connection to the Cimplicity database before aborting.

Command Timeoutin Seconds: Specifies how many seconds the program should wait for a query to complete before aborting the operation.

WARNING: Large values for these two settings can cause the program to not respond for a long period of time! Do NOT use 0 unless you know what you are doing - it will cause the program to wait indefinitely, and if your database server is down, the only way to cancel the operation is to forcefully quit the program.

Customizations: This should be left empty unless you were told otherwise by a Hach Support Engineer or you know what you are doing.

Test Connection: Test to see if the connection settings are valid and the collector is able to connect to Cimplicity database. This will NOT Apply or Save the settings.

Data Table Mappings - This is where you tell the collector which tables contain the Cimplicity data. The utility needs to know which tables to monitor, the name of the column that contains the Timestamp and the name of the columns that contain data. By default it is assumed that the first column is the Timestamp and all the other columns contain data. Note: The contents of the second and third column change as you click on the Table name in the first column. That is, column two and three contain the contents of the table that is selected in the first column.

Data Tables: Click on the list of tables that contain data you want the utility to monitor. When you select a table the other two columns are populated with the contents of that table. You can select one or more tables.

TimeStamp Column: The utility needs to know which column in the database contains the timestamp. By default the first column will be assumed to contain the timestamp. One, and only one, column must be checked.

Data Column: The utility needs to know which columns contain data that you want to monitor. By default every column but the first will be assumed to contain data. At least one column must be checked.

Reload: If changes were made to the database or the database connection, click this button to refresh the data tables. If no tables are listed after clicking the button check your database connection and confirm that the username chosen has permission to view the data tables.

Check All: Checks all the items in the data column except the first one.

Tag Picker - Use this tab to select the tags that you want to collect data for. The previous tab was telling the collector which tables and columns contain data. Basically, all the data that is available to the collector. This tab is telling the collector which of those columns/tags you want to collect data from. You must configure the Data Table Mappings before using this tab.

All Available Tags: This is a list of all the tags that are available in the system that we can collect data for.

Filtered Tag List: This is the list of tags that we will collect data for.

Search Boxes: The search boxes allow you to search the list of tags for a particular string. The search will start from the currently selected tag (or the top if nothing is selected) so you can continue to press the search button to find the next match.

OK: Closes the Window. Changes will not be saved or applied until the Save and Apply Settings button is clicked on in the Settings form.