Configure and Manage the Bridge Client Pool
This topic describes how site admins can configure and manage pooling for Bridge clients. Pooling allows clients across the site to load balance data freshness tasks for data sources that connect to on-premises data.
The purpose of a pool is to distribute (or load balance) data freshness tasks among the available clients in a pool. Although the client in the pool that performs the data freshness task is chosen at random, if for whatever reason a client can no longer perform the task, the task is automatically rerouted to another available client in the pool to handle the task. There is no additional intervention required from you or your users to support or manage the pool of clients.
Pooling is optimized for keeping data sources that connect to relational data fresh. Pooling support does not extend to data sources that connect to file data because scheduled refreshes must be associated with a specific client.
In general, Tableau recommends pooling in the following situations:
Bridge is used as a critical service. If your organization requires that live query and scheduled refresh support must be available even if a client becomes unavailable.
Client is at capacity. If your existing site traffic is exceeding current capacity of the client.
Before configuring the pool
Before you can configure the client pool for the site, you must have clients installed, running and configured to run as a service, and authenticated into the client using your Tableau Online site admin credentials. For more information about deploying Bridge, see Plan Your Bridge Deployment.
Note: Prior to Bridge 2020.2, only live queries could be pooled. Scheduled refreshes for extracts could not be pooled.
Step 1: Ensure clients can connect to the site
In order for Bridge to work with your site, you must allow clients to authenticate to the site.
Sign in to Tableau Online using your site admin credentials and go to the Settings page.
Click the Authentication tab and validate that the Let clients automatically connect to this Tableau Online site check box under the Connected Clients heading is selected. For more information about this check box, see Access Sites from Connected Clients.
In addition to the site setting above, you must configure a Bridge-specific setting to enable pooling for the site.
While signed in to Tableau Online as a site admin, click the Bridge tab on the Settings page.
Under Allow Load Balancing heading, select the Allow load balancing across Bridge clients to keep on-premises data fresh check box.
After you enable and pooling for the site, users will see the option to maintain a live connection when they publish certain data sources that connect to on-premises data that Tableau Online can't reach directly. If they select the live option during the publishing process, Tableau Online associates their data source with the client pool automatically.
By default, version 2020.2 and later clients are included in the pool if the user authenticated into the client is a site admin. Follow the procedure below to add clients that were not automatically added to the pool or removed from the pool at some point.
While on the Bridge tab, under Client Status, navigate to the client you want to include in the pool.
In the Pool column, click the drop-down and select Default.
Repeat step 2 for each client you want included in the pool.
There are a few ways you can manage your pooled Bridge clients.
Monitor data freshness tasks
You can monitor client activity using a combination of the Jobs page and built-in admin views.
To monitor refresh jobs, you can use the following resources:
Jobs page: The Jobs page can show you the completed, in progress, pending, canceled, and suspended refresh jobs that use Recommended schedules. For more information, see About Bridge Refresh jobs.
Background Tasks for Non Extracts admin view: After filtering on Refresh Extracts Via Bridge, this admin view shows refresh jobs for data sources that use Recommended schedules. For more information, see Background Tasks for Non Extracts.
Bridge Extracts admin view: This admin view shows refresh jobs for data sources that use Bridge (legacy) schedules. For more information about this view, see Bridge Extracts.
To monitor live query activity, you can use the Traffic to Bridge Connected Data Sources admin view.
In the Client Status table, you can see a list of all the clients that are registered to the site, not just the clients that you're authenticated to. Clients can only be registered to one site.
The clients you see in this list can tell you the following information:
Client name, which is also the name of the machine the client is installed and running from.
Owner name, which in most cases is a site admin. This is the user who is authenticated to Tableau Online from the client.
- Pooled or not pooled:
Clients listed as "Default" are included in the pool and load balancing data freshness tasks. This means clients running live queries and scheduled refreshes for data sources ( live connections or extract connections) that connect to on-premises relational data.
Clients listed as "Not pooled" are, in most cases, specific clients that are set aside to run Bridge (legacy) schedules, which includes refreshes for data sources that connect to file data.
Note: Pools cannot be partitioned to handle live queries separately from refreshes.
A warning icon () displays in this column when the client is not running the latest version of Bridge. We strongly recommend upgrading to the latest version to take advantage of the latest security and feature updates.
Clients that are integrated with Tableau Desktop (versions 2018.1 and earlier) will not have version numbers listed.
Connection status—for more information see the section below.
Last connected—shows the day and time Tableau Online was last able to reach the client.
Client connection status
In the table of registered clients, the colored circles and status labels indicate the availability of the client to support data freshness tasks.
Green or "Connected": A green or Connected state indicates that the client is available to support live queries (live connections) and schedule refreshes (extract connections).
Red or "Disconnected": A red or Disconnected state can indicate one of a few conditions that have temporarily put the client in a disconnected state. The most common scenario is if the client is not running or was unable to establish communication with Tableau Online after being launched. You can hover the mouse over the status to see a tooltip that describes the condition.
- When the client is in a disconnected state, live queries might be disrupted. In cases like this, views that depend on data sources with live connections may properly display until the issue is resolved.
- When a client is in a disconnected state, However, extract refreshes continue to run on schedule and manual refreshes from the client can be initiated.
No color or blank: Clients that are integrated with Tableau Desktop (versions 2018.1 and earlier) can't show different states of availability.
The states described above reflect and correspond to the status you see in the client.
Bridge Refresh jobs fail with "errorID=NO_POOLED_AGENTS_CONNECTED" error
This issue can occur when a Recommended schedule job tries to run without at least one Bridge 2020.2 (or later) client in the pool. To resolve this issue, add at least one Bridge 2020.2 (or later) client to the pool. For more information, see Step 3: Add clients to the pool.
Bridge Refresh jobs fail with "errorMessage: Maximum concurrency reached" or "errorMessage: All agents are busy" errors
This issue can occur if the number of refresh jobs running at a given time exceeds the capacity of your client pool. To help resolve this issue, you can do the following:
- Add additional clients to the pool. For more information, see Step 3: Add clients to the pool.
- Increase the size of the connectionPool setting on each client. For more information, see Modify the size of the Bridge pool.
Bridge clients are being signed out
This can happen if you deploy a large number of clients under the same Windows services account. When there are more than 10 clients running under one Windows services account, account security measures can cause clients to be logged out. For more information, see Windows services account.