SQLViewCreation Analysis Module

The SQLViewCreation analysis module lets you create new views or tables for use in Access Analyzer actions and reports. Access Analyzer re-creates these views or tables during job execution.

warning

Consider the impact on storage and performance when choosing to create views versus tables. Tables require more storage space in the database.

Configuration

This analysis module provides the View and Table Creation Analysis Module wizard to assist in configuring the module. Before the wizard, collect the data you want to manipulate.

The wizard contains the following pages:

• Welcome
• SQLViewCreation: Input Scope
• SQLViewCreation: Input Source
• SQLViewCreations: Join Columns
• SQLViewCreations: Columns
• SQLViewCreation: Filter
• SQLViewCreation: Time Window
• SQLViewCreation: Result Constraints
• SQLViewCreation: Result Type
• SQLViewCreation: Result Sample
• SQLViewCreation: Export
• SQLViewCreation: Summary

The Welcome page provides an overview of the analysis module.

There are no configurable settings on the Welcome page. Click Next to begin configuring a custom table or view using two formatted data sources, or use the Steps navigation pane to open another page in the wizard.