SQL AutoGen

Automation H

Automation V

To access this page, click the Automation tab in the Quick Panel.

Field

Description

Create Target Table

Click to create a target table for the selected object based on the settings in Target Design. The tables are written to the data source defined for the object in Console.

NOTE: A System Type must be defined for a target before the table can be built. If the user did not import a System Type in Target Design (for example, an Excel file import, database table import, or manual entry was used for the target design), an error message displays when the user clicks the Create Target Table icon. The user must set a System Type before the table can be created. Add a System Type to a target in Target Design (Design > Targets > Vertical View for a target > System Type ID).

NOTE: If a table exists in the database, this icon is disabled until the target is synced with Map.

Create All Rules

Click to create all rules for the target and source for the selected object based on mappings submitted in Map. The rules are written to the data source defined for the object in Console.

Build Reports

Click to build target and source reports (added as a view in the database) for the selected object. The reports are written to the data source defined for the object in Console.

Build Reports with Remediation

Click to build target remediation reports (added as a view in the database) for the selected object. These error reports become the basis of remediation rules.

Build and Refresh Data Services

Click to open the AutoGen Data Services page to auto-generate Data Services Jobs for the selected target.

Create and Approve Rules

Click to create and approve all rules for the object that have a Mapping Status of Complete.

Rules are not generated for mappings in any other Mapping Status.

Rules are written to the data source defined for the object in Console.

Create All Objects

Click to create all objects using SQL AutoGen. The target table, source table, Update Row source table (if used) and rules are automatically created.

OBJECT

Displays the name of the object as created in Console.

TARGET

Displays the name of the target as created in Target Design.

Sources

Click to open the Automation SQL Target Source page to create a source table and rules for a source.

The count on this icon represents the number of sources assigned to the target in Target Design.

Target Rules

Click to open the Automation SQL Field Mappings page to Create, Reset or Reject a Target Rule Only mapping and to view the mappings that can be used in SQL AutoGen to create a rule.

The count on this icon represents the total number of Target Rule mappings. A mapping is complete when the Mapping Status is set to Complete and Submitted on the Field Mappings page in Map. If a target field has a basic or complex rule added, this rule bypasses Map and is considered complete by AutoGen.

Mappings

Click to open the Automation SQL Field Mappings page to reset a mapping and to view the mappings that can be used in SQL AutoGen to create a rule.

The count on this icon represents the number of mappings that are completed and can have rules auto-generated. A mapping is complete when the Mapping Status is set to Complete on the Field Mappings page in Map. If a target field has a basic or complex rule added, this rule bypasses Map and is considered complete by AutoGen.

Log

Click to open the AutoGen SQL Log page and view successful or failed AutoGen tasks.

NOTE: If the icon is disabled, no source tables, target tables or rules have been generated for the selected object.

Automation V

Automation H

Field

Description

Object

Displays the name of the object as created in Console.

Description

Displays a description of the object.

Auto Gen Level

Displays an option indicating if and how tables, views and stored procedures are autogenerated.

Values are:

  • New Rules – Alter Table and Build New Views and Stored Procedures Only – When autogenerating, a table is updated and only new views and stored procedures are created. Existing views and stored procedures are not updated.
  • Off – No Generating Any SQL Objects – AutoGen is not used.

    NOTE: Rules for mappings with the Copy, Default, Rule, XRef, and Xref actions are not built. For mappings with the Construction action (for example, mappings that use Enhanced Construction), the table and field are not created in the target database and a page is not created in Construct. Full Construction objects are built via the Sync in Target Design. The rules must be generated on the Automation SQL Field Mappings page. Refer to Create Rules using SQL AutoGen for more information.

  • On – Drop & Rebuild Table, Views and Stored Procedures – Any SQL objects previously created for the target are dropped and a new target table, SQL views and stored procedures with the same name are added.
  • Rebuild – Drop & Rebuild Views And Stored Procedures only – Views and stored procedures previously created for the target are dropped and new SQL views and stored procedures with the same name are added.

Report Auto Gen Level

Displays an option indicating if and how business user reports are generated for the target with SQL AutoGen.

Options are:

  • On - Drop & Rebuild Report Views and Registrations – Any SQL views previously created for the business user reports in the target are dropped and new SQL views with the same name are added.
  • Off - No Report Generation – AutoGen is not used.
  • New - Add new reports without modifying existing report views or registrations – When autogenerating, only new views are created. Existing views are not updated.

Built On

Displays the date the SQL objects were created.

NOTE: If the objects have not yet been built, or the Auto Gen Level is Off, this field is blank.

Built By

Displays the name of the user who built the objects.

NOTE: If the objects have not yet been built, or the Auto Gen Level is Off, this field is blank.