SETDB

Selects a specific DB Provider and configure provider action timeout.

Supported Script Types

Generic Email Chat Phone Voicemail Work Item

Properties

GroupName

This property is the name of the database provider as configured by the NICE inContact administrator.

To find your DB Provider name, go to Central and click ManageAccount SettingsDB Connectors. This report will display your DB Provider name(s). If you have any questions about your DB Provider, contact your NICE inContact account manager.

This property is case sensitive. Enter the DB Provider name, not the Service name. The Service name is used when you set up your DB Provider.

TimeoutSec

This property is the maximum number of seconds to wait for a query to process.

The default is 120 seconds.

Branches

Default
The Default branch condition will be used unless another branch condition is met.
OnNotAvailable
This branch condition will be triggered when the selected DB Provider is not connected to NICE inContact.

Tips and Tricks

  • If you have multiple databases and do not identify which database to use, Studio will use the priority or the first one on the list.
  • You can also use SETDB to change the timeout allowed for query actions. The default timeout is 120 seconds. If you have a query that is expected to take longer than this, you can adjust the timeout accordingly. When a query action times out, the normal response is to resubmit the action to the provider. This may cause undesirable results if the first query is still processing. Typically, the timeout should only expire due to network related problems.
  • SETDB is also used to check the condition of a database provider. The Not Available branch condition will be triggered when the selected DB Provider is not connected to NICE inContact, due to maintenance or network failure. In this case, you can avoid processing query actions that will fail.
  • The DB Provider must be set up in Central prior to use.
  • Use SETDB to select the DB Provider following all SQL actions (SQLSELECT, SQLEXEC, SQLTABLE, etc.).