Page History

A Data Extract is a local file containing data extracted from a Data Source. Data Extracts allow sharing Workbooks in an offline fashion so that whoever opens the Workbook does not need to be directly connected to a database server as a datasource. Data Extract files have the file extension .vize and will get contained in Packaged Workbooks (.vizx files) when exporting or saving as Packaged Workbook files. Data Sources that use Extracts have icons that contain a blue cylinder.

Creating Extracts

Extract Properties

Refreshing Extracts

Auto Refreshing Extracts

Removing Extracts

...

Extracts are immediately put to use when they are created and they are not saved with the Workbook until you save. Reopening a Workbook without saving an Extract means you'll be using the original Data Source.

Once an extract is created you can view its properties by right-clicking on it and selecting [Extract > Properties].

...

• Data Source - The name of the Data Source used to generate the Extract.
• Location - Where the Data Extract (.vize file) resides.
• Query - The statement executed to retrieve the data from the server that created the extract.
• Max Results - The maximum number of rows set to be retrieved by the query as indicated in the Query Analyzer's Max Results form.

An Extract can be refreshed from its Data Source so that changes in the source can be pulled into the Extract.

...

When [Refresh All Extracts] is used a dialog appears listing every Extract that will be refreshed.

When [Data > Auto Refresh...] is enabled, any data sources which are set for Auto Refresh that contain extracts will also have their extracts refreshed automatically using the Refresh Frequency (seconds, minutes, hours) you have input. See Auto Refresh on the Refreshing Data page for more.

If you need to remove an Extract, right click on its Data Source in the Data Pane and choose [Extract > Remove] from the menu.

...