Was this page helpful?
Yes No
Tableau Help > Tableau Online Help > 

Keep Data Fresh

After you publish workbooks and data sources to Tableau Online, you can decide how you want to keep the data current. Options for keeping published data fresh depend on the characteristics of your data sources.

Data freshness options by data source

The following table lists data freshness options (and exceptions) that are available depending on the data source.

Exceptions

  • Tableau Online does not support connections to any cube-based data source.

  • Tableau Online does not support published data connections that use Kerberos authentication.

  • Although you can publish extracts of SAP BW data to Tableau Online, refreshes are not supported. The best way to update SAP BW data sources is to republish them.

  • Tableau Bridge does not support extract refreshes for data sources with OAuth authentication.

Options

Source Publish options Freshness options Authentication
On-premises data (accessible only from a private network)

File-based data

(Excel, .csv, .txt)

Extract only

Use Tableau Bridge (recommended)

Manual refresh from Tableau Desktop

Automated command-line scripts

n/a

Statistical file

(SAS (*.sas7bdat))

Extract only

Use Tableau Bridge (recommended)

Manual refresh from Tableau Desktop

Automated command-line scripts

n/a

Data hosted on a cloud platform

(For example, Oracle on Amazon RDS)

Live connection or extract, depending on database

Use Tableau Bridge (recommended)

Manual refresh from Tableau Desktop

Automated command-line scripts

Embedded credentials + IP authorized list

Relational database 

(Relational databases that Tableau Desktop connects to. For example, SQL Server, Oracle, IBM DB2)

Live connection or extract, depending on database

Live connections:

Use Tableau Bridge (recommended)

Extracts:

Use Tableau Bridge (recommended)

Manual refresh from Tableau Desktop

Automated command-line scripts

Embedded credentials in Tableau Bridge settings

Cloud data (accessible from the public internet)

Data hosted on cloud platforms

(See the list of supported platforms in
Allow Direct Connections to Data Hosted on a Cloud Platform

Live connection or extract

Extracts:

Schedule directly on Tableau Online

Embedded credentials + IP authorized list

Edit Connections on Tableau Online

Salesforce,

Google Analytics,

QuickBooks Online

Extract only

Schedule directly on Tableau Online

Refresh Data Using Saved Credentials

OAuth Connections

Google BigQuery,

Google Sheets

Live connection or extract

Extracts:

Schedule directly on Tableau Online

Refresh Data Using Saved Credentials

OAuth Connections

Cloud (Dropbox, OneDrive) file-based data

(Excel, .csv, .txt, .tab, .tsv, .json)

Live connection or extract

Extracts:

Schedule directly on Tableau Online

Refresh Data Using Saved Credentials

OAuth Connections

Anaplan

Oracle Eloqua

ServiceNow ITSM

Extract only

Schedule directly on Tableau Online

Refresh Data Using Saved Credentials

Embedded credentials

Edit Connections on Tableau Online

Marketo

 

Extract only

Schedule directly on Tableau Online

Embedded credentials

Web Data Connectors

Extract only

For user name and password credentials, use Tableau Bridge

For WDC OAuth connections, use the Tableau Desktop Refresh From Source command, or run a manual refresh from Tableau Desktop.

Tableau Bridge: Embedded credentials

Other: n/a

Tableau Online IP addresses for data provider authorization

As a security measure, cloud data providers might require you to supply a list of authorized IP addresses from which external applications request access to your data. A request from an IP address that is not explicitly approved could be rejected. To make sure live connections you publish to Tableau Online remain uninterrupted, add Tableau Online to your data provider’s authorized list.

The table lists IP address ranges Tableau Online uses, depending on your site location. You can see its location in the URL that appears after you sign in to Tableau Online.

Host Name (Instance) Site Location IP Address or Range

10ax.online.tableau.com

N. America

34.208.207.197

52.39.159.250

10ay.online.tableau.com

N. America

34.218.129.202

52.40.235.24

10az.online.tableau.com

N. America

34.218.83.207

52.37.252.60

us-east-1.online.tableau.com

N. America

50.17.26.34

52.206.162.101

us-west-2b.online.tableau.com

N. America

34.214.85.34

34.214.85.244

dub01.online.tableau.com

EU

185.92.123.0/29

eu-west-1a.online.tableau.com

EU

34.246.62.141

34.246.62.203

These addresses are dedicated to and controlled by Tableau.

Note: In addition to enabling communication over the Tableau Online IP range, you might need to enable access over the appropriate database port.

Find authorization steps for your data provider

The following links take you to the steps on common data providers’ websites for authorizing external applications on their platforms.

Amazon:

Microsoft Azure

Google Cloud Platform

Disclaimer: The links in the list above take you outside of Tableau.com. Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.

See also