Promote

Packages

Packages V

To access this page:

  1. Click Packages in the Navigation pane.
  2. Click the Packages icon for a Package Group.

    OR

  1. Click Approval in the Navigation pane.
  2. Click the View Packages icon for a package group approval request.

Field

Description

Compare

Click to compare one environment to another. This process runs in the background. Hold Ctrl to select multiple packages to compare. Once the compare process has finished running, underlining pages for the Data (total number of tables) and SQL Objects (total number of objects) icons are populated.

DESTINATION ID

Displays the data source for the destination (target) server. This list is controlled on the Servers page.

PRIORITY

Displays the order in which the packages are transported to the destination server.

NAME

Displays the name of the package.

Data

Click to open the Package - Data Comparison page to view the comparison of data in the tables between the two environments. The count on the icon displays the number of records marked to be transported.

SQL Objects

Click to open the Package - Object Comparison - Per Database page to view the comparison of the schema between the two environments. The count on the icon displays the number of SQL objects in the queue to be transported.

Databases

Click to open the Package - Databases page to create databases that are not in the destination system. Refer to Create Databases That Do Not Exist on the Destination for more information.

Transport

Click to move the selected table data and SQL objects from the host server to the destination server.

Log

Click to open the Package - Messages page to view everything happening during the transport process. Refer to View Logs for more information.

LAST RUN

Displays process that ran (either Compare or Transport), and the date and time it last ran.

Packages V (All Tabs)

Packages H

This page contains the following tabs:

General tab

Field

Description

Name

Displays the name of the package.

Description

Displays a brief description of the package.

Destination ID

Displays the data source for the destination server. This list is controlled on the Servers page.

Fix INNER/OUTER Naming Issue

Click to resolve an Inner/Outer naming issue on the Log (i.e., the Package - Messages page). This feature drops and re-creates the view to resolve the issue. After running this process, click the Compare icon to run the compare process again.

Copy Package

Click to create a duplicate of the package within the current Package Group. This process is helpful when creating similar packages or troubleshooting a primary key error. Refer to Copy Existing Package for more information.

Pack Documentation

Click to open the Package - Documentation page to upload documentation or instructions on how to execute the package and/or code transport.

Data Structure tab

Use this tab to Add Structure Data Filters.

Field

Description

Structure Data ID

Displays the name of the selected Structure - Data item that is used in the package.

Structure Data Focus

Displays a list of tables associated with the selected Structure Data. Users can select at which level within the structure on which they want to base the comparison or the transport process.

Structure Data Focus_Simple Field

Displays columns that have Simple Selection checked in the configuration for the data structure table (on the Structures - Data Table Columns page). This field allows for easily filtering of the columns marked for Simple Selection. Refer to Use a Simple Selection List for more information.

Structure Data Focus_Simple Value

Displays the Simple Selection value on which to filter. Only records defined by the filter for that single value are included in the compare process. Refer to Use a Simple Selection List for more information.

Structure Data Focus_Adv Where Clause

Displays a WHERE clause used to filter out specific data from the view in order to add granularity to the compare process.

Additional Filtering

Structure Add Filter1_Data Focus

Displays a list of tables associated with the structure. Users can add secondary filters to tables lower down the structure to further reduce selection of records for comparison. Refer to Use Additional Filters for more information.

Structure Add Filter1_Simple Field

Displays columns that have Simple Selection checked in the configuration for the data structure table (on the Structures - Data Table Columns page). This field allows for easily filtering of the columns marked for Simple Selection.

Structure Add Filter1_Simple Value

Displays the Simple Selection value on which to filter. Only records defined by the filter for that single object are included in the compare process.

Structure Add Filter1_Adv Where Clause

Displays a WHERE clause used to filter out specific data from the view in order to add granularity to the compare process.

Structure Add Filter2_Data Focus

Displays a list of tables associated with the structure. Users can add secondary filters to tables lower down the structure to further reduce selection of records for comparison. Refer to Use Additional Filters for more information.

Structure Add Filter2_Simple Field

Displays columns that have Simple Selection checked in the configuration for the data structure table (on the Structures - Data Table Columns page). This field allows for easily filtering of the columns marked for Simple Selection.

Structure Add Filter2_Simple Value

Displays the Simple Selection value on which to filter. Only records defined by the filter for that single object are included in the compare process.

Structure Add Filter2_Adv Where Clause

Displays a WHERE clause used to filter out specific data from the view in order to add granularity to the compare process.

Object Structure tab

Use this tab to Add Structure Object Filters.

Field

Description

Structure Object ID

Displays the object to be used to filter objects for the compare process.

Structure Object Where Clause

Displays a WHERE clause used to filter out specific SQL objects in order to add granularity to the compare process.

Advanced Configuration

Default Include dgSAP Views

If checked, objects within this package that are dependent on SQL objects in databases prefaced with “dgSAP” (such as dgSAP_Dev, dgSAP_QE, etc.) are included in the transport.

If unchecked, objects within this package that are dependent on SQL objects in databases prefaced with “dgSAP” (such as dgSAP_Dev, dgSAP_QE, etc.) are excluded from the transport.

This configuration is inherited from the setting on the Application Parameters page; however, it can be overridden.

Allow Delivered Database SQL Changes

If checked, databases delivered with the Stewardship Tier can be temporarily unprotected for a package, allowing Power Users to transport SQL Object changes made to delivered applications. Enable this setting to transport core modifications.

If unchecked, databases delivered with the Stewardship Tier cannot be temporarily unprotected for a package.

NOTE: This setting is only available if the Allowed Delivered Database SQL Changes check box is enabled on the Application Parameters page. Both of these settings must be enabled in order to transport core modifications.

Manual Objects tab

Field

Description

Manual Add Objects

Click to open the Package - Manual Object page to manually add objects that may be needed for the package. Refer to Manually Add Objects for more information.

Manual Ignore Objects

Click to open the Package - Manual Ignore Object page to manually add objects to be ignored during the transport process. Refer to Manually Ignore Objects for more information.