Extract the ETL Validator Complete zip file and double click on the .exe file to start the setup wizard. The install wizard will prompt for the Java location. Please select the JRE or JDK home directory. Also, please install the .Net framework when prompted to complete the install.
Verify that the following three windows services are running : DatagapsETLValidatorDatabase, DatagapsETLValidatorpgbouncer & Datagaps ETL Validator Server.
Login to ETL Validator
ETL Validator should open up automatically after the install with a login screen. The default user name / password is admin/admin which is prepopulated. ETL Validator comes with an embedded repository database (PostgreSQL) for storing the test case metadata and results. This repository is sufficient for most pilots. Click on the "Login" button. You will be prompted to register the license file or select 30 day trial. Pick the latter.
Connect to your Data Sources
After login, click on the Create Data Source Connection to create a connection to your data source. ETL Validator support testing of most popular relational databases (such as Oracle, SQL Server, Netezza, DB2), flat files (both delimited and fixed width), XML, Excel & Hadoop Hive2.
Start creating Test Cases and Test Plans
Once the connections have been created successfully, click on the menu in the top left corner to start creating test cases and test plans. Please contact us with any questions or issues. Query Compare test case is a good starting point if you want to compare data from one relational database to another. You can find a lot of useful information such as use cases and videos on how to use ETL Validator in the resources section below.
ETL Validator ResourcesTry ETL Validator free for 30 days or contact us for demo