Informatica PowerExchange for LinkedIn(Version 9.1.0 HotFix 1)

User Guide

Informatica PowerExchange for LinkedIn User Guide

Version 9.1.0 HotFix 1June 2011

Copyright (c) 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 anddisclosure 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) without prior consent of Informatica Corporation. This Software may be protected by U.S. and/or internationalPatents 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 inDFARS 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), asapplicable.

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

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 OnDemand, Informatica Identity Resolution, Informatica Application Information Lifecycle Management, Informatica Complex Event Processing, Ultra Messaging and InformaticaMaster Data Management are trademarks or registered trademarks of Informatica Corporation in the United States and in jurisdictions throughout the world. All other companyand 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 rightsreserved. Copyright © Sun Microsystems. All rights reserved. Copyright © RSA Security Inc. All Rights Reserved. Copyright © Ordinal Technology Corp. All rightsreserved.Copyright © Aandacht c.v. All rights reserved. Copyright Genivia, Inc. All rights reserved. Copyright Isomorphic Software. All rights reserved. Copyright © MetaIntegration Technology, Inc. All rights reserved. Copyright © Intalio. All rights reserved. Copyright © Oracle. All rights reserved. Copyright © Adobe Systems Incorporated. Allrights 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 © InformationBuilders, Inc. All rights reserved. Copyright © OSS Nokalva, Inc. All rights reserved. Copyright Edifecs, Inc. All rights reserved. Copyright Cleo Communications, Inc. All rightsreserved. Copyright © International Organization for Standardization 1986. All rights reserved. Copyright © ej-technologies GmbH . All rights reserved. Copyright © JaspersoftCorporation. 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 theLicense 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 notlimited 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 ofthis software is subject to terms available at http://www.openssl.org and http://www.openssl.org/source/license.html.

This product includes Curl software which is Copyright 1996-2007, Daniel Stenberg, <daniel@haxx.se>. All Rights Reserved. Permissions and limitations regarding thissoftware 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 withoutfee 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 availableat 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 termsavailable at http://dojotoolkit.org/license.

This product includes ICU software which is copyright International Business Machines Corporation and others. All rights reserved. Permissions and limitations regarding thissoftware are subject to terms available at 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 & WirelessDeutschland. Permissions and limitations regarding this software are subject to terms available at http://www.opensource.org/licenses/mit-license.php .

