DriveWorks Pro 22

Connectors - Database

Database Connector

The Database Connector continuously observes a table in a database and creates specifications from rows with specific values.

The Database Connector requires a valid database to monitor.

Setup the Data Source

The following settings are applied in the Data Source section of the settings screen.

1. Type - Specifies the type of database to be observed. The available options are:
   • SQL Server - Connects directly to a SQL Server database.
   • ODBC - Connects to a database through an ODBC connection. Information on creating ODBC connections can be found at the following links:
     • Microsoft Access databases see How To Setup a DSN - Access.
     • Other Databases see How To Setup a DSN - Other Database.
2. Server Address (When Type is SQL Server) - The Connector will list all SQL Servers that the computer can see. Select the required server from the drop down.

   Source (When Type is ODBC) - The Connector will list all ODBC connections set up on the computer. Select the required source from the drop down.

3. Username - Enter a valid username to connect to the data source.
4. Password - Enter a valid password for the username.
5. Is Trusted Connection (When Type is SQL Server) - Check if the data source requires a trusted connection.
6. Database (When Type is SQL Server) - Select the required SQl database to monitor.
7. Table Name - Select the table name to monitor.

Field Bindings

Once connected to a database and table (from the settings above) the fields from the table are read into the Field Bindings section and are listed in the Name column.

1. Set a binding Type for each field. The available bindings are:
   • No Binding - DriveWorks will ignore any fields mapped to this binding type.
   • Id Field - Used to mark a field type as an Identity Field.
   • Input Field - DriveWorks will pass the value in this field to a Constant or Control Name in the project.
     • Constant/ Control Name - Enter the name of the Constant or Control the value is to be passed into.

       For example: OrderNumber - Will first look for a Constant, and then a Control with the name OrderNumber.

       Constant Names should not be prefixed with DWConstant

       Control Names should not have Return appended to the name.

   • Process State Field (mandatory)
     The database must contain a field that DriveWorks can use to detect if a specification requires processing. The same field will be updated by DriveWorks to report its current status.
     • Process Value - Is the value that will allow the Connector to recognize a new record exists and is to be processed. The default value is set to New.
     • Processing Value - Is the value to be written into the field when the Connector is processing the record. The default value is set to Processing
     • Success Value - Is the value to be written into the field when the Connector has successfully processed the record. The default value is set to Complete
     • Failed Value - Is the value to be written into the field if the Connector failed to process the record. The default value is set to Failed
   • Project Name Field* - Is the name of a valid project in the Group the data is to be applied to.
   • Transition Name Field* - Is the name of a valid Transition (as created in Specification Flow) that will be run once the data has been passed to the new specification.
   * Note

   When the table has no field for Project Name or Transition Name, these bindings must be set in the Additional Options (see below).

Additional Options

The following additional options are available:

• Project Name - Use when only a single project can be processed by the connector and no field binding exists for this property.
• Transition Names - Use when only a single transition can be processed by the connector and no field binding exists for this property.
• Scan Interval - Set how often (in seconds) the connector will scan for new entries in the database.

See Also

Connectors

Web Service

Folder Watcher

Welcome to DriveWorks Pro 11 -What's New