Description

XTS stands for Extract Table Schema. In this approach GenRocket can retrieve one, many or all table schemas from a given database by connecting directly to the database via JDBC to extract the database’s schema. The extracted schema is saved to an encrypted file. The encrypted file can then be imported into the GenRocket web application using XTS Wizard. 


Note: For more information about creating an XTS File, click here.


What is the XTS Wizard?

The XTS Wizard contains a set of easy-to-use wizards that can be used to import an XTS File into a selected Project Version of a given Project and complete important setup steps after the import has completed. 

XTS is a multi-step process that includes important setup steps that are accomplished using multiple wizards:



When should it be used? 

  • Any time you need to import an XTS File into a selected Project Version of a given Project. 


Who should use the XTS Wizard?

  • Data Architects - This persona will complete Steps 1 through 6 for most organizations.
  • Software Testers - This persona will complete Step 7 for most organizations.

 

How to Access the XTS Wizard

The XTS Wizard can be access in two ways: 


Method 1: 

  • Select a Project within the Project Dashboard.
  • Next, expand the Self Serve Options Menu for a Project Version and select XTS Wizard.

     

Method 2: 

  • Expand the New Domain drop-down menu and select Import from XTS.




How does it work?


Step 1: XTS Import Wizard

The XTS File Import Wizard is used to import an extracted application or database table schema into the GenRocket web platform to automatically create Domains with Attributes and Generators. 


  • Click on the XTS Import Wizard.



  • Click on Choose File to browse to and select an XTS file.



  •  The file name will appear to the right of the Choose File button, as shown below:


  • (Optional) Enable the Enforce Type/Limit option to ensure Generator value limits are automatically enforced when importing an XTS File.


  • Click the Save button to finish.



  • Click OK.



  • You will be returned to the Project Dashboard. A message will show that an XST Import has been initiated. The Project will be frozen until this process is completed.
     

  • Click the Close button once the import has finished. You will be returned to the XTS Wizard automatically.
     


  • Click the Mark Completed button for this step once finished.



  • Click Yes to confirm.



  • Once the file has been successfully imported and the wizard has been marked as completed, additional wizards will be available.


Step 2: Domain Referencing Wizard

The Domain Referencing Wizard can be used to traverse Domains created from the XTS Import Process to easily set up parent, child, and sibling relationships.


  • Click on the Domain Referencing Wizard to get started.



  • Within the Domain Referencing Wizard, you view each Domain and Parent/Child/Sibling Relationships between Domains.


  • Filters can be used to search by Name, to filter out Root Domains, and to view Reviewed or Not Reviewed Domains. You can also set custom search criteria.



  • Select a Domain to review within the first pane.



  • Once a Domain is selected, you will see its relationship information within the Domain Referencing Wizard.

  • You can change a Domain from a Parent to a Sibling or a Sibling to a Parent by selecting the appropriate radio button.

  • You can also remove a parent by clicking on the Minus (-) icon.



  • If changes are made to the Parent/Child/Sibling Relationships for a selected Domain, it will be automatically marked as reviewed. The Domain will have a checkmark in the Reviewed Column and the graph below the Domain Relationship configuration will automatically update.


  • If no changes have been made, you will need to click on the Mark as Reviewed button. 


    Note: You can click the Mark as Not Reviewed button for the Domain to remove the checkmark within the Domain Referencing Wizard.

  • The Domain Referencing Wizard will appear as shown below after the Domains have been reviewed:



  • Click on XTS Wizards in the breadcrumb bar to return to XTS Wizard.



  • Once finished, click on Mark Completed for Step 2.



  • Click Yes in the prompt window.


Step 3: Generator Tuning Wizard

The Generator Tuning Wizard can be used to see statistics on how well Generators have been associated to Attributes during the XTS process. You can easily adjust Generators across multiple Domains and Attributes to fine tune test data accuracy.

  • Select the Generator Tuning Wizard.



  • This wizard can be used to perform advanced Generator Tuning. Generators will automatically be assigned to each imported Domain; however, you may need to make changes to one or more Generators or their Parameter configurations.



  • Select a Generator within the Generators Pane to view the Domains it belongs to and its configuration details.

  • For this example, the NameGen Generator will be selected. This Generator has been used in 4 Domains.   



  • Select a Domain within the Domains Pane. For this example, the Customer Domain will be selected. The NameGen Generator is assigned to 2 Attributes within this Domain.



  • The Generator configuration for the selected Domain will appear on the right. 



  • The top pane lists the Attributes for the selected Domain using the selected Generator.

  • You can select an Attribute to view its Generator configuration.



  • The middle pane displays the Generator configuration for a selected Attribute. Here you can do the following: 
    • Make Generator Parameter Configuration Changes
    • Remove the Generator
    • Link Generators

  • You can select each Attribute within the top pane and make any needed changes.



  • The bottom pane can be used to search for and copy Generators to other Attributes. Select a Search Criteria option, enter a Keyword, and then click on Search.



  • The search results will appear below the filter field. You can click on a checkbox to select a Domain Attribute to copy the Generator to or use the checkbox above the Selected column to select all search results. 


  • Once selections have been made, click the Copy Generator button.


  • Once Generator Tuning has been completed, click on XTS Wizards in the breadcrumb bar.



  • Then click on Mark Completed for Step 3.



  • Click Yes in the prompt window.


