Versions Compared

Old Version 6

changes.mady.by.user Chieko Sugizaki

Saved on

compared with

New Version 7

changes.mady.by.user Chieko Sugizaki

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space FUNCTDEV and version SVC2021.2

...

The most common method for populating a repository is to use the Generate Parameterized Messages wizard when creating a virtual asseta test suite, but you can also structure and populate a data repository with Excel, WSDL, or schema files using the Data Repository Tool. The Data Repository Tool specifies the data to import, how to structure it, and which repository data source should be include with the imported data.  Info

titleUse Case Clarifications
  • Data Repository Tool functionality is not applicable to SQL data sets. For details on how to create a virtual asset from a database recording, see Creating SQL Responders from a Database Recording.
    • The Data Repository Tool is not intended to create virtual assets that are parameterized from a data repository. For details on how to create parameterized message responders from traffic, see Creating Parameterized Message Responders from Traffic.

    Preparing to Import from Excel

    ...

    • test automation
      • AT-1, Introduction to Automated Testing, Mondays
      • AT-2, Intermediated Automated Testing, Wednesdays
      • AT-3, Advanced Automated Testing, Fridays
    • service virtualization
      • SV-1, Introduction to Service Virtualization, Mondays 
      • SV-2, Intermediate Service Virtualization, Wednesdays
      • SV-3, Advanced Service Virtualization, Fridays
    • environment management
      • EM-1, Introduction to Environment Management, Mondays
      • EM-2, Intermediate Environment Management, Wednesdays
      • EM-3, Advanced Environment Management, Fridays
    • static analysis
      • SA-1, Introduction to Static Analysis, Mondays
      • SA-2, Intermediate Static Analysis, Wednesdays
      • SA-3, Advanced Static Analysis, Fridays
    • unit testing
      • UT-1, Introduction to Unit Testing, Mondays
      • UT-2, Intermediate Unit Testing, Wednesdays
      • UT-3, Advanced Unit Testing, Fridays

     See  

    Parameterizing Arrays of Varying Size 

    for additional information about dsref* and ParentIndex columns.

    ...

    • [parasoft_exclude]
    • [exclude]

    ...

    Adding the Data Repository Tool

    1. Ensure that the Data Repository Server you want to import data into is running.

    2. Create a newprovisioning action file .tst file with an empty action suitetestin a new project or existing project. See Adding Projects, Virtual Assets.tst files, and Responder Test Suites.

    3. Add a new Repository Data Source to the suite. See Creating a Repository Data Source. 

    4. Open the data source and specify the target data set for importing the data. You can browse existing repositories on the server in the Repository view (see Views in VirtualizeSOAtest ). If the specified repository name or data set does not exist, it will be created at runtime.

    5. Right-click the Action Suite node Test node and choose Add New> ActionTest.and choose Data Repository Tool. 

    6. Click Next. and configure the data and structure initialization options. See Configuring Initialization Options.

    7. Click Finish and configure the Data Repository Tool.

    ...

    NameSpecifies the name for the node.
    Data SourceSpecifies the Excel workbook used to initialize the data (see Configuring Initialization Options). If the None option was enabled, this field will be empty and data will need to be added manually using the data source editor (see Viewing and Modifying the Repository Structure and Contents).
    Sheet NameSpecifies a sheet name when importing from Excel.
    Join Column

    Specifies the name of the column used for indicating relationships across Excel sheets. By default, the ParentIndex column is used (see Defining the Structure). 

    If the value in a record’s Join Column matches the value in a Parent Join Column record, then that record becomes a child of the parent record.

    This setting is not available for column-level nodes. 

    This setting cannot be configured for worksheet-level nodes at the root of the tree.

    Parent Join Column

    Specifies the column in the parent node used for indicating relationships across Excel sheets. By default, the value is set to <Row Number>, which specifies that the column correlates to the parent row number. 

    If the value in a record’s Join Column matches the value in a Parent Join Column record, then that record becomes a child of the parent record.

    This setting is not available for column-level nodes. 

    This setting cannot be configured for worksheet-level nodes at the root of the tree.

    Data ColumnSpecifies name of the column containing the data.
    Field Type

    Specifies which type the data should be imported as. You can specify one of the following types:

    • Record List: Series of complex records that are hierarchical and have multiple fields/columns.
    • Primitive List (see Support fro Primitive Lists): A list of primitive types.
    • Array: An array of primitive types.

    See Viewing and Modifying the Repository Structure and Contents for additional information about types.

    Specifying Data Set Keys 

    ...

    .

    ...

    See Responder Correlation Tab for additional information.

    Running the Tool

    Select the Data Repository tool that and click Run in the toolbar.Image RemovedImage AddedDetails on the import will be reported in the Console view.

    ...

    Any problems with the import will be reported in the progress view. For instance, the following message might occur if you are trying to import data into a Repository Server that is not currently running.Image RemovedImage Added