Open topic with navigation

Linking to external test data

You can retrieve test data from an external data source by creating a linked datasheet. Linked datasheets are synced between QA Wizard Pro and the external data source, which eliminates the need for manual updates. When changes are made to the test data in QA Wizard Pro or from scripts, the external source is automatically updated and vice versa.

Note: You can only edit linked Microsoft Excel datasheets if Excel is installed on the test computer. You cannot edit linked text datasheets from QA Wizard Pro or scripts.

If you only want to copy test data to a datasheet and make changes locally without affecting the external source, import the data instead. See Importing external test data.

1. Choose Data > Create Datasheet.

The Create Datasheet wizard opens.

2. Select Link to data in external source.

3. Click Next.

4. Select a Datasheet type.

The fields are different depending on the datasheet type. See Configuring external datasheets.

5. Enter or select the Datasheet Options.

6. Click Next.

7. Enter a Datasheet Name.

8. Click Finish.

The datasheet is saved and opened in the Script pane.

Note: To use the data in a script, you need to associate the datasheet with the script and then replace the data in the script with datasheet values. See Associating datasheets with scripts and Using datasheet values in scripts.