Informatica DVO installation steps

1      About This Article

The purpose of this article is to explain the steps involved in installing and configuring Data Validation Option for usage with Informatica PowerCenter installed on a local machine.

Informatica PowerCenter Server can be installed on a remote machine other than the local machine. But installation of Data Validation Option should be done on the same machine as the Informatica PowerCenter Client.

2      Functional Overview

Informatica Data Validation Option enables you to test and validate data. It requires the installation of, and does much of its work through, Informatica PowerCenter.

Data Validation Option reads table definitions from PowerCenter metadata repositories, and checks the data at either end of the process. It does not check the correctness of transformations or mappings. Data Validation Option identifies problems or inconsistencies. It does not attempt to identify the source of the problem in the ETL process.

3      Pre Requisites and Permissions

3.1          Pre-requisites

·The Informatica domain must contain at least one PowerCenter Integration Service.

·Install PowerCenter Client on the same machine where Data Validation Option will be installed.

·PowerCenter Client is setup with at least one PowerCenter repository.

·Informatica user should have privileges to create a folder in Informatica PowerCenter Repository Manager and to create a relational connection in Informatica Workflow Manager.

3.2          System Permissions

We require certain system permissions to complete Data Validation Option installation and configuration. To complete Data Validation Option setup, verify that you have the permission to complete the following tasks:

·To create a database, including the ability to create schemas, tables, indexes, sequences, and views.

·To create a PowerCenter connection object in the Workflow Manager.

4      Pre - Installation Steps

STEP-1: Create SQL user account for DVO repository

· Create a new user\schema and make sure this user is having privileges to create and modify tables, indexes, sequences and views

STEP-2: Create folder in Informatica PowerCenter Repository Manager

· Login to the Informatica PowerCenter repository from the PowerCenter Repository Manager tool

· Create a folder . This folder is needed by DVO to store the mappings, sessions and workflows that get generated while performing tests and to execute these tests. Every DVO user must have the privileges to use this folder

· As a best practice, do not store other mappings and workflows in this folder

STEP-3: Create relational connection in Informatica Workflow Manager

·Login to the Informatica PowerCenter repository from the PowerCenter Workflow Manager tool and create a relational connection that points to the DVO repository database created in STEP-1. This is needed for Informatica PowerCenter Integration Service to connect to the DVO repository to store the test results in the DVO repository tables

.All Data Validation Option users must have the permission to use this connection.

STEP-4: Before you install DVO, gather the below information that you need during  installation 

·Informatica Domain name

·PowerCenter Integration Service name

·PowerCenter Repository Service name

·PowerCenter Repository user name

· PowerCenter Repository password

·Location of the domains.infa file on the client machine

5      Installation Steps

STEP-1: Close all other applications before running the installation

STEP-2: Run the installer from the following location : < Download location>\Install_DataValidator_.exe

STEP-3: In the Welcome panel, enter the location where you want to install Data Validation Option and Click Next.

STEP-4: Select the Start Menu folder where you want to create Data Validation Option shortcuts

·         Optionally, select Create shortcuts for all users.

·         Optionally, select don’t create Start Menu items to skip creation of Start Menu items.

·         Click Next.

STEP-5: The installer shows the progress of the installation. When the installation is complete, the Installation Summary window displays the status of the installation

·         Optionally, select Run PowerCenter Data Validation Option to run Data Validation Option after you exit the installation.

·         Optionally, select create a Quick Launch icon to create a quick launch icon to launch Data Validation Option.

·         Optionally, select create a Desktop icon to create a desktop icon to launch Data Validation Option.

STEP-6: Click Finish

6      Post - Installation Steps

STEP 1: On the client machine, create an environment variable called INFA_HOME and set the value to the location of the domains.infa file. The location of the domains.infa file is \clients\PowerCenterClient\.

STEP 2: Create a folder in the root directory on the Informatica Services machine and copy the Data Validation Option JAR file, dvoct.jar, from the \powercenterlibs directory on the Data Validation Option Client to that folder.

STEP 3: Update the Java SDK Class path for the PowerCenter Integration Service with the path of the Data Validation Option JAR file. 

STEP 4:  Configure the Data Validation Option repository in the Data Validation Option Client.

           

       Configure the Data Validation Repository with the database details.

1.In the Data Validation Option client, select Tools > Preferences > Data Validation Option.

2.The Preferences dialog box appears.

Enter the following database information:

Option	Description
User	Any User name for Data Validation Option.
Database Type	Type of database created for Data Validation Option repository. Select required database.
Database URL	Connection string to connect to the database. Update the string with the details of the  Data Validation Option repository database.
	The following connection strings appear for the different databases:
	1. Oracle : jdbc:informatica:oracle://:;ServiceName=
	2. Microsoft SQL Server : jdbc:informatica:sqlserver://:;DatabaseName=
	3. IBM DB2 : jdbc:informatica:db2://:;DatabaseName=
Database User	Database user name.
Database Password	Database user password.

3.Click Test to make sure the database information is correct.

4.Click Save, and create the Data Validation Option repository schema when prompted.

7      Configuring DVO Repository

STEP 1: Add the PowerCenter repository to store the mappings that Data Validation Option creates in the Data Validation Option client.

Property	Description
Name	Name of the repository. When you create a repository, enter a name that indicates whether the repository is a source or a target repository. When you edit a repository, you cannot change the name. The repository name is case sensitive.
Client Location	Location of the pmrep.exe file on the client machine. Typically the location is: C:\Informatica\\clients\PowerCenterClient\client\bin.
PowerCenter Version	The PowerCenter version.
PowerCenter Domain	The Informatica domain name.
Repository	The name of the PowerCenter repository.
User name	The user name for the PowerCenter repository.
Password	The user password for the PowerCenter repository.
Security Domain	The LDAP security domain. Leave this field blank if you use native authentication.
Contains Target Folder	Indicates whether the repository is a source or target repository. Select false if the repository you create is a source repository. Select true if it is a target repository. When you select true, you must specify the Target Folder, Integration Service, and Data Validation Option Results Warehouse Connection information.
Target Folder	The name of the folder that has been set up in the PowerCenter repository to store the mappings generated by the tests set up in Data Validation Option.
Integration Service	The name of the PowerCenter Integration Service.
Data Validation Option Results Warehouse Connection	The name of the PowerCenter connection to the Data Validation Option repository.

STEP 2: Click Test to make sure the Repository is created successfully

STEP 3: Save and close the window