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.
In this article
Data freshness options by data source
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) |
n/a |
|
Statistical file (SAS (*.sas7bdat)) |
Extract only |
Use Tableau Bridge (recommended) |
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) |
Embedded credentials + IP safe 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) |
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 |
Live connection or extract |
Extracts: |
Embedded credentials + IP safe list |
|
Salesforce, Google Analytics, QuickBooks Online |
Extract only |
OAuth Connections | |
|
Google BigQuery, Google Sheets |
Live connection or extract |
Extracts: |
OAuth Connections |
|
Cloud (Dropbox, OneDrive) file-based data (Excel, .csv, .txt, .tab, .tsv, .json) |
Live connection or extract |
Extracts: |
OAuth Connections |
|
Anaplan Oracle Eloqua ServiceNow ITSM |
Extract only |
Embedded credentials |
|
|
Marketo
|
Extract only |
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 safe 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 |
34.246.74.86 52.215.158.213 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:
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
-
Best Practices for Published Data Sources (Tableau Help)