Manage Connectors and Groups

The following tasks are presented in the order you would perform them to set up DB Connector for your organization. Note that when opening the DB Connector application, be sure to run it as an administrator (right-click → Run as Administrator).

Create Connector Groups

You can create multiple connectors and group them to provide redundancy and continuity in case one of the connectors fail. You can also create different connector groups for connectors that serve different purposes. When you create a DB Connector group, it also appears in the DB Connector application on the DB Connector server.

If you are not creating multiple connectors or do not plan to use multiple connectors for failover, you can safely skip this step.

  1. In the Admin application, click ACD ConfigurationDB Connectors.
  2. Click New and select DB Connector Groups.
  3. Type a Name and Description.
  4. Click Create DB Group. Your new group appears in the tree view in the list of the left pane, and also appears in the Group drop-down when you create connectors. You also gain access to additional tabs so you can configure the group.
  5. Click the Contacts tab.
  6. Click Edit. Enter the contact information for the person at your company who should be contacted in case of a database connector failure. You can provide a Name, Email, and Phone Number.
  7. Click Done.

Create Connectors

When you create a connector, it also appears in the DB Connector application on the DB Connector server.

  1. In the Admin application, click ACD ConfigurationDB Connectors.
  2. Click New and select Database Connectors.
  3. Type a Name and Description.
  4. For Group, select the group to which this connector should be assigned from the drop-down of available groups.
  5. Type a numeric value in Thread Pool. A thread pool is the number of concurrent tasks (or threads) that run at the same time. This parameter can be tuned to provide the best performance. A larger thread pool increases resource use but may allow for faster results. The default value is 50.
  6. Click Create DB Connector.

Configure a Connector Health Check

You can optionally configure connectors to test their connection to the database every 30 seconds. This "health check" is an SQL query that you set up (such as a simple select query). You cannot configure a health check for a connector while it is registered as a Windows service. You must either configure the health check before registering the connector, or unregister the connector and then re-register it after the health check is set up.

  1. In the Admin application, click ACD ConfigurationDB Connectors.
  2. Click the connector for which you want to configure a health check and then click the Health Check tab.
  3. Click Edit.
  4. Select the Enable 30 second interval Health Check checkbox.
  5. In the Query to run field, type a simple SQL query to be executed using the DB connector.
  6. Click Done.

Configure Connector Groups

Once multiple connectors have been created and assigned to a connnector group, you can edit the group to configure the Connector Priorityand Failover properties. Failover is an optional configuration that enables the system to switch to a different connector if the specified connector fails. Connector priority tells the system which connector should receive commands by default and the order in which connectors will be used in the case of a failover.

While connector groups are most commonly used specifically for multiple connectors that work together for failover protection, you could use groups to organize different connectors that are used for similar purposes. In that scenario, you would not configure Connector Priority or Failover properties for the connector group.

You cannot configure groups if one or more of the connectors in that group is registered. You would first need to unregister the connectors, configure the group, and then re-register the connectors.

  1. In the Admin application, click ACD ConfigurationDB Connectors.
  2. Click the desired group from the Groups column.
  3. Click the Failover tab and then click Edit.
  4. Select the checkbox for Allow Failover to next DB Connector in Group.
  5. Click the Connector Priority tab and then click Edit.
  6. Click the icon to the right of each connector's number in the Order field to change that connector's position in the list. By default, connectors in a group are used in the order in which you created them.
  7. Click Done.

Configure the Connector Data Link

You must configure connectors and connector groups before you perform this task in the DB Connector application. You cannot configure data links for connectors that are registered. If you need to reconfigure the data link for a connector that is actively running, you must deactivate the connector, then stop it and finally unregister it in the DB Connector application. When you have finished your configuration, reverse those steps to put the connector back into production: register and start the connector in the DB Connector application, and then activate it in CXone.

  1. Open the DBCCFG application on the DB Connector server.
  2. Click the connector you want to configure.
  3. In the Reminder to Activate dialog, click OK.
  4. Click Configure above the Connection String field.
  5. In the Data Link Properties dialog, click the Provider tab and then click the provider type for your database.
  6. Click OK.

Register or Unregister Connectors

Connectors must be registered to run as Windows services on the DB Connector server. You cannot configure any aspect of a connector while it is registered. You can unregister a connector if you need to reconfigure the data link, the connector group, and so forth.

  1. Open the DBCCFG application on the DB Connector server.
  2. Select the connector you want to register or unregister.
  3. Click Register or Unregister if the connector was registered previously.
  4. In the Reminder to Activate dialog, click OK.

Start or Stop a Connector

Once a connector has been configured and registered, it must be started in order to pass data. You can also stop the connector if necessary to make configuration changes or to uninstall it.

  1. Open the DBCCFG application on the DB Connector server.
  2. Click the connector you want to start or stop.
  3. Click Start, or Stop if the connector is already running.

If you want to uninstall the DB Connector from the DB Connector workstation, you must stop all connectors. You can then use the Programs and Features functionality in Windows to remove the application.

Activate or Deactivate a Connector

Connectors cannot be used in Studio scripts until they are activated.

  1. In the Admin application, click ACD ConfigurationDB Connectors.
  2. Click the connector you want to activate or deactivate.
  3. Click Activate, or Deactivate if the connector has previously been activated.