1 0 . 2 H O T F I X 2 I N F O R M A T I C A

Transcription

Informatica 10.2 HotFix 2Application Service Guide

Informatica Application Service Guide10.2 HotFix 2April 2019 Copyright Informatica LLC 2014, 2019This software and documentation are provided only under a separate license agreement containing restrictions on use and disclosure. No part of this document may bereproduced or transmitted in any form, by any means (electronic, photocopying, recording or otherwise) without prior consent of Informatica LLC.Informatica, the Informatica logo, PowerCenter, and PowerExchange are trademarks or registered trademarks of Informatica LLC in the United States and manyjurisdictions throughout the world. A current list of Informatica trademarks is available on the web at https://www.informatica.com/trademarks.html. Other companyand product names may be trade names or trademarks of their respective owners.U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercialcomputer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such,the use, duplication, disclosure, modification, and adaptation is subject to the restrictions and license terms set forth in the applicable Government contract, and, to theextent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License.Portions of this software and/or documentation are subject to copyright held by third parties. Required third party notices are included with the product.The information in this documentation is subject to change without notice. If you find any problems in this documentation, report them to us atinfa documentation@informatica.com.Informatica products are warranted according to the terms and conditions of the agreements under which they are provided. INFORMATICA PROVIDES THEINFORMATION IN THIS DOCUMENT "AS IS" WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING WITHOUT ANY WARRANTIES OFMERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND ANY WARRANTY OR CONDITION OF NON-INFRINGEMENT.Publication Date: 2019-04-18

Table of ContentsPreface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20Informatica Resources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20Informatica Network. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20Informatica Knowledge Base. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20Informatica Documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20Informatica Product Availability Matrixes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21Informatica Marketplace. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21Informatica Global Customer Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21Chapter 1: Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22Analyst Service Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22Analyst Service Architecture. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23Configuration Prerequisites. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24Services Associated with the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24Flat File Cache Directory. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24Export File Directory. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Attachments Directory. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Keystore File. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Exception Management Audit Database. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Recycle and Disable the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26Properties for the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 26General Properties for the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Model Repository Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27Logging Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Human Task Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Run-time Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28Metadata Manager Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Business Glossary Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Custom Properties for the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Custom Images in the Analyst Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29Process Properties for the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30Node Properties for the Analyst Service Process. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30Analyst Security Options for the Analyst Service Process. . . . . . . . . . . . . . . . . . . . . . . . . 30Advanced Properties for the Analyst Service Process. . . . . . . . . . . . . . . . . . . . . . . . . . . . 31Custom Properties for the Analyst Service Process. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31Environment Variables for the Analyst Service Process. . . . . . . . . . . . . . . . . . . . . . . . . . 32Creating and Configuring the Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32Creating an Analyst Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33Table of Contents3

Chapter 2: Content Management Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Content Management Service Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34Master Content Management Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35Content Management Service Architecture. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35Probabilistic Models and Classifier Models. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36Reference Data Warehouse. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37Orphaned Reference Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37Deleting Orphaned Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38Recycling and Disabling the Content Management Service. . . . . . . . . . . . . . . . . . . . . . . . . . . 38Content Management Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39General Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39Multi-Service Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40Associated Services and Reference Data Location Properties. . . . . . . . . . . . . . . . . . . . . . 40File Transfer Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Logging Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41Custom Properties for the Content Management Service. . . . . . . . . . . . . . . . . . . . . . . . . 41Content Management Service Process Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42Content Management Service Security Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42Address Validation Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43Identity Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46Advanced Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46NLP Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47Custom Properties for the Content Management Service Process. . . . . . . . . . . . . . . . . . . . 47Creating a Content Management Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47Chapter 3: Data Integration Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Data Integration Service Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49Before You Create the Data Integration Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Create Required Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Create Connections to the Databases. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 50Create the Service Principal Name and Keytab File. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Create Associated Services. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Creating a Data Integration Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51Data Integration Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54General Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54Model Repository Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55Execution Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56Logical Data Object/Virtual Table Cache Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59Logging Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Pass-through Security Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61HTTP Proxy Server Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 614Table of Contents

HTTP Configuration Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 62Result Set Cache Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Mapping Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Profiling Warehouse Database Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63Advanced Profiling Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 64SQL Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65Workflow Orchestration Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Web Service Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66Custom Properties for the Data Integration Service. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Data Integration Service Process Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67Data Integration Service Security Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68HTTP Configuration Properties . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68Result Set Cache Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69Advanced Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69Logging Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70SQL Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Custom Properties for the Data Integration Service Process. . . . . . . . . . . . . . . . . . . . . . . 70Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Data Integration Service Compute Properties. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70Execution Options. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71Environment Variables. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72Operating System Profiles for the Data Integration Service. . . . . . . . . . . . . . . . . . . . . . . . . . . 72Operating System Profile Components. . . . . . . . . . . . . . . . . . . . . . .

Informatica Global Customer Support. 21 C h a p t e r 1 : A n a l y s t S e r v i c e . 22 Analyst Service Overview. 22 Analyst Service Architecture. 23 Configuration Prerequisites. 24 Services Associated with the Analyst Service. 24 Flat File Cache Directory. 24 Export File Directory. 25 Attachments Directory. 25 Keystore File. 25 Exception Management .