Analytics anyone can use.
Analytics for organizations.
Cloud analytics for organizations
Update: We've launched a new home for the Tableau Online Tips blog series! Check out all our tips, tricks, and ideas for Tableau Online on the new page.
Earlier in this series, we covered the differences between extracts and live connections as well as when to use each. We also walked through the process of keeping that data fresh with live database connections and refreshes using Tableau Online's sync client.
For on-premise data, you can use the Tableau Online sync client to push extract refreshes to Tableau Online. This post focuses on managing the sync client. Here are five tips to ensure your latest on-premise data gets pushed to Tableau Online.
By default, the sync client runs as a Windows system-tray application. This means that it can only refresh on a schedule when you’re logged in to Windows.
Alternatively, you can run the sync client continuously as a Windows service. Doing so allows you to log out of Windows, and (as long as your computer is on) refreshes will continue to occur. If you run Tableau Desktop on a Mac, or if you want to turn your computer off, you can run the sync client continuously on a different machine. This could be a dedicated VM, or any other compatible computer you have that is always on.
To run the sync client continuously, follow the steps below.
With the sync client, you can create custom schedules to refresh your data, down to 15-minute intervals. Here’s how:
If available, specify whether you want a full or incremental refresh. By default, Tableau Online runs a full refresh (incremental refreshes are available only if you’ve configured them in Tableau Desktop before publishing the extract).
If you want to set refresh schedules for data sources like SQL Server, Oracle, or any other database that require user authentication, you need to store ("embed") those credentials in the connection information. The sync client will use the embedded credentials to access the database, create refreshes, and push them to Tableau Online.
Note: When using the sync client, you need to embed credentials even if you've previously chosen to embed credentials when publishing the data source from Tableau Desktop, or if you added credentials via the Data Connection page on Tableau Online.
If you send data updates from a Microsoft Excel workbook, .csv, or .txt file, you will need to update the file location in the sync client if you move that file.
Extract refreshes can fail for any number of reasons. Make it easy on yourself by enabling email notifications in your Tableau Online site settings to be alerted anytime a refresh fails. As a site admin, simply check the email notifications box under the Settings tab. Individual users are able to opt out of failure notification emails in their account settings.
Catch up on previous blog posts on the Tableau Online Tips page, and be on the lookout for future installments in the Tableau Online Tips series.
If you haven’t yet tried Tableau Online, start a free trial today! And visit our Tableau Server & Tableau Online Admin Community Forum to continue to conversation.