Connectivity with Bridge
When data sources or virtual connections connect to private network data that Tableau Cloud can't reach directly, Tableau Bridge is used to facilitate connectivity.
Connection types
Tableau Bridge supports on-premise data or data in a virtual cloud that is behind the firewall. The data can range from CSV files on your private network or data stored in a data warehouse.
For cloud data that Tableau Cloud can reach directly, setting up refresh schedules directly with Tableau Cloud is almost always a better choice. For example, you might be able to connect to a MySQL database hosted on a cloud platform. In a scenario like this, you can set up a refresh schedule for extracts that connect to this type of data directly with Tableau Cloud.
When data sources or virtual connections use extracts to connect to private network data, Bridge can be used to perform scheduled refreshes of those extracts. Refreshes can be scheduled, in most cases, by the content owner as part of the publishing process. For extract refresh requirements, see Additional requirements for extract connections.
Bridge supports data sources or virtual connections with live connections to private network data using a feature called live queries. If the content owner publishes a data source or virtual connection that uses a live connection to data that Tableau Cloud detects that it can't reach directly, live queries are automatically used. For live query requirements, see Additional requirements for live connections.
- Bridge doesn't support live connections for some cloud data sources. These include Google Cloud SQL, OData and Progress OpenEdge. Use extract connections to keep data fresh.
- Bridge doesn't support live connections for some private cloud-based data sources. These include Google Drive, Box, OneDrive, Dropbox and Azure Data Lake Storage Gen2. Use extract connections to keep data fresh.
- Live connections to file-based data such as CSV, text, Excel and statistical (.sas7bdat) isn’t supported.
Bridge supports virtual connections, which provide a sharable central access point to data.
- Snowflake isn’t supported when used with virtual connections.
- OAuth for virtual connections is supported on a connector basis. See the following Knowledge base article and OAuth Connections.
The latest version of Bridge supports file data including CSV, Excel, text, statistical (.sas7bdat), PDF and spatial files.
Extract refreshes for published data source files are supported on the Bridge Windows client. If you are connecting to a local file path, you must use the Default pool.
Extract refreshes for embedded data source files are supported on the Bridge Windows client. You must use a configured pool for embedded data sources and the file path must use the UNC format.
File data isn’t supported on Bridge for Linux for Containers.
- Live connections to file-based data aren’t supported on the Windows client or Bridge for Linux for Containers.
Connections to cube-based data
Cube-based data is not supported.
Tableau Bridge supports data sources that are embedded in workbooks.
- Live connections for files data such as CSV, text, Excel and statistical (.sas7bdat) aren’t supported.
The default pool does not support embedded data sources. You must use a pool that has been configured. For more information, see Configure the Bridge Client Pool.
Scheduled extracts of published data sources don’t support multiple pools.
Private network connections for Tableau Prep through Tableau Bridge are not supported.
Connectors and data types
Bridge supports a combination of connectors that Tableau Desktop and Tableau Cloud(Link opens in a new window) supports. Unsupported connectors and limitations for connectors and data types are listed below.
Include External Files is not supported for Published Data Sources. To refresh published flat files, change the connection information so that the data source references a full UNC path. For example, rather than connecting to D:\datasource.xls
, you would connect to \\filesrv\datasource.xls
.
In most cases, Tableau Cloud will automatically detect the Bridge client. In some cases, you might need to manually configure your connection to ensure that Bridge is used. For more information, see Use Bridge for Private Cloud Data.
- Connectors built by third parties that are not on the Tableau Exchange are not supported.
- Some Exchange Connectors are not supported. See section below.
- Connectors (.taco) built with the Tableau Connector SDK and connectors available through Tableau Exchange aren’t supported.
- Microsoft Analysis Services.
- Microsoft PowerPivot.
- Oracle Essbase.
- SAP NetWeaver Business Warehouse.
Tableau Bridge can be used to query data using the select connectors available on the Tableau Exchange connector page(Link opens in a new window). The Exchange connectors that are supported are Actian JDBC, Altinity Connector for ClickHouse, Guidanz BI Connector, Couchbase Analytics, Stratio Crossdata, Data Virtuality JDBC, Jethro ODBC, Oracle NetSuite, SAP SuccessFactors, ServiceNow and SingleStoreDB JDBC.
To use Exchange Connectors with Tableau Bridge, follow these steps for each Exchange connector and each Bridge client in the pool that will access the target data source.
Download the .taco file from the Tableau Exchange connector page(Link opens in a new window).
Add the .taco file to the Tableau repository connector directory:
On Windows:
C:\Users[Windows User]\Documents\My Tableau Bridge Repository\Connectors
On Linux:
/root/Documents/My_Tableau_Bridge_Repository/Connectors
Follow the instructions on the Tableau Exchange for your connector to download the required driver.
Install the driver on the Bridge client.
Restart the Bridge client.
Connectors that don’t support Live connections
- Google Cloud SQL
- OData
- Progress OpenEdge
To connect to SAP HANA using live connections, parameters and variables must be disabled.
Snowflake isn’t supported when used with virtual connections.
Data used in a multi-connection data source
Tableau Bridge can be used to refresh cross-database joined data sources. The database connections defined in the workbook or data source determine how you can publish and keep the data fresh on Tableau Cloud. As long as all the individual data connections are of a type that Tableau Bridge can refresh, the cross-database joined data source can be refreshed.
- Tableau provides limited customer support for connections using JDBC. See Tableau support for Other Databases (JDBC) connections.
- Tableau provides limited customer support for connections using ODBC. See Tableau support for Other Databases (ODBC) connections.
- Bridge is not able to connect to data from Web Data Connector 3.0. For more information, see Connectors Built with the Web Data Connector 3.0 SDK.
- The Web Data 2.0 is deprecated as of the 2023.1 release. See Web Data Connector 2.0.
- Tableau doesn’t support connectors or other programs written to interface with the WDC API.
Bridge for Linux
Tableau Bridge supports a Linux-based operating system designed for container workloads. Limitations and differences include:
- Bridge for Linux does not support legacy schedules.
- Bridge for Linux runs in the background, which is the equivalent to Service mode in Tableau Bridge on Windows.
- To save log files, copy the files or folders between your docker container and your local file system.
- Currently, Bridge for Linux is installed by running commands in a running container using docker executables.
- Bridge for Linux does not support flat files (Excel, .csv, etc), live or extract.
- Bridge for Linux does not support OAuth for Google Drive, One Drive, Azure Data Lake Storage, Azure SQL, Azure Synapse and Dremio.
- Bridge for Linux does not support SAP HANA SSO.
- Bridge for Linux does not support Windows (UNC) file share paths.
- Bridge for Linux does not support Window integrated authentication.
Authentication
The connected client option must be enabled for the site to allow Bridge clients to run unattended and, if enabled, support multi-factor authentication with Tableau authentication. If connected clients are disabled for the site, Bridge can only support Tableau username and password authentication.
OAuth
Tableau Bridge for Windows does not support OAuth for OneDrive, Azure SQL, Azure Synapse and Dremio.
Tableau Bridge for Linux does not support OAuth for Google Drive, One Drive, Azure Data Lake Storage, Azure SQL, Azure Synapse and Dremio.
- When using your own identity provider (IdP) with the Amazon Athena connector, you must set up the OAuth client configuration file. See Use your own identity provider with Amazon Athena.
Windows Authentication
The Windows user account must be a member of the local admin group to run the client in service mode. If the user isn’t a local admin, they can run the Bridge client in Application mode, but they must remain logged in to the Windows machine.
Kerberos
Bridge on Windows supports Integrated Windows authentication through the "run-as" account, for both files and some databases