Create a Connection to the Data Validation Option Repository
Create a Connection to the Data Validation Option Repository
Create a connection to the Data Validation Option repository to enable the PowerCenter Integration Service to write test results to the repository.
In the PowerCenter Workflow Manager, click
Connections
Relational
.
Click
New
.
In the
Select Subtype
dialog box, select the database type of the Data Validation Option repository.
Click
OK
.
Enter the connection name and database properties.
Enter a meaningful connection name that implies that the connection is for Data Validation Option repository. For example, enter the name DataValidationOption_Repository.
Click
OK
.
Click
Permissions
.
The
Permissions
dialog box appears.
Select the PowerCenter user associated with Data Validation Option.
Grant Read, Write, and Execute permissions on this folder to the user.
Record the connection name.
You must specify this connection name when you add a PowerCenter repository for Data Validation Option.
Click
OK
.
If the Data Validation Option repository is in a secure domain, ensure that you perform SSL configurations for the required databases and the Data Validation Client machine can access the databases through SSL mode.