UncategorizedNo Comments

default thumbnail

Enterprise Data Quality for Product Data This is the third blog in a series about Agile 9.3.2’s integration with Oracle’s Enterprise Data Quality for Product Data (EDQP), which walks through the Agile PLM 9.3.2 and EDQP Integration White Paper to explore the integration’s setup and capabilities. This edition will focus on section 3 of the whitepaper

Section 3: Installing EDQP templates and and configuring the integration

The main objectives of section 3 are to:

  1. Create the EDQP database connection to Agile’s database
  2. Install the sample files
  3. Update the Excel services

Prior to starting the series, Agile PLM 9.3.2 and EDQP’s Admin and Transform servers were installed, so these will not be covered.  An entire blog series could be written on each product and it is beyond the intended scope of the series

Create the EDQP database connection to Agile’s database

Perform the following steps to create a database connection so EDQP can connect to Agile’s database

  1. Open a browser and log into the EDQP administration site.  By default this should be at http://:2229/datalens
  2. Navigate to: Adminstration (tab) | Configuration (section) | Database Connections
  3. Click New Connection
    1. Per the instructions, you must enter PLM_CONNECTOR as the name and description
    2. Select Standard as the connection type
    3. Select Oracle as the connection type
    4. Change the connection parameter for your hostname, port and database name
    5. Set the username and password appropriately.  Consider creating a separate account for the integration – in the video, I just used the agile user for demonstration purposes
    6. Test the connection and Save

The documentation was actually incorrect. The database connection name should be APLM_CONNECTOR, not PLM_CONNECTOR!

Install the sample files

To install the sample files:

  1. Log into the host that is running the Admin Server processes
  2. Copy the patch contents to the following autodeploy directories. These are the paths created during a standard (default) installation. Be careful that you copy to the Admin Server autodeploy directory, not the weblogic autodeploy directory!
  3. MW_HOME/user_projects/domains/dls_domain/opdq/autodeploy/dsa
  4. MW_HOME/user_projects/domains/dls_domain/opdq/autodeploy/lens
  5. If you are in the Admin Server web application, log out
  6. Wait about 10 minutes for the patch to be deployed
  7. Log into the Admin Server’s web console
  8. Navigate to Administration (tab) | Server (section) | DSAs
  9. The 3 DSAs should be present

 Installation of EDQP sample files


Update the Excel services

According to the manual:

“The EDQP Services for Excel has the capability to normalize the view of attribute output name /value column pairs by changing them into a single column with the attribute name as the header value suitable for import into the Agile PLM system.”

Do the following to turn this feature on:

  1. Close any open Excel workbooks
  2. Navigate to the following directory %AppData%DataLensconfig
  3. Edit the dlsforexcel_cfg.xml file
  4. Add the following XML to the properties node as seen in the guide:
  5. Save and close the document

The Video

Here is the video for section 3 of the whitepaper:


Next Time

In the next blog I will cover section 3 of the white paper


Be the first to post a comment.

Add a comment