Control Buttons at the top:
Apply Settings: Applies the settings selected for all tabs.
Close: Closes the Window without applying settings.
Note: The previous screen will allow you to save the settings, once you have configured the settings and applied them.
General Settings - Use these options to set when the collector runs and other options.
Source Configuration - Use these options to select the folder where the CSV files are located and determine the file disposition when they have been processed.
Destination Configuration - Use this screen to configure the Collector's connection to the Citect SCADA Reports Server.
Data Source: This field specifies, in loose terms, the "Database/Datasource server name" where your Citect SCADA Reports 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 Citect SCADA Reports 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 Citect SCADA Reports 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 Citect SCADA Reports 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 Citect SCADA Reports 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.
Hach WIMS Collector Table: This is the table to connect to that will contain all the data that the utility collects from CSV files.
Test Connection: Test to see if the connection settings are valid and the collector is able to connect to Citect SCADA Reports database. This will NOT Apply or Save the settings.