Was this page helpful?
Yes No
Tableau Help > Tableau Online Help > 
Manage Data > Keep Data Fresh

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 refreshing published data depend on the characteristics of your data sources.

In this article

Extract refresh options by data source

The following table lists extract refresh options depending on the source data.

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

Source Publish options Refresh options Authentication

On-premises file-based data (Excel, .csv, Access)

Extract only

Use Tableau Bridge (recommended)

Manual refresh from Tableau Desktop

Automated command-line scripts

n/a

Oracle data hosted on a cloud platform, such as Amazon RDS

Extract only

Use Tableau Bridge (recommended)

Manual refresh from Tableau Desktop

Automated command-line scripts

Embedded credentials + IP authorized list

On-premises relational database (any relational database 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

SQL-compatible 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

10ay.online.tableau.com

10az.online.tableau.com

N. America 66.35.252.0/24
us-east-1.online.tableau.com N. America 50.17.26.34

52.206.162.101

dub01.online.tableau.com EU 185.92.123.0/29

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