Difference Between Live Connection and Extract Data

Live: 

• 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.

Extract: 

• 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.

Back to Tableau Home Page

Related Posts:

• Component of Tableau Desktop
• Connect to a Data Source in Tableau
• Difference Between Live Connection and Extract Data
• Types of Variable in Tableau - Datatypes
• How to Edit Datatype of a Column/Variable in Tableau
• Dimensions & Measures in Tableau
• Creating First Visualization in Tableau
• Types of Chart available in Show Me Pane - Tableau
• Learn Creating Sets in Tableau