Keep Data Fresh

After you publish workbooks and data sources to Tableau Cloud, 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 Cloud does not support connections to any cube-based data source.

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

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

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 in Tableau Bridge settings

Relational database 

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

Live connection or extract, depending on database

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 Cloud

Embedded credentials + IP safe list

Edit Connections on Tableau Cloud

Salesforce, Google Analytics

Extract only

Schedule directly on Tableau Cloud

Refresh Data Using Saved Credentials

OAuth Connections

Google BigQuery,

Google Sheets

Live connection or extract

Extracts:

Schedule directly on Tableau Cloud

Refresh Data Using Saved Credentials

OAuth Connections

Cloud (Box, Dropbox, OneDrive, Google Drive) file-based data

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

Live connection or extract

Extracts:

Schedule directly on Tableau Cloud

Refresh Data Using Saved Credentials

OAuth Connections

Anaplan

Oracle Eloqua

ServiceNow ITSM

Extract only

Schedule directly on Tableau Cloud

Refresh Data Using Saved Credentials

Embedded credentials

Edit Connections on Tableau Cloud

Marketo

 

Extract only

Schedule directly on Tableau Cloud

Embedded credentials

Web Data Connectors

Extract only

For basic user name and password credentials, use Tableau Bridge.

For custom (non-basic) user name and password credentials, use the Tableau Desktop Refresh From Source command, or run a manual refresh from Tableau Desktop. For more information, see the WDC Authentication(Link opens in a new window) topic in the Tableau Web Data Connector API Help.

Tableau Bridge: Embedded credentials

Other: n/a

Tableau Cloud 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 Cloud remain uninterrupted, add Tableau Cloud to your data provider’s allowlist (safe list).

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

Host Name (Instance) Site Location IP Address or Range

10ax.online.tableau.com

US West - Oregon

34.208.207.197

52.39.159.250

10ay.online.tableau.com

US West - Oregon

34.218.129.202

52.40.235.24

10az.online.tableau.com

US West - Oregon

34.218.83.207

52.37.252.60

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

US West - Oregon

34.214.85.34

34.214.85.244

us-east-1.online.tableau.com

US East - Virginia

50.17.26.34

52.206.162.101

prod-useast-a.online.tableau.com US East - Virginia

3.219.176.16/28

prod-useast-b.online.tableau.com

US East - Virginia

3.219.176.16/28

dub01.online.tableau.com

EU West - Ireland

34.246.74.86

52.215.158.213

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

EU West - Ireland

34.246.62.141

34.246.62.203

prod-apnortheast-a.online.tableau.com

Asia Pacific - Japan

18.176.203.96/28

prod-apsoutheast-a.online.tableau.com

Asia Pacific - Australia

3.25.37.32/28

prod-uk-a.online.tableau.com

EU West - UK

18.134.84.240/28

prod-ca-a.online.tableau.com

Canada - Quebec

3.98.24.208/28

These addresses are dedicated to and controlled by Tableau.

Note: In addition to enabling communication over the Tableau Cloud IP range, you might need to enable access over the appropriate database port (for example, 80 or 443) depending on the communication type (HTTP or HTTPS).

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(Link opens in a new window)

Google Cloud Platform(Link opens in a new window)

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.

Tableau Bridge connections to Tableau Cloud

To facilitate connections between on-premises data and Tableau Cloud, Tableau Bridge uses common port 443 to make outbound requests to Tableau Cloud. For more information, see Network access section in the Install Tableau Bridge topic.

See also

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!