Informatica (Version 9.1.0) Administrator Getting Started Guide Informatica ... The information in this product or docum...
Informatica (Version 9.1.0)
Administrator Getting Started Guide
Informatica Administrator Getting Started Guide Version 9.1.0 March 2011 Copyright (c) 1998-2011 Informatica. All rights reserved. This software and documentation contain proprietary information of Informatica Corporation and are provided under a license agreement containing restrictions on use and disclosure and are also protected by copyright law. Reverse engineering of the software is prohibited. No part of this document may be reproduced or transmitted in any form, by any means (electronic, photocopying, recording or otherwise) w ithout prior consent of Informatica Corporation. This Software may be protected by U.S. and/or international Patents and other Patents Pending. Use, duplication, or disclosure of the Software by the U.S. Government is subject to the restrictions set forth in the applicable software license agreement and as provided in DFARS 227.7202-1(a) and 227.7702-3(a) (1995), DFARS 252.227-7013 ©(1)(ii) (OCT 1988), FAR 12.212(a) (1995), FAR 52.227-19, or FAR 52.227-14 (ALT III), as applicable. The information in this product or documentation is subject to change without notice. If you find any problems in this product or documentation, please report them to us in writing. Informatica, 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 On Demand, Informatica Identity Resolution, Informatica Application Information Lifecycle Management, Informatica Complex Event Processing, Ultra Messaging and Informatica Master Data Management are trademarks or registered trademarks of Informatica Corporation in the United States and in jurisdictions throughout the world. All other company and product names may be trade names or trademarks of their respective owners. Portions of this software and/or documentation are subject to copyright held by third parties, including without limitation: Copyright DataDirect Technologies. All rights reserved. Copyright © Sun Microsystems. All rights reserved. Copyright © RSA Security Inc. All Rights Reserved. Copyright © Ordinal Technology Corp. All rights reserved.Copyright © Aandacht c.v. All rights reserved. Copyright Genivia, Inc. All rights reserved. Copyright 2007 Isomorphic Software. All rights reserved. Copyright © Meta Integration Technology, Inc. All rights reserved. Copyright © Oracle. All rights reserved. Copyright © Adobe Systems Incorporated. All rights reserved. Copyright © DataArt, Inc. All rights reserved. Copyright © ComponentSource. All rights reserved. Copyright © Microsoft Corporation. All rights reserved. Copyright © Rogue Wave Software, Inc. All rights reserved. Copyright © Teradata Corporation. All rights reserved. Copyright © Yahoo! Inc. All rights reserved. Copyright © Glyph & Cog, LLC. All rights reserved. Copyright © Thinkmap, Inc. All rights reserved. Copyright © Clearpace Software Limited. All rights reserved. Copyright © Information Builders, Inc. All rights reserved. Copyright © OSS Nokalva, Inc. All rights reserved. Copyright Edifecs, Inc. All rights reserved. This product includes software developed by the Apache Software Foundation (http://www.apache.org/), and other software which is licensed under the Apache License, Version 2.0 (the "License"). You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0. Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License. This product includes software which was developed by Mozilla (http://www.mozilla.org/), software copyright The JBoss Group, LLC, all rights reserved; software copyright © 1999-2006 by Bruno Lowagie and Paulo Soares and other software which is licensed under the GNU Lesser General Public License Agreement, which may be found at http:// www.gnu.org/licenses/lgpl.html. 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. The product includes ACE(TM) and TAO(TM) software copyrighted by Douglas C. Schmidt and his research group at Washington University, University of California, Irvine, and Vanderbilt University, Copyright ( ©) 1993-2006, all rights reserved. This product includes software developed by the OpenSSL Project for use in the OpenSSL Toolkit (copyright The OpenSSL Project. All Rights Reserved) and redistribution of this software is subject to terms available at http://www.openssl.org. This product includes Curl software which is Copyright 1996-2007, Daniel Stenberg, . All Rights Reserved. Permissions and limitations regarding this software are subject to terms available at http://curl.haxx.se/docs/copyright.html. Permission to use, copy, modify, and distribute this software for any purpose with or without fee is hereby granted, provided that the above copyright notice and this permission notice appear in all copies. The product includes software copyright 2001-2005 ( ©) MetaStuff, Ltd. All Rights Reserved. Permissions and limitations regarding this software are subject to terms available at http://www.dom4j.org/ license.html. The product includes software copyright © 2004-2007, The Dojo Foundation. All Rights Reserved. Permissions and limitations regarding this software are subject to terms available at http:// svn.dojotoolkit.org/dojo/trunk/LICENSE. This product includes ICU software which is copyright International Business Machines Corporation and others. All rights reserved. Permissions and limitations regarding this software are subject to terms available at http://source.icu-project.org/repos/icu/icu/trunk/license.html. http://source.icu-project.org/repos/icu/icu/trunk/license.html. This product includes software copyright © 1996-2006 Per Bothner. All rights reserved. Your right to use such materials is set forth in the license which may be found at http:// www.gnu.org/software/ kawa/Software-License.html. This product includes OSSP UUID software which is Copyright © 2002 Ralf S. Engelschall, Copyright © 2002 The OSSP Project Copyright © 2002 Cable & Wireless Deutschland. Permissions and limitations regarding this software are subject to terms available at http://www.opensource.org/licenses/mithttp://www.opensource.org/licenses/mit-license.php. license.php. This product includes software developed by B oost (http://www.boost.org/) or under the Boost software license. Permissions and limitations regarding this software are subject to terms available at http:/ /www.boost.org/LICENSE_1_0.txt. This product includes software copyright www.pcre.org/license.txt.
©
1997-2007 University of Cambridge. Permissions and limitations regarding this software are subject to terms available at http://
This product includes software copyright © 2007 The Eclipse Foundation. All Rights Reserved. Permissions and limitations regarding this software are subject to terms available at http:// www.eclipse.org/org/documents/epl-v10.p www.eclipse.org/org/documents/epl-v10.php. hp. This product includes software li censed under the terms at http://www.tcl.tk/software/tcltk/license.html, http://www.bosrup.com/web/overlib/?License, http://www.bosrup.com/web/overlib/?License, http://www.stlport.org/doc/ license.html, http://www.asm.ow2.org/license.html, http://www.cryptix.org/LICENSE.TXT, http://hsqldb.org/web/hsqlLicense.html, http://httpunit.sourceforge.net/doc/ license.html, http://jung.sourceforge.net/license.txt , http://www.gzip.org/zlib/zlib_license.html, http://www.openldap.org/software/release/license.html, http://www.openldap.org/software/release/license.html, http://www.libssh2.org, http://slf4j.org/license.html, http://www.sente.ch/software/OpenSourceLicen http://www.sente.ch/software/OpenSourceLicense.html, se.html, http://fusesource.com/downloads/licensehttp://fusesource.com/downloads/license-agreements/fuse-message-broke agreements/fuse-message-broker-v-5-3-licenser-v-5-3-licenseagreement, http://antlr.org/license.html, http://aopalliance.sourceforge.net/, http://www.bouncycastle.org/licence.html, http://www.jgraph.com/jgraphdownload.html, http:// www.jgraph.com/jgraphdownload.html, http://www.jcraft.com/jsch/LICENSE.txt and http://jotm.objectweb.org/bsd_license.htm http://jotm.objectweb.org/bsd_license.html. l. This product includes software licensed under the Academic Free License (http://www.opensource.org/licenses/afl-3.0.php), the Common Development and Distribution License (http://www.opensource.org/licenses/cddl1.php) (http://www.opensource.org/licenses/cddl1.php) the Common Public License (http://www.opensource.org/licenses/cpl1.0.php) (http://www.opensource.org/licenses/cpl1.0.php) and the BSD License (http:// www.opensource.org/licenses/bsd-license.php). This product includes software copyright © 2003-2006 Joe WaInes, 2006-2007 XStream Committers. All rights reserved. Permissions and limitations regarding this software are subject to terms available at http://xstream.codehaus.org/license http://xstream.codehaus.org/license.html. .html. This product includes software developed by the Indiana University Extreme! Lab. For further information please visit http://www.extreme.indiana.edu/.
This Software is protected by U.S. Patent Numbers 5,794,246; 6,014,670; 6,016,501; 6,029,178; 6,032,158; 6,035,307; 6,044,374; 6,092,086; 6,208,990; 6,339,775; 6,640,226; 6,789,096; 6,820,077; 6,823,373; 6,850,947; 6,895,471; 7,117,215; 7,162,643; 7,254,590; 7,281,001; 7,421,458; 7,496,588; 7,523,121; 7,584,422; 7,720,842; 7,721,270; and 7,774,791, international Patents and other Patents P ending. DISCLAIMER: Informatica Corporation provides this documentation "as is" without warranty of any kind, either express or implied, including, but not limited to, the implied warranties of non-infringement, merchantability, or use for a particular purpose. Informatica Corporation does not warrant that this software or documentation is error free. The information provided in this software or documentation may include technical inaccuracies or typographical errors. The information in this software and documentation is subject to change at any time without notice. NOTICES This Informatica product (the “Software”) includes certain drivers (the “DataDirect Drivers”) from DataDirect Technologies, an operating company of Progress Software Corporation (“DataDirect”) which are subject to the following terms and conditions: 1. THE DATADIRECT DRIVERS ARE PROVIDED “AS IS” WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PUR POSE AND NON-INFRINGEMENT. 2. IN 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 OF THE POSSIBILITIES OF DAMAGES IN ADVANCE. THESE LIMITATIONS APPLY TO ALL CAUSES OF ACTION, INCLUDING, WITHOUT LIMITATION, BREACH OF CONTRACT, BREACH OF WARRANTY, NEGLIGENCE, STRICT LIABILITY, MISREPRESENTATION AND OTHER TORTS. Part Number: IN-AGS-91000-0001
Table of Contents
Pref Pr efac acee . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . i i i Informatica Re Resources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii Informatic Informatica Customer Portal. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii Informatic Informatica Documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii Informatic Informatica Web Site. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii Informatic Informatica How-To Library. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iiiii Informatic Informatica Knowledge Base . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iv Informatic Informatica Mult imedia Knowledge Base . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iv Informatic Informatica Global Customer Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iv
Chapter 1: Getting Started Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Introducing Inf Informatica Administrator . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 Informatica Do Domain Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1
Chapter 2: Les essson 1. Acc cces essi sing ng Infor orm mat atiica Adm dmiini nist strrator or.. . . . . . . . . . . . . . . . . . . . . . . . . . 4 Accessing Informat Informatica Administrator Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4 Task 1. Record Dom Domain, Us User, Da Database, an and Ap Application Se Service In Information . . . . . . . . . . . . . . . . . . 5 Informatica Do Domain Information. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Informatica Ad Administrator User Account . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 Database Conn Connections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6 Data Integ Integration Service Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Analyst Se Service Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9 Task 2. Log In to Informatica Administrator. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Task 3. Chang Change Your Password . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Accessing Inf ormatica Administrator Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10
Chapter 3: Lesson 2. Creating Application Services.. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Creating Appli Application Services Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11 Task 1. Create a Mo Model Repository Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12 Task 2. Create Dat Da tabase Co Connect ions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13 Task 3. Create a Da Data Integration Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16 Task 4. Create an Analyst Se Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Creating Application Application Services Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18
Chapter 4: Less Les son 3. 3. Setting Up Up In Informatica Us Users . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 19 Setting Up Inf ormatica Users Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Task 1. Create Create a User. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Task 2. Grant Privileges. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20
Table of Contents
i
Setting Up Informatica Users Summary. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21
Chap aptter 5: 5: Les Lessson 4. Mon oniitor oriing Jo Job bs and and Ap Appl pliica cattion ons. s. . . . . . . . . . . . . . . . . . . . . . . . . . . 22 Monitoring Jobs and Applications Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 22 22 Task 1. View Profile and Scorecard Jobs. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 Task 2. View Connections to an SQL Data Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 23 23 Task 3. View Requests for an SQL Data Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 24 Task 4. View Requests for a Web Service . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 24 Monitoring Jobs and Applications Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24 24
A p p e n d i x A : F r e q u e n t l y A s k e d Q u e s t i o n s . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Informatica Ad Administrator Fr Frequently Asked Qu Questions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 25
ii
Table of Contents
Preface The Informatica Administrator Getting Started Guide is written for administrators who are responsible for administering the Informatica domain. It provides a tutorial to help first-time users learn how to use Informatica Administrator.
Informatica Resources Informatica Customer Portal As an Informatica customer, you can access the Informatica Customer Portal site at http://mysupport.informatica.com. http://mysupport.informati ca.com. The site contains product information, user group information, newsletters, access to the Informatica customer support case management system (ATLAS), the Informatica How-To Library, the Informatica Knowledge Base, the Informatica Multimedia Knowledge Base, Informatica Product Documentation, and access to the Informatica user community.
Informatica Documentation The Informatica Informatica Documentation team takes every every effort to create accurate, usable documentation. If you have questions, comments, or ideas about this documentation, contact the Informatica Documentation team through email at
[email protected].
[email protected]. We will use your feedback t o improve our documentation. Let us know if we can contact you regarding your comments. The Documentation team updates documentation as needed. To get the latest documentation for your product, navigate to Product Documentation from http://mysupport.informatica.com. http://mysupport.informatica.com.
Informatica Web Site You can access the Informatica corporate web site at http://www.informatica.com. The site contains information about Informatica, its background, upcoming events, and sales offices. You will also find product and partner information. The services area of the site includes important information about technical support, training and education, and implementation services.
Informatica How-To Library As an Informatica customer, you can access the Informatica How-To Library at http://mysupport.informatica.com. The How-To Library is a collection of resources to help you learn more about Informatica products and features. It includes articles and interactive demonstrations that provide solutions to common problems, compare features and behaviors, and guide you through performing specific real-world tasks.
iii
Informatica Knowledge Base As an Informatica customer, you can access the Informatica Knowledge Base at http://mysupport.informatica.com. Use the Knowledge Base to search for documented solutions to known technical issues about Informatica products. You can also find answers to frequently asked questions, technical white papers, and technical tips. If you have questions, comments, or ideas about the Knowledge Base, contact the Informatica Knowledge Base team through email at
[email protected].
Informatica Multimedia Knowledge Base As an Informatica customer, you can access the Informatica Multimedia Knowledge Base at http://mysupport.informatica.com. http://mysupport.informati ca.com. The Multimedia Knowledge Base is a collection of instructional multimedia files that help you learn about common concepts and guide you through performing specific tasks. If you have questions, comments, or ideas about the Multimedia Knowledge Base, contact the Informatica Knowledge Base team through email at
[email protected].
[email protected].
Informatica Global Customer Support You can contact a Customer Support Center by telephone or through the Online Support. Online Support requires a user name and password. You can request a user name and password at http://mysupport.informatica.com. Use the following telephone numbers to contact Informatica Global Customer Support:
N o r t h A m e r i c a / S o u th A me r i c a
E ur o pe / M i d d l e E a s t / A fr i c a
Toll Free Brazil: 0800 891 0202 Mexico: 001 888 209 8853 North America: +1 877 463 2435
Toll Free France: 00800 4632 4357 Germany: 00800 4632 4357 Israel: 00800 4632 4357 Italy: 800 915 985 Netherlands: 00800 4632 4357 Portugal: 800 208 360 Spain: 900 813 166 Switzerland: 00800 4632 4357 or 0800 463 200 United Kingdom: 00800 4632 4357 or 0800 023 4632
Standard Rate North America: +1 650 653 6332
Standard Rate France: 0805 804632 Germany: 01805 702702 Netherlands: 030 6022 797
iv
Preface
Asi a / Austra lia Toll Free Australia: 1 800 151 830 New Zealand: 1 800 151 830 Singapore: 001 800 4632 4357
Standard Rate India: +91 80 4112 5738
CHAPTER 1
Getting Started Overview This chapter includes the following topics: ¨
Introducing Informatica Administrator, 1
¨
Informatica Domain Overview, 1
Introducing Informatica Administrator Informatica Administrator (Administrator (Administrator tool) is the administration tool you use to administer the Informatica domain and Informatica security. You can use the Administrator tool to perform the following tasks: ¨
Domain administrative tasks. Manage logs, domain objects, and domain reports. Domain objects include application services, nodes, grids, folders, database connections, applications, and licenses.
¨
Security administrative tasks. Manage users, groups, roles, privileges, and permissions.
Informatica Domain Overview Informatica has a service-oriented architecture that provides the ability to scale services and to share resources across multiple machines. The Informatica domain is the primary unit for management and administration of services. Informatica contains the following components: ¨
Application clients. A group of clients that you use to access underlying Informatica functionality. Application clients make r equests equests to the Service Manager Manager or application services.
¨
Application services. services. A group of services that represent repre sent server-based functionality. An Informatica domain can contain a subset of application services. You configure the application services that are required by the application clients that you use.
¨
Repositories. A group of relational databases that store metadata about objects and processes required to handle user requests from application clients.
¨
Service Manager. A service that is built in to the domain to manage all domain operations. The Service Manager runs the application services and performs domain functions including authentication, authorization, and logging.
1
You can log in to Informatica Administrator (the Administrator tool) after you install Informatica. You use the Administrator tool to manage the domain and configure the required application services before you can access the remaining application clients. The following figure shows the application services and the repositories that each application client uses in an Informatica domain:
The following table lists the application clients, not including the Administrator tool, and the application services and the repositories that the client requires:
2
A p pl i c a ti o n C l i e nt
A pp l i c a t i on S e r v i c e s
R e p os i t o r i e s
Data A nalyzer
Re p o r t i n g S e r v i c e
Dat a Ana lyzer reposi tory
Informat ica Ana lyst
-
Anal yst S ervi ce Data Data Inte Integr grat atio ionn Ser Servi vice ce Mode Modell Repo Reposi sito tory ry Serv Servic icee
Model repository
Informat ica Develop er
-
Anal yst S ervi ce Cont Conten entt Mana Manage geme ment nt Ser Servi vice ce Data Data Inte Integr grat atio ionn Ser Servi vice ce Mode Modell Repo Reposi sito tory ry Serv Servic icee
Model repository
Metad ata Ma nager
-
Metad ata Man ager Service Powe PowerC rCen ente terr Inte Integr grat ation ion Servi Service ce Powe PowerC rCen ente terr Repo Reposi sito tory ry Servi Service ce
-
Chapter 1: Getting Started Overview
Meta Metadat dataa Manag Manager er repo reposi sito tory ry Powe PowerC rCen ente terr rep repos osit itor oryy
A p pl i c a ti o n C l i e nt
A pp l i c a t i on S e r v i c e s
R e p os i t o r i e s
PowerCente r Cl ien t
-
PowerCenter In tegrati on Se rvice Powe PowerC rCen ente terr Repo Reposi sito tory ry Servi Service ce
PowerCenter repository
Web Servi ces Hub Co nso le
-
PowerCenter In tegrati on Se rvice Powe PowerC rCen ente terr Repo Reposi sito tory ry Servi Service ce Web Se Servi ce ces Hu Hub
PowerCenter repository
The following application services are not accessed by an Informatica application client: ¨
PowerExchange Listener Service. Manages the PowerExchange Listener for bulk data movement and change data capture. The PowerCenter Integration Service connects to the PowerExchange Listener through the Listener Service.
¨
PowerExchange Logger Service. Manages the PowerExchange Logger for Linux, UNIX, and Windows to capture change data and write it to the PowerExchange Logger Log files. Change data can originate from DB2 recovery logs, Oracle redo logs, a Microsoft SQL Server distribution database, or data sources on an i5/OS or z/OS system.
¨
SAP BW Service. Listens for RFC requests from SAP BI and requests that the PowerCenter Integration Service run workflows to extract from or load to SAP BI.
Informatica Domain Overview
3
CHAPTER 2
Lesson 1. Accessing Informatica Administrator This chapter includes the following topics: ¨
Accessing Informatica Administrator Overview, 4
¨
Task 1. Record Domain, User, Database, and Application Service Information, 5
¨
Task 2. Log In to Informatica Administrator, 10
¨
Task 3. Change Your Password, 10
¨
Accessing Informatica Administrator Summary, 10
Accessing Informatica Administrator Overview The Administrator tool consolidates the administrative tasks for domain objects such as services, nodes, licenses, and grids. You manage the domain and the security of the domain through the Administrator tool.
Objectives In this lesson, you complete the following tasks: ¨
Record the domain domain and the administrator user account infor mation. mation. The domain information provides address components of the Administrator tool URL, and the user account provides access to the Administrator tool.
¨
Log in to the Administrator tool. Lessons in this tutorial require that you can log in to the Administrator tool.
¨
Change the password of your user account.
Prerequisites Before you start this lesson, verify the following prerequisites: ¨
The Informatica domain is running.
¨
The administrator or user who installed Informatica has provided you with the domain connectivity information and an administrator user account.
Timing Set aside 10 to 15 minutes to complete this lesson.
4
Task 1. Record Domain, User, Database, and Application Service Information In this task, you record the domain connection, user account information, database connections, and application service information. You need this information to access the Administrator tool, and to create connections and application services.
Informatica Domain Information If you do not know the domain connectivity information, contact the person who installed Informatica. Use the following table to record domain information:
D o ma i n I nf o r m a ti o n
Va lues
Domain Name Gateway Node Host Name Informatica Administrator Port Number
Informatica Administrator User Account Use an administrator user account to log in to the Administrator tool to complete the lessons in this tutorial. The default administrator user name is Administrator. If you do not have the password for the default administrator, ask for the password or for a user account with the Administrator role. Use the following table to record the user account information:
A c c o u n t I n f o r m a t i on
Val ues
Administrator Username Administrator Password Security Domain
Task 1. Record Domain, User, Database, and Application Service Information
5
Database Connections Ask the database administrator to provide the database connection information each of the Model repository, profiling warehouse, and staging databases. You will use the database connection information when you create connections to the databases in another lesson. Use the following table to record the database connection information for the Model repository database, profiling warehouse database, and staging database:
Database Connection Information
D e s c r i pt i on
Database Type
The nam e of t he connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with the @ character. It also cannot contain spaces or the following special characters: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
6
Database User Name
The description of the connection. The description cannot exceed 765 characters.
Data Databa base se Pas Passw swor ordd
The The datab databas asee user user nam name. e.
C on on ne ne ct ct io io n S trtri ng ng
T he he pa pa ss ss wo wo rd rd fo fo r t he he database user name.
Metadata Access: Connection String
JDBC connection URL used to access metadata from the database. IB M DB2: jdbc:informatica:db2: //:;Datab aseName= Oracl e: jdbc:informatica:oracl e:// : ;SID= Mi crosoft S QL Server: jdbc:informatica:sqls erver://:;Datab aseName= Not applicable for ODBC.
Chapter 2: Lesson 1. Accessing Informatica Administrator
M od e l R e po s i t or y Values
Profiling Warehouse Database Values
Staging Database Values
Database Connection Information
D e s c r i pt i on
Data Access: Connection String
Connection string used to access data from the database. I BM BM D B2 B2 : < da da ta ta ba ba se se name> Mi crosoft S QL Server: @ O DB DB C: C: O ra ra cl cl e: e: < da da ta ta ba ba se se name>.world from the TNSNAMES entry.
Data Access: Code Page
Code page used to read from a source database or write to a target database or target file.
E nv nv irir on on me me nt nt SQ SQ L
S QL QL co co mm mm an an ds ds to to se se t t he he database environment when you connect to the database. The Data Integration Service runs the connection environment SQL each time it connects to the database.
Tr an an sa sa ct ct io io n S QL QL
S QL QL c om om ma ma nd nd s t o se t t he he database environment when you connect to the database. The Data Integration Service runs the transaction environment SQL at the beginning of each transaction.
Connection Retry Period
The number of seconds that the Data Integration Service tries to reconnect to the database if the connection fails. If the Data Integration Service cannot connect to the database in the retry period, the integration object fails. Default is 0.
Domai n Name
Mi crosoft S QL S erver on Windows. The name of the domain.
M od e l R e po s i t or y Values
Profiling Warehouse Database Values
Staging Database Values
Task 1. Record Domain, User, Database, and Application Service Information
7
8
Database Connection Information
D e s c r i pt i on
Packet Si ze
Mi crosoft S QL S erver. The packet sized used to transmit data. Used to optimize the native drivers for Microsoft SQL Server.
Owne r Nam e
Mi crosoft S QL S erver. The name of the owner of the schema.
Schema Na Nam e
Mi crosoft SQ SQL Se Server. The name of the schema in the database. You must specify the schema name for the Profiling Warehouse and staging database if the schema name is different than the database user name.
Enable Parallel Mode
Oracle. Enables parallel processing when loading data into a table in bulk mode. By default, this option is cleared.
Ta b l e s p a c e
IBM DB2. The tabl esp ace name of the database.
SQL Identifier Character
The type of quote character used for the Support Mixed Case Identifiers property. Select the quote character based on the database in the connection. The options are: DOUB LE_QUOTE SI NGLE_ QUOTE B A C K _ Q UO T E SQUARE_B RA RACKE T S Q UO T E _ E M P T Y
Support Mixed Case Identifiers
Enables the Developer tool and Analyst tool to place quotes around table, view, schema, synonym and column names when generating and executing SQL against these objects in the connection. Use if the
Chapter 2: Lesson 1. Accessing Informatica Administrator
M od e l R e po s i t or y Values
Profiling Warehouse Database Values
Staging Database Values
Database Connection Information
D e s c r i pt i on
M od e l R e po s i t or y Values
Profiling Warehouse Database Values
Staging Database Values
objects have mixed-case or lowercase names. Also, use if the object names contain SQL keywords, such as WHERE. By default, this option is cleared.
Data Integration Service Information Use this information to create the Data Integration Service. Use the following table to record the Data Integration Service information:
D a t a I n te g r a t i o n S e r v i c e I n f o r m a ti o n
D e s c r i pt i o n
H TT P P o r t
Uniq ue port n umber for th e Data Integration Service. Default is 8095.
Username
User na me to access th e Model Repository Service.
Password
User pa ssword to access the Model Repository Service.
Security Domai n
LDAP security do main for the Model repository user. The field appears when the Informatica domain contains an LDAP security domain.
Va lues
Analyst Service Information Use this information to create the Analyst Service. Use the following table to record the Analyst Service information:
A n a l y s t S e r v i c e I n f or m a t i o n
D e s c r i p ti o n
V alue s
H TT P P o r t
Po rt number for th e Ana lyst Service. Use a port number that is different from the HTTP port number for the Data Integration Service.
Username
The da tabase user name for the Model repository.
Task 1. Record Domain, User, Database, and Application Service Information
9
A n a l y s t S e r v i c e I n f or m a t i o n
D e s c r i p ti o n
Password
The da tabase passwo rd for the Model repository.
Security Domai n
LDAP se curi ty d omai n for the user who manages the Model Repository Service.
V alue s
Task 2. Log In to Informatica Administrator In this task, you log in to the Administrator tool. 1.
Start Microsoft Microsoft Internet Internet Explor Explorer er or or Mozilla Mozilla Firefox. Firefox.
2.
In the Address Address field, field, enter enter the the following following URL URL for the the Administ Administrator rator tool tool login login page: http://:/administrator
The host is the gateway node host name. The port is the Informatica Administrator port number. 3.
In the Informa Informatica tica Admini Administra strator tor login login page, enter enter the the user name name and passw password. ord.
4.
Select Native or the name of a specific security domain. The Security Domain field appears when the Informatica domain contains an LDAP security domain.
5.
Click Log In .
Task 3. Change Your Password In this task, you change your password for the Administrator tool. 1.
In the the Admini Administr strato atorr tool tool header header area area,, click click Manage > Change Password . The Change Password dialog box appears.
2.
In the Change Password dialog box, enter the current password in the Current Password box, and the new password in the New Password and Confirm New Password boxes.
3.
Click OK .
Accessing Informatica Administrator Summary In this lesson, you learned the components of the Administrator tool, how to log in to the Administrator tool, and how to change your password. You recorded the domain connectivity and administrator user account information. You also logged into the Administrator tool and changed your password. Use the administrator user account and new password to complete the next lessons in this tutorial.
10
Chapter 2: Lesson 1. Accessing Informatica Administrator
CHAPTER 3
Lesson 2. Creating Application Services This chapter includes the following topics: ¨
Creating Application Services Overview, 11
¨
Task 1. Create a Model Repository Service, 12
¨
Task 2. Create Database Connections, 13
¨
Task 3. Create a Data Integration Service, 16
¨
Task 4. Create an Analyst Service, 17
¨
Creating Application Services Summary, 18
Creating Application Services Overview Use the Administrator tool to create application services. Application services provide server-based functionality. Create the following application services for use with the Analyst tool: ¨
Model Repository Service. The Model Repository Service manages the Model repository. The Analyst tool, Data Integration Service, and Administrator tool store metadata in the Model repository.
¨
Data Integration Service. The Data Integration Service is an application service that performs data integration tasks for the Analyst tool and other external clients.
¨
Analyst Service. Service. The Analyst Service is an application service service that runs the Analyst tool. The Analyst Service manages the connections between service components components and the users who access the Analyst tool.
A database connection is a domain object that contains database connectivity information. The Data Integration Service connects to the database to process integration objects for the Analyst tool. Integration objects include mappings, profiles, and scorecards.
Story An administrator at HypoStores needs to create application services. An analyst needs a Model Repository Service, Data Integration Service, and Analyst Service to use the Analyst tool.
Objectives In this lesson, you complete the following tasks: ¨
Create a Model Repository Service to manage the Model repository.
11
¨
Create a Model repository to store metadata.
¨
Create database connections to the Model repository, profiling warehouse, and staging databases.
¨
Create a Data Integration Service to perform data integration tasks.
¨
Create an Analyst Service to run the Analyst tool.
Prerequisites Before you start this lesson, verify the following prerequisites: ¨
You have the database connection information for the Model repository, profiling warehouse, and staging database. You gathered this information in the first lesson.
¨
You have a license object in the domain. The Informatica installer installs a license object in the domain. You need a license object to create application services.
Timing Set aside 30 to 45minutes to complete this lesson.
Task 1. Create a Model Repository Service In this task, you create a Model Repository Service. The Model Repository Service manages the Model repository for Data Services and Data Quality. 1.
On the Domain tab of the Administrator tool, select the Services and Nodes view.
2.
On th th e Na vi vig at at or or Actions menu, click New > Model Repository Service . The New Model Repository Service - Step 1 of 2 dialog box appears.
3.
4.
Enter the the following following genera generall properties properties for the Model Model Reposit Repository ory Servic Service: e:
P roperty
D e s c r i p ti on
Name
Name of the Model Reposit ory S ervice. The name i s not case sensi ti ve and mu st b e unique within the domain. It cannot exceed 128 characters or begin with @. It also cannot contain spaces or the following special characters: `~%^*+={}\;:'"/?.,|!()][
Descri ptio n
Descrip tion of th e Mode l Repo si tory S ervi ce. Th e descri ptio n ca nnot e xceed 7 65 characters.
Lo cati on
The fo lder where you wa nt to cr create th the servi ce. IfIf a fo fold er is not sp specif ied , the domain name appears in this field.
Li ce nse
Li cen se t o assi gn to the M odel Reposito ry Service. S elect th e li cense instal le d wit h Informatica.
Node
Node to run th e Mode l Repo si tory S ervi ce. Sel ect an exi sti ng no de i n the domai n.
Click Next. The New Model Repository Service - Step 2 of 2 dialog box appears.
12
Chapter 3: Lesson 2. Creating Application Services
5.
Enter the the following following databa database se propertie properties s for the Model Model Reposi Repository tory Servic Service: e:
P roperty
De scr iption
Data base Type
Type of databa se.
Usern ame
The databa se u ser na me for th e Model reposit ory.
Pa ssword
A n encrypte d versio n of t he dat abase passwo rd for the Mo del re posi tory.
Conn ec ecti on on St String
The JD JDBC co conne ct ct st strin g used to to co conn ec ect to to th th e Mode l reposit or ory da da ta tabase. IBM DB2: DB2: jdbc: jdbc:in infor format matic ica: a:db db2:/ 2://< /:;DatabaseName= Oracle: Oracle: jdbc:informatic jdbc:informatica:orac a:oracle://;SID= Connection . The New Connection dialog box appears.
5.
6.
Select Select one one of the the follo followi wing ng conne connecti ction on types types:: ¨
DB2
¨
DB2 for i5/OS
¨
DB2 for z/OS
¨
ODBC
¨
ORACLE
¨
SQLSERVER
Click OK . The New Connection - Step 1 of 3 dialog box appears.
Task 2. Create Database Connections
13
7.
Enter the followin following g connectio connection n propertie properties s based based on the database database type: type:
P roperty
De scr iption
Name
The n ame of the conne cti on. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters or begin with the @ character. It also cannot contain spaces or the following special characters: ` ~ % ^ * + = { } \ ; : ' " / ? . , < > | ! ( ) ] [
8.
Descri ptio n
The d escripti on o f the conn ect ion. Th e descri ptio n cannot exceed 765 characters.
U s e r Na m e
The d atabase u ser nam e.
Pa ssword
The p assword for the datab ase use r n ame.
Click Next. The New Connection - Step 2 of 3 dialog box appears.
9.
10.
Enter the followin following g connectio connection n propertie properties s based based on the database database type: type:
P roperty
De scr iption
Met adata Access: Connectio n Stri ng
JDBC connecti on URL used to access metada ta from th e database. IBM DB2: DB2: jdbc jdbc:in :info form rmati atica ca:d :db2 b2:// :// Administration >
Required to access the Analyst tool.
Chapter 4: Lesson 3. Setting Up Informatica Users
P r i v i l e ge N a m e
L oc a t i o n
De scr iption
License Access for Informatica Analyst Create Projects
7.
- Model Repository Service > Model Repository Service Administration > Create Projects
Required to create projects in the Analyst tool.
Click OK .
Setting Up Informatica Users Summary In this lesson, you learned that users can perform tasks in Informatica application clients based on their privileges. You created a user and granted privileges.
Setting Up Informatica Users Summary
21
CHAPTER 5
Lesson 4. Monitoring Jobs and Applications This chapter includes the following topics: ¨
Monitoring Jobs and Applications Overview, 22
¨
Task 1. View Profile and Scorecard Jobs, 23
¨
Task 2. View Connections to an SQL Data Service, 23
¨
Task 3. View Requests for an SQL Data Service, 24
¨
Task 4. View Requests for a Web Service, 24
¨
Monitoring Jobs and Applications Summary, 24
Monitoring Jobs and Applications Overview Use the Monitoring tab to monitor jobs and applications that run on a Data Integration Service. The Data Integration Service runs jobs and applications. A job is a profile, scorecard, mapping, SQL data service, preview or reference table process that is running or has previously run. An application is an object that contains one or more SQL data services, mappings, or data objects. The Navigator displays a container for jobs and for each application that is deployed to the Data Integration Service. Under each e ach application is a container for SQL data services, services, deployed mappings, and data objects. When you view jobs j obs for a Data Integration Service, the contents panel panel displays information such as Job ID, State, and Elapsed Time. Time. An SQL data ser vice vice connection is a connection from an external external client. When you view connections to an SQL data service, the contents panel displays information such as the connection ID, state, and elapsed time. Each SQL data service connection can have multiple requests. When you view a request for an SQL data service, the contents panel displays information such as the request ID, state, and elapsed time.
Story An administrator at HypoStores wants to view the status of jobs and SQL data services running on a Data Integration Service.
22
Objective In this lesson, you complete the following tasks: ¨
View running and previously run jobs for a Data Integration Service to check for failures.
¨
View connections to an SQL data service to check for active and timed out connections.
¨
View requests for an SQL data service to view running requests.
Prerequisites Before you start this lesson, verify the following prerequisites: ¨
An analyst runs profile and scorecard jobs on the Data Integration Service in the domain.
¨
A developer runs a SQL data service on the Data Integration Service in the domain.
Timing Set aside 5 to 10 minutes to complete this lesson.
Task 1. View Profile and Scorecard Jobs In this task, you view jobs for profiles and scorecards that are running or that ran on the Data Integration Service. To see profile and scorecard jobs, the Data Integration Service must be running profiles or scorecards. Otherwise, you view information about previous job runs. 1.
In the the Admi Adminis nistra trator tor tool, tool, clic click k the the Monitoring tab.
2.
In the Naviga Navigator, tor, expand expand a Data Integration Integration Service Service and then then select select Jobs. The contents panel displays jobs for the selected Data Integration Service.
3.
Select Select a job job in in the the cont content ents s pane panel. l. The details panel displays details on each job you select in the contents panel.
Task 2. View Connections to an SQL Data Service In this task, you use the Monitoring tab to view connections to an SQL data service. 1.
In the the Admi Adminis nistra trator tor tool, tool, clic click k the the Monitoring tab.
2.
In the the Naviga Navigator, tor, expand expand a Data Integration Integration Service. Service. A list of applications appears in the Navigator.
3.
In the Navigator Navigator,, expand an applica application tion under under the Data Integrat Integration ion Service, Service, and and then select select SQL Data Services . A list of SQL data services appears in the contents panel.
4.
In the contents contents panel, panel, select select the name of the SQL data data servic service. e. The Properties view of the SQL data service displays in the contents panel.
5.
In the the con conte tent nts s pane panel, l, cli click ck the the Connections view. Connections to the SQL data service appear in the contents panel.
6.
In the contents contents panel, panel, select select a connection connection to view view connection connection propert properties ies in the details details panel. panel.
Task 1. View Profile and Scorecard Jobs
23
Task 3. View Requests for an SQL Data Service In this task, you use the Monitoring tab to view requests for an SQL data service. 1.
In the the Admi Adminis nistra trator tor tool, tool, clic click k the the Monitoring tab.
2.
In the the Naviga Navigator, tor, expand expand a Data Integration Integration Service. Service. A list of applications appears in the Navigator.
3.
In the Navigator Navigator,, expand an applica application tion under under the Data Integrat Integration ion Service Service and then then select select SQL Data Services . A list of SQL data services appears in the contents panel.
4.
In the contents contents panel, panel, select select the name of the SQL data data servic service. e. The Properties view of the SQL data service displays in the contents panel.
5.
In the the con conte tent nts s pane panel, l, cli click ck the the Requests view. Requests for the SQL data service appear in the contents panel.
6.
In the contents contents panel, panel, select select a reques requestt to view reques requestt properties properties in in the details details panel. panel.
Task 4. View Requests for a Web Service In this task, you use the Monitoring tab to view requests for a web service. 1.
In the the Admi Adminis nistra trator tor tool, tool, clic click k the the Monitoring tab.
2.
In the the Naviga Navigator, tor, expand expand a Data Integration Integration Service. Service. A list of applications appears in the Navigator.
3.
In the Navigator Navigator,, expand an applica application tion under under the Data Integrat Integration ion Service Service and then then select select Web Services . A list of web services appears in the contents panel.
4.
In the contents contents panel, panel, select select the name of the web servic service. e. The Properties view of the web service displays in the contents panel.
5.
In the the con conte tent nts s pane panel, l, cli click ck the the Requests view. Requests for the web service appear in the contents panel.
6.
In the contents contents panel, panel, select select a reques requestt to view reques requestt properties properties in in the details details panel. panel.
Monitoring Jobs and Applications Summary In this lesson you learned that you can view jobs, SQL data service connections, and SQL data service requests for a Data Integration Service. You viewed jobs that were running on a Data Integration Service. You also viewed connections and requests for an SQL data service.
24
Chapter 5: Lesson 4. Monitoring Jobs and Applications
A P P E N D I X A
Frequently Asked Questions This appendix includes the following topic: ¨
Informatica Administrator Frequently Asked Questions, 25
Informatica Administrator Frequently Asked Questions Review the frequently asked questions to answer questions you may have about Informatica Administrator. What is the difference between Informatica Administrator and the PowerCenter Administration Console?
The PowerCenter Administration Console is renamed to Informatica Administrator (the Administrator tool). The Administrator tool has a new interface. Some of the properties and configuration tasks from the PowerCenter Administration Administration Console have been moved to different locations in the Administrator tool. The Administrator tool is also expanded to include new services and objects. Can I use one user account to access the Administrator tool and the Developer tool?
Yes. You can give a user permission to access both tools. You do not need to create separate user accounts for each application client. What is the difference between the PowerCenter Repository Service and the Model Repository Service?
The PowerCenter application services and PowerCenter application clients use the PowerCenter Repository Service. The PowerCenter repository has folder-based security. The other application services, such as the Data Integration Service, Analyst Service, Developer tool, and Analyst tool, use the Model Repository Service. The Model Repository Service has project-based security. You can migrate some Model repository objects to the PowerCenter repository. Where can I use database connections that I create in the Informatica Administrator?
You can create, view, and edit database connections in the Administrator tool and the Developer tool. You can create and view database connections in the Analyst tool. You can also configure database connection pooling in the the Administrator tool. What is the difference between the PowerCenter Integration Service and the Data Integration Service?
The PowerCenter Integration Service is an application service that runs sessions and workflows. The Data Integration Service is an application service that performs data integration tasks for the Analyst tool, the Developer tool, and external clients. The Analyst tool and the Developer tool send data integration task requests to the Data Integration Service to preview or run data profiles, SQL data services, and mappings. Commands from the command line or an external client send data integration task requests to the Data Integration Service to run SQL data services or web services.
25
Why can I not connect to an SQL data service that is deployed to a Data Integration Service?
To connect to an SQL data service, the application that contains the SQL data service must be running. You can start an application in the Applications view of the Data Integration Service.
26
Appendix A: Frequently Asked Questions
