BI Validator Client comes with an embedded repository (Firebird) that works fine for evaluation of the software or using it in a standalone mode. But often users want to collaborate and share test plans in a team environment. They also want to schedule test plans. For this we need to setup an Oracle repository and the BI Validator Server. 


Prerequisites: 


  • An Oracle 11g or 12c database account. A sample script for creating the account is shown below: 

        CREATE USER BIValidator IDENTIFIED BY "BIValidator" DEFAULT TABLESPACE "USERS" TEMPORARY TABLESPACE "TEMP" PROFILE DEFAULT QUOTA UNLIMITED ON "USERS";
         GRANT "CONNECT", 
"RESOURCE", CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE TRIGGER, CREATE PROCEDURE, CREATE TYPE TO BIValidator;
         ALTER USER BIValidator DEFAULT ROLE NONE;


Additional Privileges

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

DBMS_LOB
DBMS_XMLGEN
DBMS_SQL
DBMS_OUTPUT
DBMS_STATS
UTL_RAW
DBMS_OBFUSCATION_TOOLKIT
EXECUTE IMMEDIATE


Recommended Table Space : 40 GB


  • BI Validator Server software that is the same version as the BI Validator Client you are using. Please contact support if you need the download instructions for the BI Validator Server.

  • BI Validator Server is available only for windows - Windows Server, Windows 7/2008/2010

Configuration Steps for setting up Oracle Repository: 
  1. Start BI Validator Client and click on the plus sign to add a new repository in the login screen as shown below :



  2. Enter the Oracle repository connection information for the oracle database account with privileges as mentioned in the prerequisite above.



  3. Click on 'Test' to connect to the repository. If the connection is successful, BI Validator show a message asking to create the Repository tables automatically. One the repository scripts are executed, you can share with repository connection details with other users in your team so that they can connect to the same repository and share the Test Plans with you.

Configuration Steps for setting up the BI Validator Server : 
  1. Install Apache Tomcat 8 or later in a Windows Server machine with JDK 8 or later.

  2. Deploy BI Validator Server and Service War files in the Tomcat by copying BIValidatorService.war and BIValidatorServices.war files in the <catalina_home>/webapps directory.


  3. Edit bivalidator.properties file to update the repository connection details as shown below for the Oracle Repository.


    org.quartz.dataSource.myDS.URL=jdbc\:oracle\:thin\:@hostname\:1521\:orcl
    org.quartz.dataSource.myDS.server=<hostname>
    org.quartz.dataSource.myDS.sid=<Oracle SID>  or  org.quartz.dataSource.myDS.servicename=<Oracle Service Name>
    org.quartz.dataSource.myDS.port=<Port>
    org.quartz.dataSource.myDS.password=<password>
    org.quartz.dataSource.myDS.user=<User Name>
    org.quartz.dataSource.myDS.RepName= <Repository name> (Name for your repository connection. Can be any string)


    Copy the bivalidator.properties file to the <catalina home>/bin/config directory.

  4. Restart Apache Tomcat and verify the repository connection by opening the reporting URL. 


  5. Open BI Validator Client and login to the Oracle repository where the server is configured to connect. Go to the "Admin->Settings->Manage Server" from the top right corner menu and make sure the port in the url is mentioned correctly. Restart BI Validator Client.


BI Validator Home Page : http://www.datagaps.com/bi-testing-tools/bi-validator