Share:

On this page, you will find the instructions for Multi-Tier setup. 


Add Database Users

ETL Validator requires Oracle 11 g or Postgresql 9.3 for creating a Repository and Workschema . ETL Validator Repository and Workschema cannot be colocated in the same database user. So, two database users are required. 

PostgreSQL

Repository and Workschema users come out of the box as part of the ETL Validator Complete setup file.

Oracle

Sample Repository User (qprobe) Creation Script

CREATE USER qProbe IDENTIFIED BY qprobe;

GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TYPE, CREATE SYNONYM TO qprobe;

ALTER USER qprobe DEFAULT ROLE NONE;

ALTER USER qprobe quota unlimited on USERS;

Sample Workschema User (qprobews) Creation Script

CREATE USER qProbews IDENTIFIED BY qprobews;

GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE TYPE, CREATE SYNONYM TO qprobews;

ALTER USER qprobews DEFAULT ROLE NONE;

ALTER USER qprobews quota unlimited on USERS;

Information The 'Create Table' privilege should be granted explicitly to the DB user account and not through a role as shown in the above script.

User Privileges

The following queries can be used to check the privileges for a database users created for Repository and Workschema in Oracle database:

SELECT * FROM USER_SYS_PRIVS;

SELECT * FROM USER_ROLE_PRIVS;

ETL Validator makes use of the following system packages for test creating and execution in Oracle. So the repository and workschema database users will need 'Execute' privilege on them:

DBMS_LOB

DBMS_XMLGEN

DBMS_SQL

DBMS_OUTPUT

DBMS_STATS

UTL_RAW

DBMS_OBFUSCATION_TOOLKIT

EXECUTE IMMEDIATE

Information Same privileges are required for creating Workschema.

For more information on Oracle Repository and Workschema, please refer to the knowledge base article in our Support Portal.

Install and Set up ETL Validator Server

Below are the steps for setting up ETL Validator Server

Step 1. Install JDK 1.7 or later

JDK can be downloaded from the oracle website : http://www.oracle.com/technetwork/java/javase/downloads/index.html

Step 2. Install Tomcat 7 or later

  1. Tomcat can be downloaded and installed from the apache.org website : http://tomcat.apache.org/download70.cgi
  2. Create admin users in tomcat that can be used to login from the tomcat manager app. Users can be configured by editing the /conf/tomcat-users.xml file.
  3. Add an entry for the tomcat admin user.
  4. Verify that java_home is set and start Tomcat.

Step 3 : Deploy ETL Validator Server and ETL Validator Service (reporting service) in Tomcat

  1. Download ETL Validator sever using the download URL provided by your datagaps support team and extract it to a local folder.
  2. Login to the tomcat manager app by clicking on the 'Manager App' as shown below using the admin user created in the previous step :
  3. Deploy ETLValidatorServer.war file from datagaps server download using the deployment option in tomcat manager app as shown below :
  4. Verify that the ETL Validator Server got install successfully and is running by clicking on the deploy application link as shown below. It should show a page with the ETL Validator Server version.
  5. Once the server setup is completed, please restart the ETL Validator Server (eg. tomcat) for the updated repository settings to take effect.

Install ETL Validator Client

To install ETL Validator in single-tier, perform the following steps:

  1. Obtain / download the ETLValidator_Client.exe setup file. Trial users and newly subscribed users can download the latest version of ETL Validator from our website
  2. Copy the setup file to the computer/laptop intended for single-tier setup.
  3. Double-click the setup file to launch the installer with License Agreement page displayed.
  4. Select I accept the agreement to accept the terms and agreement of the Datagaps license. Click Next to continue.  
  5. In the Select Additional Tasks page, select Create a desktop shortcut if you want to create a desktop icon for ETL Validator. Click Next to continue. 
  6. In the Ready to Install page, click Install to begin the installation. Allow sufficient time for the installer to complete the installation.
  7. Click Finish to exit the installer when the installation has been completed successfully. 

Set up Repository

  1. Start / launch the ETL Validator Client.
  2. In the Login page, click the plus icon.
  3. In the Repository Details screen that appears, enter all the required information for the type (Oracle or PostgreSQL) of Repository.
  4. Click Test and Save to verify the connection is successful and the repository is saved.
  5. On the Login page, ensure the correct Repository is selected.

Sign In and Configure ETL Validator Server URL

To sign in and configure ETL Validator Server URL,

  1. Click Sign In.
  2. Provide the server URL and click Test. The Server URL format should be http://:/ETLValidatorServer/Execute?wsdl
  3. The following two checks happen when the 'Test' button is clicked : 1. Access to the ETL Validator Server is checked 2. ETL Validator server checks if it is able to connect to the repository
  4. Save the Server Settings.
  5. Restart the tomcat in the server machine so that the ETL Validator Server repository connection details are applied.

Set up Workschema

As the next step, ETL Validator will prompt for Workschema database user details. 

  1. In the Workschema screen, complete all the required connection details.
  2. Click Test to verify the connection is successful.
  3. Click Save to save the Workschema. ETL Validator will now create a Workschema and logs the user into ETL Validator application.
Information For each Client license purchased, Install ETL Validator Client, Set up Repository, Sign In and Configure ETL Validator Server, and Set up Workschema on each user's computer intended to use ETL Validator.

PreviousNext

© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support