This product includes software developed by Boost (http://www.boost.org/) or under the Boost software license. Permissions and limitations regarding this software are subjectto terms available at http:/ /www.boost.org/LICENSE_1_0.txt. This product includes software copyright © 1997-2007 University of Cambridge. Permissions and limitationsregarding this software are subject to terms available at http://www.pcre.org/license.txt.

This product includes software copyright © 2007 The Eclipse Foundation. All Rights Reserved. Permissions and limitations regarding this software are subject to termsavailable at http://www.eclipse.org/org/documents/epl-v10.php.

This product includes software licensed under the terms at http://www.tcl.tk/software/tcltk/license.html, 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.libssh2.org,http://slf4j.org/license.html, http://www.sente.ch/software/OpenSourceLicense.html, http://fusesource.com/downloads/license-agreements/fuse-message-broker-v-5-3- license-agreement; http://antlr.org/license.html; http://aopalliance.sourceforge.net/; http://www.bouncycastle.org/licence.html; http://www.jgraph.com/jgraphdownload.html; http://www.jcraft.com/jsch/LICENSE.txt. http://jotm.objectweb.org/bsd_license.html; http://www.w3.org/Consortium/Legal/2002/copyright-software-20021231; http://www.slf4j.org/license.html; http://developer.apple.com/library/mac/#samplecode/HelpHook/Listings/HelpHook_java.html; http://www.jcraft.com/jsch/LICENSE.txt;http://nanoxml.sourceforge.net/orig/copyright.html; http://www.json.org/license.html; and http://forge.ow2.org/projects/javaservice/.

This product includes software licensed under the Academic Free License (http://www.opensource.org/licenses/afl-3.0.php), the Common Development and DistributionLicense (http://www.opensource.org/licenses/cddl1.php) the Common Public License (http://www.opensource.org/licenses/cpl1.0.php), the Sun Binary Code LicenseAgreement Supplemental License Terms, the BSD License (http://www.opensource.org/licenses/bsd-license.php) and the MIT License (http://www.opensource.org/licenses/mit-license.php).

This product includes software copyright © 2003-2006 Joe WaInes, 2006-2007 XStream Committers. All rights reserved. Permissions and limitations regarding this softwareare subject to terms available at http://xstream.codehaus.org/license.html. This product includes software developed by the Indiana University Extreme! Lab. For furtherinformation 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 Pending.

DISCLAIMER: Informatica Corporation provides this documentation "as is" without warranty of any kind, either express or implied, including, but not limited to, the impliedwarranties of oninfringement, merchantability, or use for a particular purpose. Informatica Corporation does not warrant that this software or documentation is error free. 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 notice.

NOTICES

This Informatica product (the "Software") includes certain drivers (the "DataDirect Drivers") from DataDirect Technologies, an operating company of Progress SoftwareCorporation ("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 NOTLIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE 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 OFTHE POSSIBILITIES OF DAMAGES IN ADVANCE. THESE LIMITATIONS APPLY TO ALL CAUSES OF ACTION, INCLUDING, WITHOUT LIMITATION, BREACHOF CONTRACT, BREACH OF WARRANTY, NEGLIGENCE, STRICT LIABILITY, MISREPRESENTATION AND OTHER TORTS.

Part Number: PWX-LIU-91000-0001

Table of Contents

Preface . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iiiInformatica Resources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii

Informatica Customer Portal. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii

Informatica Documentation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii

Informatica Web Site. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii

Informatica How-To Library. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iii

Informatica Knowledge Base. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iv

Informatica Multimedia Knowledge Base. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iv

Informatica Global Customer Support. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . iv

Chapter 1: Understanding PowerExchange for LinkedIn. . . . . . . . . . . . . . . . . . . . . . . . . . . . 1PowerExchange for LinkedIn Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

PowerCenter and LinkedIn Integration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1

Chapter 2: Installation and Configuration. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2Installation and Configuration Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

Before You Install. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2

PowerExchange for LinkedIn Installation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Installing the Client Component. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Installing the Server Component. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3

Registering the Plug-in. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 4

Chapter 3: LinkedIn Sources. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5LinkedIn Sources Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

Connection Source Type. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5

People Source Type. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Creating a LinkedIn Source Definition. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 6

Chapter 4: PowerExchange for LinkedIn Sessions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8PowerExchange for LinkedIn Sessions Overview. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Running the OAuth Authentication Script. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8

Configuring Application Connections. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

LinkedIn Query String. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9

Configuring a Session for a LinkedIn Source. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Appendix A: Datatype Reference. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11LinkedIn and Transformation Datatypes. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 11

Table of Contents i

Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 12

ii Table of Contents

PrefaceThe Informatica PowerExchange for LinkedIn User Guide provides information about how to use PowerExchangefor LinkedIn in conjunction with PowerCenter to extract user information from LinkedIn and move that informationto targets for analysis. The guide is written for database administrators and developers who are responsible fordeveloping mappings, sessions, and workflows that read data from LinkedIn sources. This guide assumes that youhave knowledge of LinkedIn and PowerCenter.

Informatica Resources

Informatica Customer PortalAs an Informatica customer, you can access the Informatica Customer Portal site at http://mysupport.informatica.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 ProductDocumentation, and access to the Informatica user community.

Informatica DocumentationThe Informatica Documentation team takes every effort to create accurate, usable documentation. If you havequestions, comments, or ideas about this documentation, contact the Informatica Documentation team throughemail at infa_documentation@informatica.com. We will use your feedback to improve our documentation. Let usknow 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.

Informatica Web SiteYou can access the Informatica corporate web site at http://www.informatica.com. The site contains informationabout Informatica, its background, upcoming events, and sales offices. You will also find product and partnerinformation. The services area of the site includes important information about technical support, training andeducation, and implementation services.

Informatica How-To LibraryAs 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

iii

includes articles and interactive demonstrations that provide solutions to common problems, compare features andbehaviors, and guide you through performing specific real-world tasks.

Informatica Knowledge BaseAs 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 Informaticaproducts. You can also find answers to frequently asked questions, technical white papers, and technical tips. Ifyou have questions, comments, or ideas about the Knowledge Base, contact the Informatica Knowledge Baseteam through email at KB_Feedback@informatica.com.

Informatica Multimedia Knowledge BaseAs an Informatica customer, you can access the Informatica Multimedia Knowledge Base at http://mysupport.informatica.com. The Multimedia Knowledge Base is a collection of instructional multimedia filesthat help you learn about common concepts and guide you through performing specific tasks. If you havequestions, comments, or ideas about the Multimedia Knowledge Base, contact the Informatica Knowledge Baseteam through email at KB_Feedback@informatica.com.

Informatica Global Customer SupportYou can contact a Customer Support Center by telephone or through the Online Support. Online Support requiresa 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:

North America / South America Europe / Middle East / Africa Asia / Australia

Toll FreeBrazil: 0800 891 0202Mexico: 001 888 209 8853North America: +1 877 463 2435 Standard RateNorth America: +1 650 653 6332

Toll FreeFrance: 00800 4632 4357Germany: 00800 4632 4357Israel: 00800 4632 4357Italy: 800 915 985Netherlands: 00800 4632 4357Portugal: 800 208 360Spain: 900 813 166Switzerland: 00800 4632 4357 or 0800 463200United Kingdom: 00800 4632 4357 or 0800023 4632 Standard RateFrance: 0805 804632Germany: 01805 702702Netherlands: 030 6022 797

Toll FreeAustralia: 1 800 151 830New Zealand: 1 800 151 830Singapore: 001 800 4632 4357 Standard RateIndia: +91 80 4112 5738

iv Preface

C H A P T E R 1

Understanding PowerExchange forLinkedIn

This chapter includes the following topics:

¨ PowerExchange for LinkedIn Overview, 1

¨ PowerCenter and LinkedIn Integration, 1

PowerExchange for LinkedIn OverviewPowerExchange for LinkedIn provides connectivity between PowerCenter and LinkedIn to extract LinkedIn data.You can extract the following kinds of information:

¨ LinkedIn user profiles that match the search criteria that you specify

¨ LinkedIn connections for the user account for which you provide an authentication token

You can load the extracted data to a target and then use the data for data mining and analysis.

PowerExchange for LinkedIn calls a LinkedIn API to access LinkedIn data. The API uses OAuth security toenforce data access controls. PowerExchange for LinkedIn provides a script that returns OAuth authenticationinformation. You specify this information in an application connection object that you create in the WorkflowManager.

PowerCenter and LinkedIn IntegrationPowerExchange for LinkedIn integrates LinkedIn with the Designer and the PowerCenter Integration Service.

You use the Designer to create LinkedIn source definitions. You can then use those source definitions in mappingsfor seamless integration between PowerCenter and LinkedIn.

The Integration Service connects to LinkedIn to extract LinkedIn data.

The Integration Service uses an OAuth token and token secret to authenticate with LinkedIn. A connection objectstores the OAuth token and token secret.

The Integration Service uses the LinkedIn API to process queries for LinkedIn data. You specify the queryparameters when you define the session attributes.

1

C H A P T E R 2

Installation and ConfigurationThis chapter includes the following topics:

¨ Installation and Configuration Overview, 2

¨ Before You Install, 2

¨ PowerExchange for LinkedIn Installation, 3

¨ Registering the Plug-in, 4

Installation and Configuration OverviewThis chapter provides information about installing and configuring PowerExchange for LinkedIn.

Before You InstallBefore you install PowerExchange for LinkedIn, complete the following tasks:

1. Install or upgrade Informatica.

2. Verify that you have read and write permissions on the following directories on each machine that runs thePowerCenter Integration Service or PowerCenter Repository Service:

<Informatica Installation Directory>\server\bin<Informatica Installation Directory>\server\bin\Plugin

The installer must be able to add and overwrite files in these directories.

3. Verify that you have read and write permissions on the following directories of each PowerCenter Clientmachine:

<Informatica Installation Directory>\clients\PowerCenterClient\client\bin<Informatica Installation Directory>\clients\PowerCenterClient\client\bin\Help<Informatica Installation Directory>\clients\PowerCenterClient\client\bin\Help\<language>

The installer must be able to add and overwrite files in these directories.

2

PowerExchange for LinkedIn InstallationWhen you install PowerExchange for LinkedIn, you install the following components that enable PowerCenter toaccess LinkedIn:

¨ Client component. Enables you to import definitions, create mappings, and create connection objects using thePowerCenter Client.

¨ Server component. Enables the PowerCenter Repository Service to access the LinkedIn metadata in therepository and the PowerCenter Integration Service to run LinkedIn sessions.

Installing the Client ComponentInstall the Client component on each PowerCenter Client machine where you want to create or access LinkedInmetadata.

1. Before running the installation, close all applications.

2. Run install.bat from the download location.

3. Select the language to use during installation and click OK.

The Welcome window introduces the PowerExchange for LinkedIn Client component installation.

4. Click Next.

5. Click OK to stop the PowerCenter Client.

The Installation Directory window appears.

6. Enter the absolute path to the PowerCenter installation directory. Click the Browse button to find the directoryor use the default directory.

By default, the installation directory is in the following location:C:\Informatica\<version>\

7. Click Next.

The Pre-Installation Summary window summarizes the installation information.

8. Review the installation information and click Install to continue.

The installer shows the progress of the installation. When the installation is complete, the InstallationSummary window displays the status of the installation.

9. Click Done.

You can view the log files generated by the installer to get more information about the installation tasks performedby the PowerExchange for LinkedIn Client component installer and to view configuration properties for theinstalled components.

Installing the Server ComponentThe PowerExchange for LinkedIn server component installs the PowerCenter Integration Service andPowerCenter Repository Service components. The server component runs on Windows only.

If the PowerCenter Integration Service or PowerCenter Repository Service is configured to run on primary andbackup nodes, install the PowerExchange for LinkedIn server component on each node configured to run thePowerCenter Integration Service or PowerCenter Repository Service.

1. Run install.bat from the installation package.

2. Click Next.

PowerExchange for LinkedIn Installation 3

3. Select the Informatica installation directory.

By default, the server components are installed in the following location:C:\Informatica\<version folder>

4. Click Next.

5. Click Install to begin the installation.

6. Click Done when the installation is complete.

The PowerCenter Integration Service and PowerCenter Repository Service components are installed.

Registering the Plug-inAfter you install PowerExchange for LinkedIn, register the plug-in with the repository.

A plug-in is an XML file that defines the functionality of PowerExchange for LinkedIn. To register the plug-in, therepository must be running in exclusive mode. Use the Administration Console or the pmrep RegisterPlugincommand to register the plug-in.

The plug-in file for PowerExchange for LinkedIn is pmlinkedin.xml. When you install the PowerExchange forLinkedIn server component, the installer copies pmlinkedin.xml to the following directory:

<Informatica Installation Directory>/server/bin/Plugin

For more information about using the Administration Console to register a plug-in, see the InformaticaAdministrator Guide.

For more information about the pmrep RegisterPlugin command, see the Informatica Command Reference.

Note: If you do not have the correct privileges to register the plug-in, contact the user who manages thePowerCenter Repository Service.

4 Chapter 2: Installation and Configuration

C H A P T E R 3

LinkedIn SourcesThis chapter includes the following topics:

¨ LinkedIn Sources Overview, 5

¨ Connection Source Type, 5

¨ People Source Type, 6

¨ Creating a LinkedIn Source Definition, 6

LinkedIn Sources OverviewLinkedIn source definitions represent metadata for LinkedIn. You create LinkedIn source definitions, rather thanimport them.

When you create a LinkedIn source definition, you select one of the following source types:

¨ Connection

¨ People

The Designer creates a source definition with a predefined set of ports for the source type.

When the Integration Service reads data from a LinkedIn source, it converts the data based on the datatypes inthe Application Source Qualifier that is associated with the source.

For more information about the LinkedIn data that the Connection and People source types represent, see theLinkedIn Help Center at https://help.linkedin.com/.

Connection Source TypeThe Connection source type defines LinkedIn connections information. You can access connections for theLinkedIn user account for which you provide an authentication token when you define the application connection.

The Connection source type includes the following ports:

¨ ID

¨ FirstName

¨ LastName

¨ HeadLine

5

¨ Location

¨ Industry

¨ Distance

¨ PublicProfileUrl

¨ PictureUrl

People Source TypeThe People source type defines LinkedIn user profile information.

The People source type includes the following ports:

¨ ID

¨ FirstName

¨ LastName

¨ HeadLine

¨ Location

¨ CountryCode

¨ Industry

¨ Distance

¨ Status

¨ Summary

¨ Specialties

¨ Honors

¨ Interests

¨ DoBMonth

¨ DoBDay

¨ DoBYear

¨ Address

¨ NumConnections

¨ NumRecommenders

¨ PublicProfile

Creating a LinkedIn Source Definition1. In the Source Analyzer, click Sources > Create LinkedIn Source.

The Create LinkedIn Source dialog box appears.

6 Chapter 3: LinkedIn Sources

2. Enter the following information:

Parameter Description

Source Name Name of the data source that you are creating.

Source Type Type of LinkedIn data. Select People or Connections.

3. Click OK.

Creating a LinkedIn Source Definition 7

C H A P T E R 4

PowerExchange for LinkedInSessions

This chapter includes the following topics:

¨ PowerExchange for LinkedIn Sessions Overview, 8

¨ Running the OAuth Authentication Script, 8

¨ Configuring Application Connections, 9

¨ LinkedIn Query String, 9

¨ Configuring a Session for a LinkedIn Source, 10

PowerExchange for LinkedIn Sessions OverviewAfter you create mappings in the Designer, you can create a session and use the session to extract, transform,and load data. Create sessions and workflows in the Workflow Manager.

Before the PowerCenter Integration Service extracts data from LinkedIn sources, you must perform the followingtasks:

¨ Run a script that returns an Oauth token and token secret. You enter these values when you configure anapplication connection.

¨ Configure an application connection in the Workflow Manager.

¨ Configure session properties.

Running the OAuth Authentication ScriptOn the PowerCenter Client machine, run the linkedinoauth.exe script to receive an OAuth access token and atoken secret for the account that PowerExchange for LinkedIn uses to access LinkedIn. When you define aLinkedIn application connection, you enter these values as connection attributes. If your session includes aConnections source type, the session returns connections only for the user account for which you supply theaccess token and token secret.

1. Change to the following directory:<Informatica Installation Directory>\clients\PowerCenterClient\client\bin

8

2. At the command prompt, enter the following command:linkedinoauth -u LinkedIn_user -p LinkedIn_password

The OAuth authentication script displays a link for you to paste into a Web browser to receive a PIN.

3. Copy and paste the link into a Web browser.

4. Follow the prompts to log into LinkedIn and grant the application permission to use your LinkedIn account.

The application displays a five-digit PIN.

5. At the OAuth authentication script prompt for a PIN, enter the five-digit PIN.

The OAuth authentication script displays an access token and a token secret.

6. Save the access token and token secret. You will enter these values when you create a LinkedIn applicationconnection.

Configuring Application ConnectionsConfigure an application connection before you run a LinkedIn session. When you configure a LinkedIn applicationconnection, specify the connection attributes that the PowerCenter Integration Service uses to connect to LinkedIn.

1. In the Workflow Manager, click Connections > Application.

The Application Connection Browser dialog box appears.

2. Click New.

3. From the Select Subtype list, select LinkedIn Social Media Connection.

4. Click OK.

The Connection Object Definition dialog box appears.

5. Enter the following connection attributes:

Connection Attribute Description

User Token OAuth user token that the OAuth authorization script returned

User Token Secret OAuth user token secret that the OAuth authorization script returned

Row Limit Maximum number of rows of data to return

LinkedIn Query StringWhen you configure a session for a LinkedIn source, you specify the query string that the LinkedIn People SearchAPI uses to search for user profiles.

In the query string, include one or more parameters that are defined as input values in the LinkedIn People SearchAPI. For example, you can include the following parameters:

¨ first-name

¨ last-name

¨ company-name

Configuring Application Connections 9

¨ school-name

¨ postal-code

Use an ampersand (&) to specify an AND condition.

For example, you could specify the following query:

first-name=Umbrella&last-name=Corporation

For more information, see the documentation of the Linked In People Search API at the following location:

http://developer.linkedin.com/docs/DOC-1191

Configuring a Session for a LinkedIn SourceConfigure session properties for a LinkedIn source on the session Mapping Tab.

If a LinkedIn session includes a People source type, define the query string that the LinkedIn People Search APIuses to search for user profiles.

The following table describes the session properties for a LinkedIn People source type:

Session Property Description

Query string Query string that the LinkedIn People Search API uses to search for user profiles.

Note: Because the LinkedIn API can return connections only for the user account for which you provide anauthentication token in the connection definition, you do not supply a query string for a Connection source type, asyou do for a People source type.

10 Chapter 4: PowerExchange for LinkedIn Sessions

A P P E N D I X A

Datatype ReferenceThis appendix includes the following topic:

¨ LinkedIn and Transformation Datatypes, 11

LinkedIn and Transformation DatatypesPowerCenter uses the following datatypes in LinkedIn mappings:

¨ LinkedIn native datatypes. LinkedIn datatypes appear in LinkedIn definitions in a mapping.

¨ Transformation datatypes. Set of datatypes that appear in the transformations. They are internal datatypesbased on ANSI SQL-92 generic datatypes, which the Integration Service uses to move data across platforms.They appear in all transformations in a mapping.

When the Integration Service reads source data, it converts the native datatypes to the comparable transformationdatatypes before transforming the data. When the Integration Service writes to a target, it converts thetransformation datatypes to the comparable native datatypes. For more information about datatypes, see thePowerCenter Designer Guide.

The following table lists the LinkedIn datatypes that PowerCenter supports and the corresponding transformationdatatypes:

LinkedIn Datatype Description Transformation Datatype Description

CVarchar String values String 1 to 104,857,600characters

CNumeric Numeric values Decimal Precision 1 to 28 digits,scale 0 to 28

11

I N D E X

Aapplication connections

configuring for PowerExchange for LinkedIn 9authentication

user authentication for LinkedIn 1

CClient component

installing 3configuring

session 10creating

LinkedIn source definitions 6

DDesigner

integration with LinkedIn 1

Iinstalling

Client component 3PowerExchange for LinkedIn 2, 3

LLinkedIn data

permissions 8

LinkedIn source definitionscreating 6overview 5

Ppermissions

on LinkedIn 8plug-ins

registering PowerExchange for LinkedIn 4PowerCenter

integration with LinkedIn 1PowerCenter Integration Service

integration with LinkedIn 1PowerExchange for LinkedIn

installing 2overview 1

Ssession

configuring 10

12