Chat now with support
Chat con el soporte

Toad Data Point 5.0 - User Guide

Snapshots in TIC

A snapshot is a table in Toad Intelligence Central (TIC) consisting of the result set of a query, the stored SQL query, and the mapping information to the remote object. A snapshot is a copy of the data taken at a specific point in time. A snapshot is created by publishing data from a remote source (see Publish to Toad Intelligence Central).

Snapshots can be private, public, or shared with a list of users you specify.

Note: This feature is available in the Toad Data Point Professional edition only and requires access to a Toad Intelligence Central server.

Refreshing a Snapshot

You can refresh a snapshot to reflect the current data in the source table or tables. You can refresh a snapshot manually, schedule a single refresh, or schedule a periodic refresh.

To refresh a snapshot immediately

  1. Select the snapshot in the Object Explorer and click .

To specify/modify the snapshot refresh schedule

  1. Use one of the following methods to specify refresh schedule options:
    • In the Object Explorer, right-click a snapshot and select Operations | Schedule Refresh Snapshot.
    • In the Object Explorer, select a snapshot and click .
  2. To schedule a recurring refresh, specify the Schedule Recurring Refresh options.
  3. To delay the start of the recurring refresh, select a date in the Range of Recurrence options.

Access to Snapshots

A snapshot uses a Shared Authentication key. However, you must be the snapshot owner or have Manage privileges to refresh a snapshot.

Create Snapshot Index

See Create/Drop Index for a TIC Object for information about creating indexes in a snapshot.

Operations

Use the following operations (commands) from the Object Explorer toolbar or the right-click menu.

Operation Description
Click to modify sharing (visibility) options for the selected snapshot. Specify Sharing and Manage Privileges for Objects
Click to add or delete tags for the selected snapshot. Alter Tags
Click to refresh or to modify the refresh schedule of the selected snapshot.
Click to refresh the selected snapshot immediately.
Drops the selected snapshot.
Locks the selected snapshot. Lock and Unlock Objects
Unlocks the selected snapshot. Lock and Unlock Objects

Snapshot Manage Privileges

The owner of a snapshot or a user with Manage privileges can perform the following operations on the snapshot (if the snapshot is not locked):

  • Refresh a snapshot
  • Lock a snapshot
  • Drop a snapshot
  • Rename the snapshot
  • Modify the snapshot sharing options
  • Modify snapshot refresh schedule

To see a comparison of snapshot properties against other TIC objects, see Data Objects in Toad Intelligence Central.

Note: You can automate the task of refreshing a snapshot by using the Refresh Snapshot activity in Automation. See Use Database Automation Activities for more information.

  

Related Topics

Documentos relacionados