A typical development cycle consists of developing the ETL in a Development environment and progressing it through Test and Production environments. Each of these environments have their own set of Source and Target data sources. ETL Validator supports executing of test cases developed for one environment (eg. Dev) against other environments (eg. Test, Prod) without the need to change the connections in each individual test case or making a copy of the test cases for each environment. This can be achieved using the 'Environments' feature. 


Lets look at an example configuration for the Dev, Test and Prod environments: 

  • Dev Environment
    • Source Database: Dev_Src
    • Target Database: Dev_Tgt
  • Test Environment
    • Source Database: Test_Src
    • Target Database: Test_Tgt
  • Prod Environment
    • Source Database: Prod_Src
    • Target Database: Prod_Tgt


Below are the steps for setting up and using the 'Environments' feature to run the same set of test cases for multiple environments: 

  • Create Data Source connections for all the above source and target databases in ETL Validator


  • Users can create their test cases using the Dev environment connections (Dev_Src and Dev_Tgt)


  • Navigate to Admin Settings -> Environments and map the connections as shown below. Notice that three environments are created with mapping of the corresponding Source and Target connections for each environment. This process requires access to the 'Admin Settings' for the user.


  • Add your test cases to a Data Compare test plan and select the environment you want to run against in the 'Run' step of the test plan as shown below.