|Oracle® Enterprise Data Quality for Product Data Fusion PIM Integration Implementation and User's Guide
Release 11g R1 (18.104.22.168)
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 (22.214.171.124) 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 (126.96.36.199). For instructions, see Oracle Enterprise Data Quality for Product Data Services for Excel Reference Guide.
Locate and unzip the Fusion PIMDH release 11g (188.8.131.52) 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:
This directory is referenced as
MW_HOME in Fusion Middleware documentation.
/edqp_template1/opdq-connectors-11-1-1-6.zip in the same directory to extract all files.
Create a directory named
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.
\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:
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:
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.