Created by James Hurrell, last modified on Nov 11, 2022
This documentation is not maintained. Please refer to doc.castsoftware.com/technologies to find the latest updates.
The information below is valid only for the legacy analyzers (PL/SQL/T-SQL) embedded in CAST AIP. See SQL - Available extensions for information about SQL related extensions.

Summary: this pages describes all analysis configuration options that are available for the legacy SQL analyzers (PL/SQL/T-SQL) embedded in CAST AIP

CAST Console

CAST Console exposes the Technology configuration options once a version has been accepted/imported, or an analysis has been run. Click PL/SQL Technology/MS-SQL Technology/Sybase Technology to display the available options:

Technology settings are organized as follows:

  • Settings specific to the technology for the entire Application
  • List of Analysis Units (a set of source code files to analyze) created for the Application
    • Settings specific to each Analysis Unit (typically the settings are the same as at Application level) that allow you to make fine-grained configuration changes.

You should check that settings are as required and that at least one Analysis Unit exists for the specific technology.

Click to enlarge

Dependencies

Dependencies are configured at Application level for each technology and are configured between individual Analysis Units/groups of Analysis Units (dependencies between technologies are not available as is the case in the CAST Management Studio). You can find out more detailed information about how to ensure dependencies are set up correctly, in Validate dependency configuration.

Note that for legacy SQL technologies, dependencies will not usually be created automatically for links between server side and client side (as this direction does not usually occur). You are free to create custom dependencies between PL/SQL and T-SQL analysis units if necessary however, using the ADD button.

Analysis Units

It is possible to click into each Analysis Unit (corresponding to one database delivered) detected during the source code delivery, however, for legacy PL/SQL and T-SQL technologies, there are no configuration options available and it is only possible to view the deployment path:

You can however:

Analyze a specific Analysis Unit on its own, specifically for testing purposes.

Disable or enable the analysis of a specific Analysis Unit, when the next Application level analysis/snapshot is run. By default all Analysis Units are always set to enable. When an Analysis Unit is set to disable, this is usually a temporary action to prevent an Analysis Unit from being analyzed.

CAST Management Studio

Introduction to analysis configuration options

The CAST Management Studio has three levels at which analysis configuration options can be set:

Technology
  • The options available at this level are valid for all Applications managed in the CAST Management Studio.
  • These are the default options that will be used to populate the same fields at Application and Analysis Unit level. If you need to define specific options for a specific Application or Analysis Unit, then you can override them.
  • If you make a change to a specific option at Application or Analysis Unit level, and then subsequently change the same option at Technology level, this setting will NOT be mirrored back to the Application or Analysis Unit - this is because specific settings at Application and Analysis Unit level have precedence if they have been changed from the default setting available at Technology level.
Application
  • The options available at this level set are valid for all corresponding Analysis Units defined in the current Application (so making changes to a specific option will mean all Analysis Units in that specific Technology will "inherit" the same setting). If you need to define specific options for a specific Analysis Unit in a specific Technology, then you can do so at Analysis Unit level.
Analysis Unit
  • Options available at this level are valid only for the specific Analysis Unit.
  • An Analysis Unit can best be described as a set of configuration settings that govern how a perimeter of source code is consistently analyzed.
  • Analysis Units are automatically created when you use the Set as current version option to deploy the delivered source code - as such they correspond to Projects discovered by the CAST Delivery Manager Tool. However, they can also be created manually for situations where no Analysis Unit has been automatically created for a given project.
    • When the Analysis Unit has been created automatically, options will "inherit" their initial configuration settings from the discovery process in the CAST Delivery Manager Tool (i.e. "project" settings). Where an option could not be defined automatically via the CAST Delivery Manager Tool, it will "inherit" its initial configuration settings from those defined at Technology level and at Application level.
    • Analysis Units that are manually defined will "inherit" their initial configuration settings from the settings defined at Technology level and at Application level.
  • Modifying an identical option at Technology level or at Application level will automatically update the same option in the Analysis Unit editor unless that specific option has already been modified independently in the Analysis Unit editor.

Some settings at Application and Analysis Unit level have a "Reset" option - using this will reset the option to the value set at the parent level:

Auto-configuration validation

Technology / Application level

Using the Technology level or Application level options, validate the settings for SQL packages. Make any update as required. These settings apply to the Technology or Application as a whole (i.e. all Analysis Units):

Example for MS SQL Server technology

Analysis Unit level

To inspect the auto-generated analysis configuration, you should review the settings in each Analysis Unit - they can be accessed through the Application editor:

Example for MS SQL Server technology

Technology options

The available options for configuring an analysis are described below. Note that some options are not available at specific levels (Technology/Application/Analysis Unit):

Source Settings

This tab shows the location of each type of source code in an SQL Analysis Unit - this is determined automatically by the CAST Delivery Manager Tool. You should, however, review the configuration and make any changes you need:

Click to enlarge

Extraction path

The file based location of the corresponding extracted project. This field is read-only. When the field contains User defined, this indicates that the Analysis Unit has been defined manually instead of automatically following the use of the CAST Delivery Manager Tool.
Table Sizes folderDefines the location of the folder containing your .SQLTABLESIZE files (see Enable XXL table Quality Rules).

Production

Click to enlarge


The Production tab is only visible at Technology and Application level.

Dynamic Links Rules

See the CAST Management Studio help for more information about this global option.