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

In order to configure source connection from the interface, click Configuration and select Source Configuration.

The next screen will display parameters to configure the interface connection to source database:

Database Connection

• Database Type - this is a drop down and can be either Oracle or Microsoft SQL Server, and fills in the OLE DB Provider field.
  
  
• OLE DB Provider - this is the OLE DB provider used to connect to the PCS SCADA Archive Database.
  
  
• Data Source - this field specifies, in loose terms, the Data Source Name to connect to the PCS SCADA Archive Database Server.
  
  
• Initial Catalog - this is the name of the database within the database server.
  
  
• User ID and Password - these are the user ID and password to gain access to the database server.
  
  

• 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 - how many seconds the program should wait for a query to complete before aborting the operation.

• Customization - this is used if additional parameters are need in order to connect to the source database.

Advanced Configuration

Additional configuration may be needed. The values shown above are the defaults, but can be changed.

• Database
• Table Name - Table name in the PCS SCADA archive database where values are stored.
  
• Owner/Schema - The owner or schema of the table name.
  
• Prepend Tag Text - Two possible values can be prepended to tag names when searching the PCS SCADA archive database. The method used for searching values is an 'OR'. Either text field can be filled in or blank. If both are filled in the comparision is to match on: (TEXT1 & TAG) or (TEXT2 & TAG) or (TAG).

Buttons:

This button will allow you to test settings before applying or saving them.

This button will allow you to copy and paste the connection string, for example, when configuring the browser in Using Interface Browser Q12693.

The other buttons are explained in Using Common Buttons.