Selects a specific DB Provider and configure provider action timeout.
Supported Script Types
The name of the database provider as configured by the NICE inContact administrator.
To find your DB Provider name, go toCXone and, In the ACD application, click ACD Configuration → DB Connectors. This report will display your DB Provider name(s). If you have any questions about your DB Provider, contact your 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||The maximum number of seconds to wait for a query to process. The default is 10.|
|Path taken unless the script meets a condition that requires it to take one of the other branches. It is also taken if the other branches are not defined.|
|NotAvailable||Path taken when the selected DB Provider is not connected to CXone.|
Tips & 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 CXone, 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 CXone prior to use.
- Use Setdb to select the DB Provider following all SQL actions (Sqlselect, Sqlexec, Sqltable, and so forth).