Connectivity with Bridge

When data sources connect to on-premises data that Tableau Online can't reach directly, Tableau Bridge is used to facilitate connectivity.

Supported connection types

Bridge keeps data sources that connect to on-premises data up to date using the following connection types: extract and live.

Extract connections

When data sources use extract connections to connect to on-premises data, Bridge can be used to perform scheduled refreshes of the extracts. Refreshes can be scheduled for all data sources that connect to data listed in the Supported connectors section below. The type of data that Bridge can support falls into one of the following categories:

  • Relational data

  • File data, including statistical files.

  • Private cloud data and some ODBC data, including Amazon Redshift, Teradata, and Snowflake.

  • Some web data connector (WDC) data if you access the data by entering a standard user name and password. Bridge can't be used to access a data provider's website using OAuth.

For additional requirements to support extract connections, see Additional requirements for extract connections.

Live connections

Bridge can be used to support data sources that use live connections to on-premises data as well. Bridge supports data sources with live connections, using live queries, to most data sources listed in the Supported connectors section below. For example, Bridge supports maintaining live connections between your on-premises SQL Server or Oracle data.

For additional requirements to support live connections, see Additional requirements for live connections.

Supported connectors

Unless otherwise specified, Bridge supports refreshes schedules (extract connection) and live queries (live connections) to on-premises data (accessible only from within a private network) whose data sources use the connectors in the table below.

Excel (extract refresh only)

Text File (extract refresh only)

Statistical File - .sas7bdat (extract refresh only)

Actian Vector

Amazon Athena

Amazon Aurora for MySQL

Amazon EMR Hadoop Hive

Amazon RedShift

Apache Drill

Aster Database

Azure SQL Data Warehouse

Cloudera Hadoop

Exasol

Firebird

Google Cloud SQL (extract refresh only)

HortonWorks Hadoop Hive

IBM BigInsights

IBM DB2

Kognitio

MAPR Hadoop Hive

MariaDB

MarkLogic

MemSQL

Microsoft SQL Server

MonetDB

MySQL

Oracle

OData (extract refresh only)

Pivotal Greenplum Database

PostgreSQL

Presto

Progress OpenEdge (extract refresh only)

SAP HANA (extract refresh only)

SAP Sybase ASE

SharePoint Lists

Snowflake

Spark SQL

Splunk

Tableau extracts (extract refresh only)

Teradata

Vertica

Web Data Connector (not using OAuth)

Other Databases (JDBC)

Other Databases (ODBC)

Limited connector support

Similar to Tableau, Bridge provides limited support for data sources that use the connector plugins, Web Data Connector, or a JDBC or ODBC driver to connect to an unsupported database. For more information about the support provided, see the following topics in the Tableau Help:

Unsupported connectivity

There are a few connectivity scenarios that Bridge does not support.

Connection types

When to use an alternative to Bridge

Connecting to cloud data that Tableau Online can reach directly

For cloud data, setting up refresh schedules directly with Tableau Online is almost always a better (or in some cases the only) choice. For a list of connectors supported by Tableau Online, see Allow Direct Connections to Data Hosted on a Cloud Platform.

Note: For some WDC data sources, scheduling refreshes is not an option because of OAuth. For more information, see Working with data accessed through OAuth below.

Refreshing extracts of other cloud data

For some cloud data, you can sign in to by providing a standard user name and password. 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 Online. For more information, see Schedule Refreshes on Tableau Online.

Working with data accessed through OAuth

Data accessed through the provider’s web authorization page (OAuth) is not supported by Bridge. Popular providers that use OAuth include Salesforce.com, Google, and WDC data sources created from QuickBooks Online, Facebook, Twitter, and other websites.

To determine whether your data requires OAuth, when you sign in to your cloud data through Tableau Desktop, if you are redirected to the data provider’s sign-in page, that provider most likely uses OAuth or similar standard and therefore Bridge can't be used.

As an alternative to Bridge, to refresh data that connects through OAuth:

  • For extracts of Salesforce and Google data, you can set up a schedule directly on Tableau Online.

  • For extracts of WDC data sources you created from Facebook, Twitter, or other website, you can refresh the extracts from Tableau Desktop, either by using the Refresh from Source option, or by republishing the data source. For more information, see Refresh Extracts from Tableau Desktop(Link opens in a new window).

Thanks for your feedback! There was an error submitting your feedback. Please try again.