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.