Step 4: Receiver Assignment Wizard

The Receiver Assignment Wizard can be used to select a Receiver, filter to a set of Domains, and assign the Receiver to each Domain within the filtered set of Domains.  

  • Select the Receiver Assignment Wizard.


  • Click on Take Ownership at the top of the Wizard.



  • Click Yes to confirm.



  • Click on Step 1: Select Receiver in the left pane.



  • Click on the Select Receiver button.



  • Search for and select a Receiver within the Add a Receiver dialog window. For this example the DelimitedFileReceiver will be selected.



  • You can make configuration changes for the Receiver. Click Save Changes once finished.



  • Next click on Step 2: Select Domains within the left pane.



  • Search Criteria- Select a Search Criteria option, enter a Keyword, and click Filter to view Domains matching the criteria: 
    • All - View all Domains.
    • Exact Match - Domain name must match the entered keyword precisely. 
    • Begins With - Domain name must begin with the entered keyword.
    • Ends With - Domain name must end with the entered keyword.
    • Contains - Domain name must contain the entered keyword. 
    • Regex - Domain name must meet the defined regex criteria. Hover over the Regex option to view this criteria.



  • For this example, All will be selected. Click the Filter button to view all Domains.



  • Action Criteria- You may choose to exclude Domains that already have Receivers or replace the currently assigned Receiver for selected Domains that already have a Receiver assigned to them.




  • Select each Domain you want the Receiver to be added to by clicking on its checkbox. You can also use the Select All option above the list of Domains to select all displayed Domains.



  • Then click on Step 3: Execute Changes in the left pane.



  • Click on Start Execution to assign the selected Receiver to the selected Domains.



  • Click Yes in the dialog prompt.



  • The wizard will appear as shown below once the process has completed successfully.



  • Click on Summary (Home) to view a summary of the executed task.



  • Click on Click to Confirm & Validate the Execution Changes button to finish.



  • Click Yes to confirm.



  • Then click on Mark Completed for Step 4.



  • Click Yes in the prompt window.



Step 5: Scenario Assignment Wizard

The Scenario Assignment Wizard is used to filter a set of Domains and have a new Scenario created and assigned to each Domain. 


  • Select the Scenario Assignment Wizard.



  • Click on the Take Ownership button.


  • Click Yes to confirm.



  • Click on Step 1: Select Domains.



  • Search Criteria- Select a Search Criteria option, enter a Keyword, and click Filter to view Domains matching the criteria: 
    • All - View all Domains.
    • Exact Match - Domain name must match the entered keyword precisely. 
    • Begins With - Domain name must begin with the entered keyword.
    • Ends With - Domain name must end with the entered keyword.
    • Contains - Domain name must contain the entered keyword. 
    • Regex - Domain name must meet the defined regex criteria. Hover over the Regex option to view this criteria.



  • For this example, All will be chosen.



  • The filtered set of Domains will appear below the Search Criteria. Use the checkboxes to select individual Domains or use the Select All option to select all Domains.



  • If a Domain already has a Scenario, it will have a checkmark in the second column.



  • If a Domain Scenario is locked, it will have a checkmark in the third column.



  • Click on Step 2: Execute Changes.



  • Click on the Start Execution button.



  • Click Yes to confirm.



  • Click on the Home icon.



  • Click on Click to Confirm & Validate the Execution Changes.



  • Click Yes to confirm.



  • Click on XTS Wizards in the breadcrumb bar to return.



  • Click on Mark Completed for Step 5.



  • Click Yes to confirm.


Step 6: Domain Family Wizard (Coming Soon)

The Domain Family Wizard can be used to filter and categorize Domains into families of related Domains. Family categorization is necessary so that GenRocket can automatically create self serve components on families in Step 7: G-Case Assignment Wizard.



Step 7: G-Case Assignment Wizard (Coming Soon)

The G-Case Assignment Wizard can be used to filter to a set of Domains and have GenRocket auto-create different types of self serve components, such as G-Cases, Stories, and Epics that testers can easily use for testing.




Edit: Attribute Modification Wizard

