Good news! In our new version, 9.3, there is a new ability for the Data Sync Client to be configured as “always on” and running so that you do not have to be logged in to your computer for the extract refresh to occur.
More details about 9.3 are available here
Hope this helps!
@jennifer is right.
If your organization is still on older version of tableau then instead of live data connection you should use extract mode.
And create a schedule to get it refresh on an interval of time(daily, hourly etc). So that you don't have to worry about the data connection failure.
Thanks for the followup. We actually already work on extracts but my tuesday night sql mainteneance bring sql offiline as we use sql standard and index rebuild bring it offline.
This will help. Thanks
Sent using OWA for iPhone