The article lists the steps for installing ETL Validator Server and PostgreSQL database. ETL Validator consists of the following components : 

  • ETL Validator Client : ETL Validator Client is a windows based application that provides the User Interface for creating Test Cases, Test Plans and managing their execution in the ETL Validator Server. ETL Validator Client also provides interface for administration of the solution.
  • ETL Validator Repository : ETL Validator Repository stores the metadata related to test cases, test plans, data source connections and users.  It requires an Oracle or Postgresql database. 
  • ETL Validator Workschema : ETL Validator Workschema stores the test data, benchmark data and the data validation results. It requires an Oracle or Postgresql database.
  • ETL Validator Server : ETL Validator server is a J2EE application running in Tomcat used for executing of Test Cases and Test Plans. It has a built in ETL engine for extracting and loading test data from heterogeneous data sources. It also has a scheduler for automatic execution of Test Plans at specified times.
  • ETL Validator Reports : ETL Validator Reports is a web based interface for viewing Test Case and Test Plan run results. In addition, it allows the user to download results in a PDF or Excel format. It is a Java based application that runs in Tomcat along with the ETL Validator Server


Installing ETL Validator Server & Reports


ETL Validator Server & Reports execute in Apache Tomcat. They are provided as two War files: 


  1. Download and install Apache Tomcat 64-bit and Java 8 or later. Below are the download URLs: 
  2. Deploy ETL Validator Server and Reports in Tomcat
    • Copy the two war files ETLValidatorServer.war and ETLValidatorService.war into tomcat by copying the files into the <Catalina Home>/webapps directory
       

Installing PostgreSQL Repository & Workschema


Download and install PostgreSQL 10.3 database : 

https://www.enterprisedb.com/download-postgresql-binaries


Connect to PostgreSQL using PGAdmin Client tool and create two new databases with the names of 'Postgres_Rep' and 'Postgres_WS'.


Install ETL Validator Client


Download and install ETL Validator Client. Create a new Repository database connection. 


Click on the '+' sign next to the repository dropdown and add the repository connection as shown below: 


Provide the Server URL when prompted: 


Provide the Workschema information as shown below: