2 Implementing and Configuring

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.

Getting Started

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:

1. Install the Fusion PIMDH server (including the latest patch sets)

2. 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.

3. 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.

Preparing for Implementation

Locate and unzip the Fusion PIMDH release 11g (11.1.1.6) product:

1. Log in to your Oracle DataLens Server system as your administrator user.

2. 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.

3. Unzip MW_HOME/edqp_template1/opdq-connectors-11-1-1-6.zip in the same directory to extract all files.

4. Create a directory named FUSION_PIM.

5. Unzip the opdq-connector-fusion_pim.zip file to the FUSION_PIM directory to extract all files.

EDQP for Fusion PIMDH Package Contents

The EDQP for Fusion PIMDH product package contains the following:

opdq-connector-fusion_pim.zip- DSA and data lens files in the autodeploy directory structure:

Implementing the EDQP for Fusion PIMDH Files

Implement the EDQP for Fusion PIMDH application DSA and data lens files:

1. 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.

2. 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.

3. Log out of the Oracle DataLens Administration Server system.

4. Wait 10 minutes to ensure that the DSA and data lens files have been autodeployed.

5. 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.

6. Verify that the DSAs and data lens have been autodeployed.

Establishing the EDQP Oracle DataLens Server Connection

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

Enabling Fusion PIMDH DQ Processing

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.