Setdb

This help page is for Studio. This information is also available for Desktop Studio.

Selects a specific database provider.

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.
Check the condition of a database provider. The Not Available branch condition will be triggered when the selected database provider is not connected to CXone Mpower, due to maintenance or network failure. In this case, you can avoid processing query actions that will fail.

Dependencies

The database provider must be set up in CXone Mpower DB Connector prior to use.
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.
Use Setdb to select the database provider for all SQL actions:

Supported Script Types


Generic	Email	Chat	Phone	Voicemail	Work Item	SMS

Input Properties

These properties define data that the action uses when executing.

Property	Description
Add Caption	Enter a short phrase that uniquely identifies this action in the script. The caption appears on the script canvas under the action icon.
Group Name	The name of the DB Connector group as configured on the ACD > ACD Configuration > DB Connectors page in CXone Mpower. This property is case sensitive. Enter the database provider name, not the Service name. The Service name is used when you set up your database provider.
Timeout Sec	The maximum number of seconds to wait for a query to process. The default is 10.

Property

Description

Add Caption

Enter a short phrase that uniquely identifies this action in the script. The caption appears on the script canvas under the action icon.

Group Name

The name of the DB Connector group as configured on the ACD > ACD Configuration > DB Connectors page in CXone Mpower.

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

Timeout Sec

The maximum number of seconds to wait for a query to process. The default is 10.

Result Branch Conditions

Result branch conditions allow you to create branches in your script to handle different outcomes when an action executes.

Condition	Description
Default	Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the action's other branches are not defined.
NotAvailable	Path taken when the selected database provider is not connected to CXone Mpower.