SQL AutoGen

Automation SQL Target Source

Use this page to Build a Source Table.

To access this page:

  1. Click the Automation tab on the Quick Panel.
  2. Click the Sources icon for an Object.

Field

Description

Create Source Table

Click to create the source table and Insert and Delete stored procedures used to load data into the target table.

NOTE: This icon is disabled if the source is assigned to a Target that has a Design Status of Inactive or Complete in Target Design.

NOTE: A source table cannot be built for a source of {Target Rules}. If the selected source is {Target Rules}, the Create Source Table icon is disabled.

NOTE: A System Type must be defined for a source 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 Source Table icon. The user must set a System Type before the table can be created. Add a System Type to a source in Target Design (Design > Targets > Sources > System Type ID).

Create All Rules

Click to create all rules for field mappings that have a MAPPING STATUS of Complete on the Field Mappings page in Map. If the Auto Gen Level on the Automation page’s Vertical View is set to Off for the target, the rules are not created.

NOTE: This icon is disabled if the source is assigned to a Target that has a Design Status of Inactive or Complete in Target Design.

Map Source

Click to open the Target Sources page in Map to view information about the source such as a status summary of all mappings, the source schema, and the field mapping details.

SOURCE

Displays the name of the source as defined in Target Design, {Target Rules} if the source is the target rules, or DSPConstruct if the source is built using Construct.

ST TABLE NAME

Displays the name of the source table or view, or indicates if the source is an Update Row source.

SOURCE BUILT ON

Displays the date and time the source table was built (for example, the date a user clicked the Create Source icon in the Page toolbar).

ACTIVE

If enabled, the source is active for the target. If is not active, rules cannot be created for the source.

Update Row Sources

Click to open the Automation SQL Target Source (Update Row) page to create Update Row source tables and all rules for an Update Row source.

Mappings

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

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.