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.

Can one test script use two separate data sources?

LegacyForum Posts: 1,664 ✭✭
edited December 2016 in SOAtest

Is is possible to use 2 data sources in 1 test script?

I am comparing an excel workbook with 7 worksheets using the DBTool. Each worksheet represents a test case.

The issue is the SQL that is being used to generate the excel workbook is using &Date and &SSN which are referenced on the first worksheet of the excel workbook. &SSN is part of the results for each worksheet so referencing &SSN is can be pulled from each worksheet.

The &Date is only reference on the First worksheet but is needed to run the SQL in the DBTool script.

The same SQL is being used in the DBTool to compare the results after a BATCH cycle, but I am only able to reference &SSN since this is part of the results for each worksheet in the excel workbook. The DB script is referencing the specific worksheet that contains various values and the SSN.

How can I also Reference &Date if this is only found on 1 worksheet of the excel workbook?