Subset definition is a set of tables that will be completely copied or just a part of data will be copied from the source database to the target database.
Subset definition has a hierarchical structure consisting of subset tables (root tables and child / linked tables) and subset relations (links between subset tables).
Child related tables are linked to their parent table (which is either a root table or again a child / linked table) via a subset relation.
We currently support subsetting only for Oracle and MSSQL.
|Subset Definitions Overview List|
|Create Subset Definition|
|Design Subset Definition|
|Execute Subset Definition|
|Edit Subset Definition|
|Delete Subset Definition|
The subset definitions provides basic information about the Subset definitions filter in the project. It offer the ability to create sets of filtered tables that make up subsets.
On the Subset definitions overview list screen all created Subset Definitions can be viewed. It is the landing page of the Subset Definitions functionality.
It contains a table with details of every created subset definition. It is automatically filled when Subset definition is created or when editing it. In this view, you can see basic information so you can quickly identify the Subset Definition:
Figure 1: Subset definitions overview list
On the menu on the right available options are:
In the upper-right corner there is Advanced option button. By pressing Advanced option button, new pop up window for refining Subset Definitions List will be open.
Figure 2: Advanced options
User can choose options to filter data in the overview:
To clear all inserted filters in Advanced options, choose Clear button.
To apply inserted filter data in Advanced options, choose Commit button. A filtered data view will be displayed in the table.
To cancel changes in Advanced options, choose Cancel button.
When creating a new subset definition, user must enter the necessary parameters that define which data source and environment will be included in the scope:
Figure 3: Create Subset Definition
To confirm the process of creating a new subset definition click on Commit button. After confirming, system will open Design Subset Definition screen.
To cancel the process of creating a new subset definition, click on the Cancel button. After canceling, system will go back to Subset Definitions Overview List screen.
On the Design subset definition screen user can create and design subset definition.
All tables are presented on the screen in Toolbox. User can drag and drop tables to use them to design subset definition.
When table is dragged to Design surface user can adjust properties by right clicking on subset table or subset relationship.
Figure 4: Design Subset Definition
There are two ways to execute subset definition:
Figure 5.1: Execute Subset Definition from Subset Definition Overview list
Figure 5.2: Execute Subset Definition from Design Subset Definition
It is possible to Edit an existing subset definition when subset definition is already created.
Figure 6: Edit Subest Definition
In context ‘Edit’ Subset definition scope fields, Data source and Environment, are protected and they are not editable.
To confirm amending click on Commit button. To cancel the editing an existing subset definition, click on the Cancel button.
After subset definitions is edited, system will be redirected to the subset definitions overview list where user can see all subset definitions.
If subset definition is no needed user can select on Subset Definition overview list one or more subset definitions, by using checkboxes, to Delete Subset Definition. A confirmation message appears before deleting.
Figure 7: Delete Subest Definition confirmation message
Deleting the subset definition deletes all corresponding / related subset tables and subset relationships from the database.