Oracle Enterprise Data Quality for Product Data Endeca Connector Release Notes, Release 4.4 - 11g R1 (11.1.1.6) Endeca© IAP 6.x

Release 4.4 - 11g R1 (11.1.1.6) Endeca© IAP 6.x

E29136-02

Contents

Title and Copyright Information

Preface

- Audience

- Documentation Accessibility

- Related Documents

- Conventions

1 Release Notes

- Endeca Connector Changes from 11g (11.1.1.6.0) to 11g (11.1.1.6.1)

- Endeca Connector Changes from 5.6 to 11g (11.1.1.6)

- DL Foundry Changes from 5.5.03.02 to 5.6

- DL Foundry Changes from 5.5 to 5.5.03.02

- DL Foundry Changes from 5.1 to 5.5

- DL Foundry Changes from 5.0.2 to 5.1

- DL Foundry Changes from 5.0 to 5.0.2

Oracle® Enterprise Data Quality for Product Data

Endeca Connector Release Notes

Release 4.4 - 11g R1 (11.1.1.6) Endeca© IAP 6.x

E29136-02

February 2013

Oracle Enterprise Data Quality for Product Data Endeca Connector Release Notes, Release 4.4 - 11g R1 (11.1.1.6) Endeca© IAP 6.x

E29136-02

Copyright © 2001, 2013, Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Preface

This purpose of this document is to describe changes in each release of Oracle Enterprise Data Quality for Product Data with the Endeca Information Access Platform [formerly known as the Oracle DataLens (DL) Foundry for Endeca.]

Audience

A thorough understanding of the material in this guide is required for the following customer personnel:

- Application and Solution Owners

- Business Analysts

- IT Administrators

- Subject Matter Experts (SME)

Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.

Related Documents

For more information, see the following documents in the documentation set:

- The Oracle Enterprise Data Quality for Product Data Oracle DataLens Server Installation Guide provides detailed Oracle DataLens Server installation instructions.

- The Oracle Enterprise Data Quality for Product Data Oracle DataLens Server Administration Guide provides information about managing an Oracle DataLens Server including users and user roles.

- The Oracle Enterprise Data Quality for Product Data .NET Interface Guide provides information about installing and using the Oracle DataLens Server .NET API.

- The Oracle Enterprise Data Quality for Product Data Java Interface Guide provides information about installing and using the Oracle DataLens Server Java APIs.

- The Oracle Enterprise Data Quality for Product Data Application Studio Reference Guide provides information about creating and maintaining Data Service Applications (DSAs).

- The Oracle Enterprise Data Quality for Product Data AutoBuild Reference Guide provides information about creating an initial data lens based on existing product information and data lens knowledge.

- The Oracle Enterprise Data Quality for Product Data Knowledge Studio Reference Guide provides information about creating and maintaining data lenses.

- The Oracle Enterprise Data Quality for Product Data Governance Studio Reference Guide provides information about building projects to analyze your transformed data, create reports to show the quality of your data, and identify missing attributes.

- The Oracle Enterprise Data Quality for Product Data Services for Excel Reference Guide provides information about creating a DSA based on data contained in a Microsoft Excel worksheet.

See the latest version of this and all documents listed at the Oracle Enterprise Data Quality for Product Data Documentation Web site at:

http://docs.oracle.com/cd/E35636_01/index.htm

Conventions

The following text conventions are used in this document:

Convention

Meaning

boldface

Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.

italic

Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.

monospace

Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.

monospace

Boldface, monospace type indicates commands or text that you enter.

1 Release Notes

This document contains the Oracle Enterprise Data Quality for Product Data Endeca Connector Release Notes for various releases of the product.

Endeca Connector Changes from 11g (11.1.1.6.0) to 11g (11.1.1.6.1)

- Added an example project to illustrate how the Endeca Connector can be implemented.

Endeca Connector Changes from 5.6 to 11g (11.1.1.6)

- Rebranded the application from DL Foundry to PDQ-Endeca Connector.

- Changed the prefix of all pass throughs from SCS to PDQ.

- Changed the package structure of the Java Manipulator Adapter and the Discovery Classes. This is only visible when you are configuring the Java Manipulator in the Endeca Developers Studio.

- Merged the two library files, edqp-addin.jar and edqp-adapter.jar into a single file for both PDQ discovery and the run-time adapter, opdq-connector-endeca.jar.

- Added a new run-time library for the adapter named opdq-core.jar.

DL Foundry Changes from 5.5.03.02 to 5.6

- The following pass thru parameters have been removed:
CLIENT_CODE and HA_LB_ENABLED (in SilvercreekAdapter)

CHECK_VERSION (in Discovery add-ins)

- The version and copyright information has been updated.

- Updated the Windows installation process.

- Changed default for VersionEndecaFiles from true to false (for new core-step add-ins).

- Build Version 5.6.02 -Added the ability to rename Dimensions.xml and pipeline.epx in the add-in parameters,

- Build Version 5.6.03 - Ignore scs_props.xml if the project is not discovering properties.

DL Foundry Changes from 5.5 to 5.5.03.02

- The description of the Attributes. in the AddInTransformParameters configuration file, is updated.

- Verification to avoid adding conflicting precedence rules is introduced. This ensures that you cannot add a child that is already a parent.
It allows multiple levels of precedence rules to be created entirely within the data lens and fixes the problem where manually created precedence rules could break the DL Foundry-created precedence rules.

