Difference Between Live Connection and Extract Data


  • This allows real time data for analysis from available data source. 
  • It is also known as real time Extract A live connection is a query that underlying data in the data source/database. 
  • When we refresh the visualisation that gives the latest results. 
  • Data is not copied to Tableau Server for preprocessing.

Live and Extract Data in Tableau


  • This allow real time data to copied into Tableau as Extract and perform our analysis, we can also Schedule data to be Extracted on a regular Interval.
  • An Extract is a connection with static database, which is refreshed on a specific period of time.
  • All data used to copied from the data source to Tableau Server. 
  • Refreshing the data source or Visualization will not give you the latest  data, we need to refresh the extract to get latest data.