System Administration

CTS Configure H

CTS Configure V

To access this page, click Admin > CTS > Configuration in the Navigation pane.

NOTE: Do not update the configurations on this page for delivered WebApps. However, these settings must be configured if you are CTS’ing a Custom WebApp.

Field

Description

DATA SOURCE ID

Displays the name of the data source that stores the shippable items.

Shippable Items

Click to open the CTS Configure (Shippable Items) page to add and update the tables and columns used for each item.

Shippable items for delivered WebApp components are included by default, but can be updated.

Shippable items for custom WebApps must be set on this page.

Registrations

Click to open the CTS Configure (SQL Object Registrations) page to register SQL Objects to CTS Config items.

Object registrations for delivered WebApp components are included by default, but can be updated.

Object registrations for custom WebApps must be set on this page.

SQL Objects

Click to open the CTS Configure (SQL Objects) page to view and edit individual configurations for SQL Objects.

SQL Objects for delivered WebApps are included in the default configuration and must not be updated.

SQL Objects for custom WebApps are automatically added to the SQL Objects page when a user clicks the Generate Config button on this page’s Vertical View.

Dependencies

Click to open the CTS Configure (SQL Object Dependencies) page to view dependencies among objects for the CTS process.

Object dependencies for delivered WebApps are included in the default configuration and must not be updated.

Dependencies or custom WebApps are automatically added to the CTS Configure (SQL Object Dependencies) page when a user click the Generate Config button on this page’s Vertical View.

Relationships

Click to open the CTS Configure (SQL Object Relationships) page to view the foreign key and child name for relationships used by the CTS process.

Object relationships for delivered WebApps are included in the default configuration and must not be updated.

Relationships for custom WebApps are automatically added to the CTS Configure (SQL Object Relationships) page when a user clicks the Generate Config button on this page’s Vertical View.

CTS Configure V

CTS Configure H

Field

Description

Data Source ID

Displays the name of the data source that stores the shippable items.

Properties

Trusted Cache

If checked, this data source is for a delivered WebApp, and the configuration must not be updated.

If unchecked, the data source is for a custom WebApp. The user can generate the configuration automatically by clicking Generate Config on this page.

Registration Filter

Displays the naming convention used for items to display in the VIEW NAME list box on the CTS Configure (SQL Object Registrations) page.

List Filter

Displays the naming convention used for items to display in the LIST TABLE list box on the CTS Configure (Shippable Item Keys) page.

Maintenance

Generate Config

Click to generate a baseline configuration for SQL Objects for Custom WebApps, including dependencies and relationships in the specified data source and in other data sources as dependencies define them.

Prepare To Ship

Click to clean up the data source's CTS configuration prior to shipping a new version of the custom WebApp. This should be run if the data source's schema is static once shipped (as in, developers will not be making changes to the data source schema on site). This operation deletes all automatically generated views, functions and procedures as well as object dependencies. These should not be needed if the schema is going to remain static. Afterwards, the Trusted Cache option is enabled to speed up CTS operations.