Dynamic File Selection for Multiple Environments using TDM

 

This guide details the procedure for configuring the Test Data Management (TDM) platform to dynamically select and use different data files for distinct environments, such as Quality Assurance (QA) and User Acceptance Testing (UAT).


1. Prepare the TDM Data File

The initial step involves preparing the primary TDM data file to specify the file names required for each environment.

  • Create Environment-Specific Columns: Within your main TDM data file (the source that TDM uses to look up values), create separate, clearly labeled columns.

    • Example:

      • Column 1: QA_File_Name

      • Column 2: UAT_File_Name

  • Populate File Names: For each record in your TDM, enter the exact file name corresponding to the data required for the QA environment in the QA_File_Name column, and the file name for the UAT environment in the UAT_File_Name column.


2. Overload Files in the TDM Listing Page

The "Overload" feature in TDM is used to associate the physical data files with the column names you created in the previous step.

  1. Navigate: Go to the TDM listing page within the platform.

  2. Access Overload: Locate your specific TDM entry and click the Overload button.

  3. Map Environment: You will be prompted to select the column heading that corresponds to the environment you are configuring (i.e., QA_File_Name or UAT_File_Name).

  4. Upload and Assign:

    • Upload the physical data file intended for the QA environment and map it to the QA_File_Name column.

    • Upload the physical data file intended for the UAT environment and map it to the UAT_File_Name column.


3. Map TDM Column to the Test Action

The final step is connecting this dynamic file selection mechanism to your test case.

  1. Connect Action: In your test case, ensure the relevant action (e.g., an upload step or data consumption step) is connected to the appropriate TDM column.

  2. Dynamic Selection: At runtime, the execution platform (Functionize) will automatically determine the current environment (QA or UAT).

  3. Result: Based on the environment, the platform will dynamically choose the file name specified in the corresponding TDM column (QA_File_Name or UAT_File_Name), ensuring the correct data is used for the test execution.