On this help page, you will find the instructions for upgrading the ETL Validator.
Upgrading Single-Tier Setup
In a typical Single-Tier setup, the ETL Validator Client and Server are both installed in a single computer and used by one user.
Below are the upgrade steps for Single-Tier setup:
- Ensure that you have followed the steps outlined in Pre-Upgrade Tasks.
- Navigate to Programs and Features in your computer, search for ETL Validator software, select it, and then click Uninstall. Follow the instructions (if any) that appear and complete the uninstallation process.
- Run the latest ETLValidator_Complete.exe file and navigate through the installer to complete the installation successfully.
- Open the Windows Services and verify that the ETL Validator Server is up and running. If it is not running, start the Datagaps ETL Validator Server service.
- Start the ETL Validator application. ETL Validator automatically checks for the existing Repository connection and prompts you to log in to the repository.
- On the Log In page, ensure that you have selected the correct Repository and click Sign In. ETL Validator automatically checks the Repository version and prompts with a message to upgrade the repository.
- If the Repository version has changed, you will be prompted to upgrade the Repository. Click OK to upgrade the repository.
- ETL Validator now checks to see if the ETL Validator Server URL is configured properly. Since the Server has been re-installed as part of ETL Validator Complete, a message appears saying that the server is unable to connect.
- In the Server Setting screen, update the ETL Validator Server URL. The Server URL should be http://localhost:6050/ETLValidatorServer/ Execute?wsdl.
- Click Test to verify if the Server is configured with the correct repository information.
- Click Save to save the Server Settings.
- Restart the Datagaps ETL Validator Server service for the changes to take effect. This ensures that the ETL Validator Server knows which repository database to connect to and tells the ETL Validator Client the location of the ETL Validator Server.
- ETL Validator will now finally check if there is a need to upgrade the Work Schema. If so, the Workschema will be upgraded automatically. When all the Workschemas are upgraded successfully, you will finally see the Home page.
Upgrading Multi-Tier Setup
In a Multi-Tier setup, multiple physically separated ETL Validator Clients share common Repository, Work Schema and Server.
Before you move on to perform the upgrade, check and ensure that you have followed all the steps outlined in Pre-Upgrade Tasks.
Upgrading ETL Validator Server
Upgrading ETL Validator Server involves re-deploying the ETLValidatorServer.war and ETLValidatorService.war files in the Application where the ETL Validator Server process is running. The recommended J2EE container for ETL Validator Server is Tomcat 8.5. The steps described here assumes that you have ETL Validator Server running in Tomcat 8.5.
Below are the steps to upgrade ETL Validator Server:
- Open Windows Services and stop the Apache Tomcat Service where ETL Validator Server is deployed.
- Navigate to /webapps and delete the folders ETLValidatorServer and ETLValidatorService. And then, delete the two war files ETLValidatorServer.war and ETLValidatorService.war from the \webapps folder.
- Copy the latest versions of ETLValidatorServer.war and ETLValidatorService.war files to the \webapps folder.
- Restart the Apache Tomcat Windows Service for the changes to take effect.
- Next, ensure that the re-deployed ETL Validator Server has necessary information for Repository connection. To do this, follow the steps given below:
- Start ETL Validator Client.
- Navigate to Admin Options > CONFIGURE SERVER.
- Click Test and then Save once the Url has been tested successfully.
- Restart Apache Tomcat for the changes to take effect. This ensures that the ETL Validator Server and the ETL Validator Service (reporting) knows which repository database it needs to connect to and tells the ETL Validator Client the location of the ETL Validator Server.
Upgrading ETL Validator Client, Repository and Work Schema
Upgrade ETL Validator Client, Repository and Work Schema involves re-installing of the ETL Validator Client and a one time upgrade of the ETL Validator Repository and Work Schema when the ETL Validator Client connects to the repository after the client upgrade.
All the ETL Validator Clients need to be upgraded before they can connect to the upgraded Repository and Work Schema. Hence, plan the upgrade in a such way that all Clients can be upgraded in a single stretch. This will avoid you to cause inconvenience to your users from downtime, if ETL Validator Clients are upgraded in batches.
Below are the steps to upgrade ETL Validator Client, Repository, and Workschema:
- Navigate to Programs and Features, search for ETL Validator software, select it, and then click Uninstall. Follow the instructions (if any) that appear and complete the uninstallation process for ETL Validator Client.
- Verify that the ETL Validator Server service is upgraded and up and running. If not, please start the Server.
- Run the latest ETLValidator _Client.exe file and navigate through the installer to complete the installation successfully.
- Start ETL Validator Client. ETL Validator Client now automatically checks for existing repository connections and prompts you to login to the repository.
- Click Sign In. ETL Validator Client checks the Repository version and automatically prompts a message if a Repository Upgrade is needed.
- Click OK to upgrade the Repository.
- ETL Validator Client next checks to see if the ETL Validator Server is configured properly. If the Server was already upgraded and configured, the Configuration screen skips the Server Settings. Otherwise, you will be prompted to update Server Settings.
- ETL Validator will now finally checks if there is a need to upgrade the Work Schema. If so, the Workschema will be upgraded automatically. When all the Workschemas are upgraded successfully, you will finally see the Home page.
- Repeat steps 1 through 8 for each individual ETL Validator Client setup in your environment.
If you run into any issues during upgrade, or have any questions on upgrade, please contact Datagaps Support.
© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support