Oracle® Enterprise Data Quality for Product Data Fusion PIM Integration Implementation and User's Guide Release 11g R1 (11.1.1.6) Part Number E29148-02 |
|
|
PDF · Mobi · ePub |
This chapter provides information you need to get started implementing EDQP to work with Fusion PIMDH, including prerequisites, preparing to implement, and the components in the product package.
To use all of the EDQP for Fusion PIMDH functions, you must ensure that you have completed the following actions before implementing, configuring, or using it:
Install the Fusion PIMDH server (including the latest patch sets)
Install and configure an EDQP 11g (11.1.1.6) Oracle DataLens Server. For instructions, see Oracle Enterprise Data Quality for Product Data Oracle DataLens Server Installation Guide.
The Fusion PIMDH product is included in the EDQP installation as a zip file.
Install and configure the EDQP Services for Excel 11g (11.1.1.6). For instructions, see Oracle Enterprise Data Quality for Product Data Services for Excel Reference Guide.
Locate and unzip the Fusion PIMDH release 11g (11.1.1.6) product:
Log in to your Oracle DataLens Server system as your administrator user.
Locate the Middleware home directory into which you installed EDQP. The default directories are the following:
On Linux and UNIX:
/opt/Middleware/Oracle
On Windows:
C:\Oracle\Middleware
This directory is referenced as MW_HOME
in Fusion Middleware documentation.
Unzip MW_HOME
/edqp_template1/opdq-connectors-11-1-1-6.zip
in the same directory to extract all files.
Create a directory named FUSION_PIM
.
Unzip the opdq-connector-fusion_pim.zip
file to the FUSION_PIM
directory to extract all files.
Implement the EDQP for Fusion PIMDH application DSA and data lens files:
On your Oracle DataLens Administration Server system, log in using the administrator user you established when installing the server in preparation to copy files.
Note:
This step does not refer to the Oracle DataLens Administration Server Web page.Copy the MW_HOME
\edqp_template1\autodeploy
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
On Windows: MW_HOME
\user_projects\domains\dls_domain\opdq\autodeploy
Note:
The preceding directories are the defaults when installing your Oracle DataLens Server; your installation directory may vary.This automatically deploys (autodeploys) the DSA and data lens files to your Oracle DataLens Server. The Oracle DataLens Administration Server polls the autodeploy
directory every 10 minutes and attempts to autodeploy the DSA and data lens files that are placed in the respective folders under the autodeploy
parent folder.
Log out of the Oracle DataLens Administration Server system.
Wait 10 minutes to ensure that the DSA and data lens files have been autodeployed.
Log into the Oracle DataLens Server Administration Web page.
For more information about these Web pages, see Oracle Enterprise Data Quality for Product Data Oracle DataLens Server Administration Guide.
Verify that the DSAs and data lens have been autodeployed.
After implementing Fusion PIMDH, use the Oracle Enterprise Manager to establish or modify the connection with the Oracle DataLens Server. For more information, see Oracle Fusion Applications Post-Installation Guide at:
http://docs.oracle.com/cd/E28271_01/fusionapps.1111/e22380/toc.htm
After you have installed the necessary EDQP components, you must return to PIM and perform the following additional configuration actions that are described in detail in the Item Data Quality Management white paper (see "Related Documents"):
Configure PIM to enable Data Quality (DQ) processing and interface with EDQP.
Configure the DQ ICC verification profile options.
Optional - Define the DQ Alternate Catalog to be used for data processing.
Define the Item Class Catalogs (ICC) that you want to use including valid values for attribute groups and attributes.
For each ICC, set up the DQ processing parameters by defining the attributes that will participate.