Cleanse Adapter Guide - Informatica

1 MDM Multidomain Edition (Version ) Cleanse Adapter GuideMDM Multidomain Edition Cleanse Adapter GuideVersion 2011 Copyright (c) 2001-2011 . All rights software and documentation contain proprietary information of Informatica Corporation and are provided under a license agreement containing restrictions on use anddisclosure and are also protected by copyright law. Reverse engineering of the software is part of this document may be reproduced or transmitted in any form, by any means (electronic, photocopying, recording or otherwise) without prior consent of InformaticaCorporation. This Software is be protected by and/or international Patents and other Patents , duplication, or disclosure of the Software by the Government is subject to the restrictions set forth in the applicable software license agreement and as provided inDFARS (a) and (a) (1995), DFARS (1)(ii) (OCT 1988), FAR (a) (1995), FAR , or FAR (ALT III), as information in this product or documentation is subject to change without notice.

2 If you find any problems in this product or documentation, please report them to us , Informatica Platform, Informatica Data Services, PowerCenter, PowerCenterRT, PowerCenter Connect, PowerCenter Data Analyzer, PowerExchange,PowerMart, Metadata Manager, Informatica Data Quality, Informatica Data Explorer, Informatica B2B Data Transformation, Informatica B2B Data Exchange, Informatica OnDemand and Siperian are trademarks or registered trademarks of Informatica Corporation in the United States and in jurisdictions throughout the world. All other company andproduct names may be trade names or trademarks of their respective of this software and/or documentation are subject to copyright held by third parties, including without limitation: Copyright DataDirect Technologies.

3 All rightsreserved. Copyright Sun Microsystems. All rights product includes software developed by the Apache Software Foundation ( ), and other software which is licensed under the Apache License,Version (the License ). You may obtain a copy of the License at Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an AS IS BASIS, WITHOUT WARRANTIESOR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the product includes software which is licensed under the GNU Lesser General Public License Agreement, which may be found at Thematerials are provided free of charge by Informatica , as-is , without warranty of any kind, either express or implied, including but not limited to the implied warranties ofmerchantability and fitness for a particular product includes software which is licensed under the CDDL (the License ).

4 You may obtain a copy of the License at The materialsare provided free of charge by Informatica , as-is , without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantabilityand fitness for a particular purpose. See the License for the specific language governing permissions and limitations under the product includes software which is licensed under the BSD License (the License ). You may obtain a copy of the License at The materials are provided free of charge by Informatica , as-is , without warranty of any kind, either express or implied, including but not limited to the impliedwarranties of merchantability and fitness for a particular purpose.

5 See the License for the specific language governing permissions and limitations under the product includes software Copyright (c) 2003-2008, Terence Parr, all rights reserved which is licensed under the BSD License (the License ). You may obtain a copy ofthe License at The materials are provided free of charge by Informatica , as-is , without warranty of any kind, either express or implied,including but not limited to the implied warranties of merchantability and fitness for a particular purpose. See the License for the specific language governing permissions andlimitations under the product includes software Copyright (c) 2000 - 2009 The Legion Of The Bouncy Castle ( ) which is licensed under a form of the MIT License(the License ).

6 You may obtain a copy of the License at The materials are provided free of charge by Informatica , as-is , withoutwarranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. See the License forthe specific language governing permissions and limitations under the : Informatica Corporation provides this documentation as is without warranty of any kind, either express or implied, including, but not limited to, the impliedwarranties of non-infringement, merchantability, or use for a particular purpose. Informatica Corporation does not warrant that this software or documentation is error free.

7 Theinformation provided in this software or documentation may include technical inaccuracies or typographical errors. The information in this software and documentation issubject to change at any time without Informatica product (the Software ) may include certain drivers (the DataDirect Drivers ) from DataDirect Technologies, an operating company of Progress SoftwareCorporation ( DataDirect ) which are subject to the following terms and DATADIRECT DRIVERS ARE PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUTNOTLIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NO EVENT WILL DATADIRECT OR ITS THIRD PARTY SUPPLIERS BE LIABLE TO THE END-USER CUSTOMER FOR ANY DIRECT, INDIRECT,INCIDENTAL, SPECIAL, CONSEQUENTIAL OR OTHER DAMAGES ARISING OUT OF THE USE OF THE ODBC DRIVERS, WHETHER OR NOT INFORMED OFTHE POSSIBILITIES OF DAMAGES IN ADVANCE.

8 THESE LIMITATIONS APPLY TO ALL CAUSES OF ACTION, INCLUDING, WITHOUT LIMITATION, BREACHOF CONTRACT, BREACH OF WARRANTY, NEGLIGENCE, STRICT LIABILITY, MISREPRESENTATION AND OTHER Number: MDM-CAG-91000-0002 Table of ContentsPreface .. ivLearning About Informatica MDM ivInformatica viInformatica Customer viInformatica viInformatica Web viInformatica How-To viInformatica Knowledge viInformatica Multimedia Knowledge viInformatica Global Customer viiChapter 1: 1 Supported Cleanse 1 Chapter 2: Informatica IDQ Cleanse 3 Informatica IDQ Cleanse Engine 3 Prerequisites for Data 3 Process 4 Run-time 5 Adding an IDQ Library in the Cleanse Functions 5 Configuring Generated 8 Enabling a Generated 8 Properties File 8 Example Properties 8 Editing a Generated Properties 9 Chapter 3.

9 AddressDoctor Cleanse 12 AddressDoctor Cleanse Engine 12 Configuring the AddressDoctor Cleanse 12 Obtaining the Required 13 Editing the Properties 13 Upgrading the AddressDoctor Cleanse 15 Obtaining the Required 15 Editing the Properties 15 Replacing AddressDoctor 4 Library with AddressDoctor 5 16 Configuring the JVM 16 Table of Contents iSetting the JVM Size for WebSphere on 16 Chapter 4: FirstLogic Direct Cleanse 18 FirstLogic Direct Cleanse Engine 18 About FirstLogic Direct 18 Installing the 19 Configuring FirstLogic 19 Configuring Informatica MDM Hub to Use the 20 Using Your FirstLogic Direct 20 About Transactional 20 About the Transactional Mode 21 Chapter 5.

10 Trillium Director Cleanse 22 Trillium Director Cleanse Engine 22 About Trillium Director 22 Before You 23 Configuring Trillium Director 7 and the Cleanse Match 23 Configuring Trillium Director 11 and later and Cleanse Match Server on 25 Testing Your Trillium Director 27 About the Default Configuration 27 Using Your Trillium Director Projects with the 29 Upgrading Trillium 29 Using Trillium on a Remote 30 Configuring Trillium Director for 30 Setting the Threading 30 Increasing the Number of Network Connection 31 Chapter 6: SAP Data Services XI Cleanse 32 SAP Data Services XI Cleanse Engine 32 About SAP Data Services XI 32 Process 33 Run-time 34 Adding an SAP Library in the Cleanse Functions 34 Configuring Generated 36 Enabling a Generated 37 Properties File 37 Example Properties 37 Editing a Generated Properties 38 Chapter 7: 42 AddressDoctor Initialization 42ii Table of ContentsCleanse Engine Initialization 42 Trillium 43 Initialization Fails for MDM 43 Remote Initialization 43 Trillium Director 43 About Trillium Director Working 44 Setting the Work File 44 Index.