LogoLogo
23.2 - Veeva Vault Edition
23.2 - Veeva Vault Edition
  • dqMan Veeva Vault Edition Overview
  • Legal Notice
  • Release Notes
  • Licensing
  • Connecting to Veeva Vault
  • Vault Navigator
    • Documents
    • Objects
    • Handling Picklists
    • Favorites Panel
    • Local tables
    • Object Navigator
  • Session Window: VQL, MDL
    • VQL View
    • MDL View
    • dqMan Proprietary Statements
  • VQL Execution History
  • Favorites
  • Dumping Objects
  • Search Function
  • View Textfiles
  • Import Data to dqMan
  • Compare Data
  • Customize dqMan Veeva Vault Edition
  • Third Party Open Source Libraries
Powered by GitBook
On this page

Was this helpful?

Export as PDF
  1. Vault Navigator

Local tables

Last updated 1 year ago

Was this helpful?

This view displays and allows all user-created local tables to be managed.

Local tables are usually created for caching the data in a local database engine and can be queried later by using a more advanced syntax (GROUP BY, HAVING, MAX, MIN, COUNT, etc). This reduces repeated calls to Veeva Vault for working with data which is not expected to change frequently and can be cached locally, for example for development and testing purposes.

The local table serves as a direct conduit for transferring any alterations to Veeva Vault. This includes updates, edits, and deletions made to the current object or document within Vault. The status bar displays the currently active object.

The database file where data for the local tables is stored is encrypted and can be read only by dqMan.

For more information about creating and querying local tables see .

Menu Option
What It Does

Refresh

Refreshes the data in the selected table with the current data in Veeva Vault

Drop

Drops the selected local table

Load

Loads the data from the local table into the grid. The query for the local table (including all fields) is added to the query editor

Auto-refresh

Automatically refreshes the local table periodically, starting on the selected date and at the specified interval

querying local tables