Reader small image

You're reading from  Getting Started with Tableau 2018.x

Product typeBook
Published inSep 2018
PublisherPackt
ISBN-139781788838689
Edition1st Edition
Tools
Right arrow
Author (1)
Tristan Guillevin
Tristan Guillevin
author image
Tristan Guillevin

Tristan Guillevin is a Business Analyst at Ogury. In 2017, he won the Iron Viz - the ultimate data visualization battle, organized by Tableau every year in Las Vegas. His passion for data visualization and for Tableau has taken him around the world. He enjoys helping people with Tableau by making webinars, conferences, and writing blog articles.
Read more about Tristan Guillevin

Right arrow

Live or Extract


When you connect to a file or a server, on the Data Source workplace, at the top right, you have the option to use the Data Source Live or Extract, as you can see in the following screenshot: 

There is a big difference between the two options, so let's see them in detail.

Live

A Live connection creates a direct link between the Tableau Data Source and the database (server or file). It means that, if the data changes, you see the impact in Tableau directly after refreshing the Data Source, or when you reopen the Workbook. 

The problem with a Live connection is that you are dependent on the performance of the database. Large text files, big Excel files, or an unoptimized database can be very slow to analyze in Tableau. Also, if you are connected to an online database, you are dependent on the internet connection, and you won't be able to work offline.

For these reasons, I advise you to always work with an Extract.

Extract

When you create an Extract, Tableau copies your database into...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Getting Started with Tableau 2018.x
Published in: Sep 2018Publisher: PacktISBN-13: 9781788838689

Author (1)

author image
Tristan Guillevin

Tristan Guillevin is a Business Analyst at Ogury. In 2017, he won the Iron Viz - the ultimate data visualization battle, organized by Tableau every year in Las Vegas. His passion for data visualization and for Tableau has taken him around the world. He enjoys helping people with Tableau by making webinars, conferences, and writing blog articles.
Read more about Tristan Guillevin