Promote

Set Up New Structure Data for Packages

Watch the video.

Promote Structure Data represents configuration data that defines a scope of records that are part of a package of tables whose data can be compared and transported between different Stewardship Tier instances. Structure Data records can include individual tables or represent a hierarchy of tables with parent-child relationships. When a new table or sub table is added, users configure which fields must be transported and which fields must be used to compare between host and destination instances. This ability to decide which fields to compare allows only relevant changes to be identified as changed rather than all changes; information about processing counts or when actions were last performed should not be transported.

Promote is delivered with Structure Data records that are part of core application configuration and support the way Syniti recommends that solutions are transported. These Structure Data records cannot be modified; however, if projects have specific requirements then additional Structures Data records can be created.

NOTE: If changes are made to a Structure Data that is assigned to a Package, click the Revalidate All Structures icon on the Advanced Promote Actions page to apply all changes to the Structure Data to the Packages.

To set up a new Structure Data for packages:

  1. Select Configuration > Structure Data in the Navigation pane.

  2. Click Add.

    View the page description for the Structures - Data page

  3. Enter a name for the structure data in the NAME field. It is recommended to prefix the name with the Stewardship Tier component, such as Transform or Common.

  4. Click Save.

  5. Click Vertical View.

  6. Click Edit.

    View the page description for the Structures - Data page

  7. Enter a brief description of the structure data in the Description field.

  8. Click Save.

  9. Add Tables.

Add Tables

Once the structure data is added, specify the parent table or tables that are part of the package.

To add tables to the structure data:

  1. Select Configuration > Structure Data in the Navigation pane.

  2. Click the Tables icon for the Structure Data.

  3. Click Add.

    View the page description for the Structures - Data Parent Tables page

  1. Select a database from the DATA SOURCE ID list box.

  1. Enter a sort order in the PRIORITY field.

  2. Select a parent table from the TABLE list box.

  3. Click the PASS THROUGH check box if the specified table is required to ONLY enable simpler filtering of lower level tables.

NOTE: Enabling the PASS THROUGH check box unchecks the Compare and Sync check boxes on the Structures - Data Table Columns page for all columns associated with the table. Columns needed to identify the record must be manually set to Compare. Additionally, during the compare process, a table identified as a Pass Through table is, by default, not added to the queue for transport.

  1. Click Save; the columns for the table are automatically added.

  2. Click the Columns icon.

  3. Click Edit for a column.

    Or

    Multi-row select and use the toolbar Edit button.

  1. Update the COMPARE check box to control if the values for the selected column are included in the compare process, where the value in the host database is compared to the same value in the destination database.

  2. Update the SYNC check box to control if the values for the selected column are included in the sync process, which syncs the value in the host database to the corresponding column in the destination database.

  3. Update the Simple Selection check box to select a single value to filter the package on. Refer to Add Structure Data Filters for more information.

  4. Select a table from the PARENT LINK COLUMN list box. This is the relationship of the tables as defined by the foreign keys.

    NOTE: The PARENT LINK COLUMN should be blank for parent tables.

  5. Update the Large Data check box if the column contains a large amount of data (e.g., 1 MB) in order for the column to work with the comparison process. If checked, the text “Large Data” displays for the Large Data column on the Package - Data Comparison Records page. If unchecked, and a column being compared contains large amounts of data, the Package - Data Comparison Records page will fail to load.

  6. Click Save.

Add Sub Tables

Once a parent table is added, it is possible to add lower level child tables.

To add a child table to a parent table

  1. Select Configuration > Structure Data in the Navigation pane.

  2. Click the Tables icon for the Data Structure.

  3. Click the Sub Tables icon on a parent table.

  4. Click Add.

    View the page description for the Structures - Data Sub Tables page

  5. Select a database from the DATA SOURCE ID list box.

  6. Select a parent table from the TABLE list box.

  7. Click the PASS THROUGH check box if the specified table is required to ONLY enable simpler filtering of lower level tables.

NOTE: Enabling the PASS THROUGH check box unchecks the Compare and Sync check boxes on the Structures - Data Table Columns page for all columns associated with the table. Columns needed to identify the record must be manually set to Compare. Additionally, during the compare process, a table identified as a Pass Through table is, by default, not added to the queue for transport.

  1. Click Save; the columns for the table are automatically added.

  2. Click the Columns icon.

  3. Click Edit for a column.

    Or

    Multi-row select and use the toolbar Edit button.

  4. Update the COMPARE check box to control if the values for the selected column are included in the compare process, where the value in the host database is compared to the same value in the destination database.

  5. Update the SYNC check box to control the values for the selected column are included in the sync process, which syncs the value in the host database to the corresponding column in the destination database.

  6. Select the parent table from the PARENT LINK COLUMN list box to link the parent and child tables.

  7. Click Save.