Setup BI Validator Server

BI Validator has the following three major components: 

  • BI Validator Desktop Client for be used to setup BI Connections, create test plans and execute them
  • BI Validator Repository database stores BI Connection/Test Plan metadata and test results. Supported databases are PostgreSQL and Oracle
  • BI Validator Server provides web-based reporting and test execution of scheduled test plans. BI Validator Server is also needed if you want to invoke test plans remotes using a command line tool or the REST API interface. It comes with an embedded Tomcat and JRE. 

 

Installing BI Validator Server

BI Validator Server can be easily setup by downloading and install BI Validator Server software. 

It comes pre-configured to work with the default PostgreSQL repository database. 

BI Validator Server runs as a windows service as shown below. https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/1067291998/original/z2cA07E-XYftcmxuMYHhg3RJXT5-2KDraQ?1531508758

 

 

Configuring BI Validator Server:

To open the BI Validator Server screen, click the Start menu and navigate to Datagaps > Configure Server.

 

Configuring a server depends on either of the cases described below


If both BI Validator Client and BI Validator Server are installed in same machine.

Specify the Host to localhost for the repository details since client repository is in the same machine.

Please refer below snippet for reference.

 

If both BI Validator Client and BI Validator Server are installed in different machine.

Specify the Host with IPAddress/Hostname of the machine where client is installed while adding the repository details.

Click Test to verify whether the connection is successful.

 

 

If you are using active directory for accessing your BI environment, please modify the 'Log On As' user property for the BI Validator Server windows service.
https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/1067292129/original/X38LEKTNoJ06I_2oW4bjWr3KHQAC9ku3yg?1531509042

 

BI Validator Reports can be accessed by navigating to the following link: 

http://localhost:6090/BIValidatorService

 

The default password for 'admin' user is pre-populated. The password for the web reports is encrypted version of your BI Validator Client password. This can found by accessing the top right corner menu: 'Admin'-> 'Settings' -> 'My Account'

https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/1067292649/original/_Hviddo7pHT6CHDhWj-EwWcPuqQXhitU9g?1531510264

 

BI Validator reports can also be used to execute test plans from the web-based browser. 

 

Upgrading BI Validator Server

Upgrading BI Validator is a two step process : 

  • Uninstall BI Validator Server
  • Install the latest version of BI Validator Server

 

Note:Both BI Validator Server and BI Validator Client should be of the same version. 

 

Please contact support if you need the download location for the BI Validator Server.