- Support for the Dimension advanced option Multi Select is introduced.

- The case of the Pipeline.epx file and the Dimensions.xml file to match the lower-case used in Linux is corrected.

- Converted the Dimension Ids from int data type to long to match the Endeca data type for Dimensions.

- Modified the way versioning operates by creating a versioning transform step, rather than separately versioning during each step of the discovery/delete add-in processing.

- The Endeca Developers Studio is removed from the project paths.

- Code was refactored for Oracle (the Java packages and renaming classes were restructured).

- Removed the installation procedure on Windows.

DL Foundry Changes from 5.1 to 5.5

The following are enhancements for increased robustness, failover, reliability and round-robin server support.

- The Host and Port Adapter pass thru parameters have been replaced with the _SERVER_1 required and the _SERVER_2, and _SERVER_3 optional parameters.

- This adds support for multiple Oracle DataLens Servers to be pinged (a DataLens servlet ping) in a round-robin fashion to determine which server to run the Add-In jobs and the Adapter jobs.

- DL Foundry SilvercreekAdapter now retries the current chunk if the Oracle DataLens Server fails during Forge processing so that the Forge job will not fail.

- Using the same server parameters as the round-robin code for Oracle DataLens Servers, the SilvercreekAdapter will catch if a Forge chunk (DSA job) fails during job submittal (sending the data to the server) or during job results retrieval and retry the chunk of data on another Oracle DataLens Server if there is a problem.

- The SilvercreekAdapter fail-over happens (and the data chunk is resubmitted) when one of the following occurs:

- Connection Exception

- Out Of Memory error

- DSA job Fault

- Changed the project versioning to have a separate XFM Add-In that is added to the start of a DL Foundry discovery job. The individual versioning flags for the separate Add-Ins are no longer supported.

DL Foundry Changes from 5.0.2 to 5.1

- DL Foundry Adapter - The pass thru, DSA_OUTPUT_STEP, is introduced. It names the output step if there are more than one output steps in a DSA Map (for instance routing exceptions).

- DL Foundry Add-In - Optional support for Endeca external dimensions file is added as follows:

- SCS-generated Dimensions will not conflict with dimensions in this file. The following parameter in the Endeca.DiscoverDimensions Add-In is introduced:
Endeca.ExternalDimensionsFile

- SCS-generated Precedence rules can use the Dimension names in the external file as a source when creating new precedence rules. The following parameter in the Endeca.DiscoverPrecedence Add-In is introduced:
Endeca.ExternalDimensionsFile

- DL Foundry Add-In - Optional support for generating precedence rules on a data lens by data lens basis is added as follows:

- The following parameters in the Endeca.DiscoverPrecedence Add-Ins are introduced:
SCS.ServerName

SCS.ServerPort

SCS.DataLens

SCS.Standardization

- DL Foundry Add-In - Optional support for precedence rule generation for Dimensions not generated by the DL Foundry if they are in the list of attributes for the specific data lens is added.
SCS.GenerateRulesForAllAttributes

- DL Foundry Add-In - The Endeca.CleanupDimensions TMap Add-In Transform is introduced. It is added to the end of DSA maps performing the DL Foundry discovery to clean up the cached data that is shared by all the Endeca Add-Ins with information on the dimensions from the Endeca Developer Studio project.

- The REPLACE_UNDERSCORES_ONLY parameter is introduced to support respecting the case of attribute aliases, while still replacing underscores with spaces. This is a required pass thru parameter for the DL Foundry Adapter.

- The USE__PREFIX parameter is introduced to toggle off the use of the ”.” prefix in the Prop/Dim mapping table in Endeca. This is a required pass thru parameter for the DL Foundry Adapter.

- Five Add-In Transform parameters (including SCS.ServerName, SCS.ServerPort, SCS.DSAMap) have been consolidated in the SilvercreekAdapter pass thru parameters where they are shared, simplifying configuration.

DL Foundry Changes from 5.0 to 5.0.2

This version of DL Foundry only supports Oracle Product Data Quality 5.0.2 because it uses TMap Add-In parameters introduced in the 5.0.2 release.

- Any DL Foundry discovery process will throw an exception if an error is encountered and the job will terminate. This makes it very easy for you to check the status of these jobs without needing to examine the log files.
In the 5.0 release, errors in any of the DL Foundry discovery processes were written to the Log file, but the Job would complete successfully.

- The DL Foundry discovery processes are now completely integrated with the TMap Add-In Transformations.
Support for the DL Foundry DSA Add-In Outputters is discontinued.

- The DL Foundry configuration files are now stored only on the Oracle DataLens Administration Server in the Data Repository. These files are stored in C:\SilverCreek\Server\data\shared\common\config (formerly in C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\silvercreek\config). This is a general 5.0.2 server change to the way all Add-In functions are used on the server.
The configuration file has changed from AddInOutputParameters.xml to AddInTransformParameters.xml.

- The DL Foundry library has changed from Custom.jar to Addin.jar.
The requirement to move the DTD files into the XML pipeline directory has been removed.

- The following parameters have been removed from the Dimension Delete, Property Delete, Precedent Discover, and Precedent Delete:

- Server Name

- Server Port

- DSA name

- DL Standardization

Copyright © 2001, 2013, Oracle and/or its affiliates. All rights reserved.