Source Configuration for the Q14051 Interace

Parent Article

Refer to the image for the following text.

Database Connection Tab:

DBMS Type allows a user to specify database type

OLE DB Provider to enter the database provider

Data Source is the server and the instance of the SQL database (Server Name\Instance Name).

Database Name will point to the AuditMatic database

User ID and Password need to have permissions to execute select statements to the AuditMatic database

Timeouts are defaulted to 15 seconds for connection and 30 seconds for commands, it is not recommended that you change these.

Test Connection will only work after you save the settings

Advanced Settings Tab

SourceTable ID(s) a comma seperated list of Table ID's used with AuditMatic.

Load Table Loads a list of available Tables from the AuditMatic Database

Add Selected Once a user selects the Table IDs from the list, click Add Selected to add them to the Source Table ID's

Clear Clears Table Selections as well as the Source Table ID's

Ignore Case Allows the user to specify if the WIMS Variable Cross Reference data needs to be Case Sensitive (default is enabled).