Wednesday, April 12, 2017

Step by step Installing Oracle Enterprise Data Quality for Product Data on Windows

Installing Java

Double click on the setup file

click next

Provide installation path and click next

click next

click close

Installing Weblogic

click next

click next

uncheck and click next

click continue

select typical and click next

click next

click next

click next

click next

click done

Installing the patches to weblogic server using Oracle Smart Update

Download the patch through meta-link using the patch id or bug no.
Uncompressed patch zip file to $MWHOME/utills/bsu/cache_dir (If the cache_dir folder is not available then create the same)

Launch the Oracle Smart Update Tool (bsu.cmd) from $MWHOME\utils\bsu, this will list all the applied patches and all those patches that are ready for installation

click ok

click ok

Installing Enterprise Data Quality for Product Data

click next

select skip software updates and click next

click next

click next

click install

click next

click finish

Configuring domains

click next

click next

give domain name and click next

provide user name and password and click next

click next

select administration server and click next

provide port no and click next

click create

click done

Modifying Environment variables

Creating the Oracle Database PDQ Respository Schema


Change directories to the /MW_HOME/user_projects/domains/dls_domain/opdq/data/repository/ddl_scripts directory.


Enter sqlplus dlsadmin/dlsadmin1 to log into SQL*Plus.

Enter the following commands at the SQL> prompt:





Configuring the EDQP WebLogic Server Domain to Use the PDQ Respository Data Source

Ensure that your WebLogic Server is running on your Oracle DataLens Administration Server

navigate to services -> data sources

click new and select generic data source

provide name, jndi name, database and click next

select database driver and click next

click next

provide the details and click next

click test configuration

click next

select admin server and click next

Autodeploying Data Lenses to the New Database

The EDQP Smart Glossaries delivered with EDQP are automatically deployed (autodeployed) to the standard Derby database so when you change to a new database you must autodeploy these assets for use in that database.

 To autodeploy the EDQP Smart Glossaries: 

On your Oracle DataLens Administration Server system, log in using the administrator user you established when installing the server in preparation to copy the necessary files. 

Copy the MW_HOME\edqp_template1\autodeploy\lens directory that you extracted from the product package to the WebLogic dls_domain directory on your Oracle DataLens Administration Server. By default, these directories are: 

On Linux and UNIX: MW_HOME/user_projects/domains/dls_domain/opdq/autodeploy/lens 

On Windows: MW_HOME\user_projects\domains\dls_domain\opdq\autodeploy\lens

No comments:

Post a Comment

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...