The Attribute Modification Wizard can be used filter to a set of Domains and globally modify Attribute Parameters within the filtered set of Domains.


  • Select the Attribute Modification Wizard.


  • Click on Take Ownership.



  • Click Yes to confirm.



  • Click on Step 1: Modify Attribute.



  • Use the drop-down menus to select values or the input fields to enter values. When a change is made to an Attribute Parameter, it will have a checkmark.

  • Click Save Changes once finished.



  • Click Yes in the prompt.



  • Click on Step 2: Select Domains within the left pane.



  • Select a Search Criteria option (e.g., All, Exact Math, Begins With) and then enter a Keyword. Once finished, click the Filter button.



  • Click on the checkbox for each Domain to select it or use the Select All option to select all Domains within the search results. 


  • Click on a Domain to to view and select individual Attributes within the Domain. Use the checkboxes to select an entire Domain or individual Attributes within the Domain.



  • Click on Execute Changes.



  • Click on Start Execution.



  • Click Yes in the prompt.



  • The wizard will appear as shown below once execution has finished. Click on Home (Summary).



  • Click on Click to Confirm & Validate the Execution Changes to finish.



  • Click on Yes to confirm.



Edit: Receiver Modification Wizard

The Receiver Modification Wizard can be used to filter to a set of Domains, select a Receiver, modify its parameters, and update all matching Receiver parameters, within the set of Domains. 


  • Select the Receiver Modification Wizard.


  • Click on Take Ownership.


  • Click Yes to confirm.


  • Click on Step 1: Select Receiver within the far left pane.



  • Click Select Receiver to select a Receiver.


  • Each Receiver that has been assigned to a Domain will be displayed in the Add a Receiver to Edit/Delete dialog window.

  • Click the Plus (+) to add a Receiver.


  • Use the input fields and drop-down menus to make changes. Then click on the Save Changes button.



  • Click on Step 2: Select Domains within the left pane.



  • Select a Search Criteria option (e.g., All, Exact Math, Begins With) and then enter a Keyword. Once finished, click the Filter button.



  • Click on each checkbox to select Domains or use the Select All option.


  • Click on Step 3: Execute Changes.



  • Click on Start Execution.



  • Click Yes in the prompt.



  • The wizard will appear as shown below once execution has finished. Click on Home (Summary).



  • Click on Click to Confirm & Validate the Execution Changes to finish.



  • Click on Yes to confirm.



Delete: Receiver Delete Wizard

The Receiver Delete Wizard can be used to filter to a set of Domains, select a Receiver, and remove the Receiver from each Domain.


  • Select the Receiver Delete Wizard.


  • Click on Take Ownership.



  • Click Yes to confirm.


  • Click on Step 1: Select Receiver within the far left pane.



  • Click Select Receiver to Delete to select a Receiver.



  • Each Receiver that has been assigned to a Domain will be displayed in the Add a Receiver to Edit/Delete dialog window.

  • Click the Plus (+) to select a Receiver to delete.



  • Click on Step 2: Select Domains within the left pane.



  • Search Criteria- Select a Search Criteria option, enter a Keyword, and click Filterto view Domains matching the criteria: 
    • All - View all Domains.
    • Exact Match - Domain name must match the entered keyword precisely. 
    • Begins With - Domain name must begin with the entered keyword.
    • Ends With - Domain name must end with the entered keyword.
    • Contains - Domain name must contain the entered keyword. 
    • Regex - Domain name must meet the defined regex criteria. Hover over the Regex option to view this criteria.

  • Click on each checkbox to select Domains or use the Select All option.



  • Click on Step 3: Execute Changes.



  • Click on Start Execution.



  • Click Yes to confirm.



  • The wizard will appear as shown below once execution has finished. Click on Home (Summary).



  • Click on Click to Confirm & Validate the Execution Changes to finish.



  • Click on Yes to confirm.


Delete: Scenario Delete Wizard

The Scenario Delete Wizard can be used to filter to a set of Domains, select one or more Scenarios, and have the matching Scenarios removed from each Domain.


  • Select the Scenario Delete Wizard.


  • Click on the Take Ownership button.


  • Click Yes to confirm.


  • Next, click on Step 1: Select Domains.



  • Search Criteria- Select a Search Criteria option, enter a Keyword, and click Filter to view Domains matching the criteria: 
    • All - View all Domains.
    • Exact Match - Domain name must match the entered keyword precisely. 
    • Begins With - Domain name must begin with the entered keyword.
    • Ends With - Domain name must end with the entered keyword.
    • Contains - Domain name must contain the entered keyword. 
    • Regex - Domain name must meet the defined regex criteria. Hover over the Regex option to view this criteria.



  • For this example, All will be chosen.



  • After clicking on the Filter button, each matching Domain will be displayed below the Search Criteria.



  • The second column will have a checkmark if a Scenario is assigned to the Domain. The third column will have a checkmark if an assigned Scenario is locked.



  • You can select all Domains by clicking on Select All option or select individual Domains using the checkboxes in the first column.


  • You can also click on a Domain Name to view each Scenario that has been assigned to it and use the checkboxes to select or deselect individual Scenarios for deletion.



  • Once finished, click on Step 2: Execute Changes.


  • Click on the Start Execution button.


  • Click Yes to confirm.



  • The wizard will appear similar to below once execution has finished. Click on Home.



  • Click on Click to Confirm & Validate the Execution Changes.



  • Click Yes to confirm.