Oracle® Enterprise Data Quality Experian QAS Integration Guide

Release 11g R1 (11.1.1.7)

E40053-02

Oracle® Enterprise Data Quality

Experian QAS Integration Guide

Release 11g R1 (11.1.1.7)

E40053-02

October 2013

Oracle Enterprise Data Quality (EDQ) includes a connector to the Experian QAS Batch API (formerly Quick Address Batch API). These notes describe how to integrate EDQ with this API. They also contain instructions for migrating earlier versions of the QAS integration to EDQ versions 8.1.3 or later.

1 Prerequisites

You must have an installed version of the Experian QAS Batch API software appropriate for your platform.

2 Integrating QAS with EDQ

Integration of EDQ with Experian QAS Batch is carried out by editing the qas.properties file distributed with EDQ. The qas.properties file is located in the qas subdirectory of your EDQ local home directory.

Once both EDQ and the QAS Batch software have been installed, edit the properties in the qas.properties as required for your integration. The properties specified in the file are as follows:

Property name

Description

Default Value

qas.install.path

The location of the Experian QAS Batch installation.

C:\Program Files (x86)\QAS\QAS Batch API

qas.qaworld.ini

The path to the QAWorld.ini file to use. This allows you to create and edit copies of the original QAWorld.ini file distributed with Experian QAS Batch API. If no value is specified for this property, it uses the QAWorld.ini file within the Experian QAS Batch API installation.

None

max.number.connections

The maximum number of connections that EDQ will create to the API. This should not be set to a value greater than 32.

Note: There is a known threading and memory issue with Experian QAS Batch API versions 6.85, 6.89 and 6.95, where if maximum usage of 32 instances and 8 threads is reached, the Batch API may crash. This can be avoided by setting this property to a value between 18 and 22 inclusive.

32

connection.pool.timeout

This property specifies the number of milliseconds that a connection can be idle for before it will be closed by the pool management functionality. If this is set to -1, idle connections will not be closed.

60,000

connection.pool. timer.interval

This property specifies how often, in milliseconds, the connection pool will be scanned for idle connections.

60,000

default.layout

The default layout to use. If no layout with the specified name is available in the specified QAWorld.ini file, this property will be ignored.

GBR

3 Migrating QAS integrations

Some earlier versions of EDQ (versions prior to 8.1.3) were shipped with a customized version of QAWorld.ini that was used instead of the version contained within Experian QAS. It is not possible to migrate automatically from these versions of the Experian QAS integration to the later versions. To migrate an earlier Experian QAS integration, you must:

- Locate the local copy of QAWorld.ini and copy any custom layouts specified in this file into the version of QAWorld.ini contained within Experian QAS.

- Update the settings in qas.properties (see Chapter , "Integrating QAS with EDQ").

In addition, any existing processes and results books that make use of QAS processors must be updated as follows:

- Open each configured QAS processor and rename the output attributes to match those in the new QAWorld.ini file.

- Open any results books built on results grids from QAS processors and re-map the fields to the new output attribute names.

Refer to the following table for the affected releases for each version of EDQ. All versions of EDQ (previously known as dn:Director) prior to 7.2 are affected:

Version

Releases affected

EDQ (dn:Director) 7.2

Release 7.2.9 and all earlier 7.2 releases

EDQ (dn:Director) 8.0

Release 8.0.21 and all earlier 8.0 releases

EDQ (dn:Director) 8.1

Release 8.1.2 and all earlier 8.1 releases

4 Related Documents

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

- Oracle Enterprise Data Quality Installation Guide

See the latest version of this and all documents in the Oracle Enterprise Data Quality Documentation website at:

http://download.oracle.com/docs/cd/E48549_01/index.htm

Also, see the latest version of the EDQ Online Help, bundled with EDQ.

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

Oracle Enterprise Data Quality Experian QAS Integration Guide, Release 11g R1 (11.1.1.7)

E40053-02

Copyright © 2006, 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 failsafe, 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.

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