O'Reilly logo

Learning Tableau by Joshua N. Milligan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with extracts instead of live connections

Most data sources allow the option of either connecting live or extracting the data. However, some cloud-based data sources require an extract. Conversely, OLAP data sources cannot be extracted and require live connections.

When using a live connection, Tableau issues queries directly to the data source (or uses data in the cache if possible). When you extract the data, Tableau pulls some or all of the data from the original source and stores it in a TDE file. Extracts extend the way in which Tableau works with data. Consider the following diagram:

Working with extracts instead of live connections

The fundamental paradigm of how Tableau works with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required