We want to connect our dashboards with Microsoft SQL Sever and set it up such that the dashboards are refreshed every 2-4 hours and update it as per the new data on the server database. How do we do it ?
you have to make dashboard and upload it to Tableau Server. Then you have to do custom scheduling to tell Tableau Server to put new data in dashboard. Link: http://kb.tableausoftware.com/articles/knowledgebase/schedule-extract-updates-60
Also if you have lot of data, make a incremental extract instead of full extract on some column in Tableau Desktop
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...