INSTALLATION DOCUMENTS BY RAVI

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

CONNECT / AS SYSDBA


















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:

 

@repository_oracle_ddl.sql

 

exit;


















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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...