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.

I need some suggestion to handle multiple data source.

Nihar1991 Posts: 52
edited June 2018 in Virtualize

Hi Team,
While trying to virtualize one of my service (PriceAndAvailability), i faced some issues to handle multiple data source.
let me describe my case below.

  1. I need to virtualize PnA service, which takes single or multiple "IngramPartnumber" as request parameters.
  2. let say, if i create an API test case for one ingram part number then only one ingrampartnumber will go in request parameter. and i have to handle it in a excel sheet.
  3. And if i want to send 2 ingram part number in request parameter, then another excel sheet with 2 ingrampartnumber and API test case need to be created.
  4. so in this way for multiple ingrampartnumber request i need to create multiple API test cases and multiple data sources.

so is there any way to handle this situation?
i have attached all the details. please let me know if any other details needed.

Nihar Ranjan Arisal



  • keegan_chan
    keegan_chan Posts: 59 ✭✭

    Since you're working with hierarchical data in which an element can contains a various number of child elements, you may consider using a data respository as your data source, instead of Excel. Please see "Working with Large Hierarchical Data Sets" for details.

    If you want to use Excel data sources you already have, here's an alternative. As you already mentioned, each Excel data source can only handle the case for one fixed number of child elements. Therefore, you would need a responder for each Excel data source. You can use responder correlations on the request body, using xpath to correlate the number of the relevant elements.

  • paddu31
    paddu31 Posts: 1

    I have single data sheet with multiple tabs. Each suite runs with the test data in each tab. So every time I have to change tab for every suit of services manually . Can I run all
    My suites simultaneously by automatically going to each tab with out me changing manually to each.

  • jakubiak
    jakubiak Posts: 798 admin

    Instead of creating a single data source, you can create multiple data sources that all point to the same Excel file, but where each data source specifies a different sheet within the file.