SQL AutoGen

Automation SQL Target Source (Update Row)

To access this page:

  1. Click the Automation tab in the Quick Panel.
  2. Click the Sources icon for a Target.
  3. Click the Update Row Sources icon for a Source in the Parent pane.

Field

Description

Create Source Table

Click to create the Update Row 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).

Refer to Build an Update Row Source Table Using SQL AutoGen for more information.

Create All Rules

Click to create all rules for field mappings for the Update Row source that have a MAPPING STATUS of Complete on the Field Mappings page in Map. 

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.

Refer to Create Rules for an Update Row Source Using SQL AutoGen for more information.

UPDATE SOURCE VIEW

Displays the name of the source as defined in Target Design.

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 checked, the source is active for the target.

NOTE: If unchecked, the source is not active, and rules cannot be created for the 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 for the Update Row source.

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.