Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

- SOATest Automation Scale Up with Data Source

hemanthpv
hemanthpv Posts: 8

Is there an ideal limit to the data rows that can be used in a single run before it gets a performance issue? The JSON script contains 8 test case pairs that compare the responses to make sure it is identical. The task is to compare 10K+ records in total

Comments

  • benken_parasoft
    benken_parasoft Posts: 1,228 ✭✭✭

    Data sources are loaded into memory at the start of test execution, before the first test executes. This could include data read from a CSV or Excel file on disk. So, the size of your data source should not impact test execution, aside from some small, typically imperceptible amount of time while data source row/column data is being loaded into memory from the disk.

    Your data source can be as large as you like as long as enough memory is available. However, if for some reason SOAtest runs out of memory then you can allocate more as described here. Certain data source formats like Excel also have their own limits on numbers of columns and rows as described here.

  • hemanthpv
    hemanthpv Posts: 8

    Thank you @benken_parasoft

  • hemanthpv
    hemanthpv Posts: 8
    edited February 2021

    Is there an option to write couple of fields extracted from response via Json/XML Data Bank to against the respective data rows ?

  • benken_parasoft
    benken_parasoft Posts: 1,228 ✭✭✭

    Data sources are used to make tests cases loop, row-by-row, where each iteration uses a different row. So, you would need to make sure the row for that particular test invocation also contains the data you wish to use for validation. In other words, your data source could have some columns containing data you send in the request and other columns containing the data you want to verify in the response.

  • jakubiak
    jakubiak Posts: 795 admin

    If you need a validate fields using values in your data source, you can use a JSON/XML Assertor and configure the expected value to point to a column from your data source.

  • hemanthpv
    hemanthpv Posts: 8

    I need to extract values from response to verify elsewhere ,,, for Example My Request creates and application (with application ID) using the customer data fed from a data sheet and Application ID from the response need to be extracted and written in a Excel file...

  • jakubiak
    jakubiak Posts: 795 admin

    SOAtest does not have built-in ability to write extracted values to Excel - you would have to write code to do that yourself. However, using an XML or JSON Data Bank, you can store the values to be used later - use either the custom column option or the Writable Data Source to store values to use later.

  • hemanthpv
    hemanthpv Posts: 8

    Thanks @jakubiak