Accelerating Cloud Application Adoption with Informatica ... Cloud Application Adoption with Informatica Cloud Data Integration ... • GDM Architecture ... Accelerating Cloud Application Adoption with

Download Accelerating Cloud Application Adoption with Informatica ...  Cloud Application Adoption with Informatica Cloud Data Integration ... • GDM Architecture ... Accelerating Cloud Application Adoption with

Post on 03-Apr-2018




3 download

Embed Size (px)


<ul><li><p>1 </p><p>Accelerating Cloud Application Adoption with Informatica Cloud Data Integration </p><p>Gurjeet Khanuja, IT Director </p><p>Logitech </p><p>Mayank Misra, Director </p><p>Pfizer </p></li><li><p>2 </p><p>Session Agenda </p><p> Hear from two Informatica PowerCenter </p><p>customers on their Cloud strategy </p><p> Mayank Misra, Pfizer </p><p> Gurjeet Khanuja, Logitech </p><p> Hear why Informatica Cloud is ideal for cloud-</p><p>based applications like Salesforce CRM and </p><p> </p><p> Learn how to take advantage of cloud-based data </p><p>integration as part of a broader Informatica </p><p>strategy </p></li><li><p>3 </p><p>Mayank Misra, Director Team Lead - </p><p>Architecture &amp; Engineering GCM </p></li><li><p>4 </p><p>Disclaimer </p><p>I am an employee of Pfizer. The statements or opinions expressed </p><p>are my own and do not necessarily represent those of Pfizer. </p><p>This presentation outlines a general technology direction. Pfizer </p><p>has no obligation to pursue any approaches outlined in this </p><p>presentation or to develop or use any functionality mentioned in </p><p>this presentation. The technology strategy and possible future </p><p>developments are subject to change and may be changed at </p><p>any time for any reason without notice. </p></li><li><p>5 </p><p>About </p><p> Pfizer </p><p> The worlds premier biopharmaceutical company. </p><p> 2011 Statistics: $69 billion in revenue, 89 manufacturing sites worldwide, 150 countries in which Pfizer sells products, 12 products with sales above $1 billion </p><p> Global Data Management CoE </p><p> Delivers BI solutions and technologies for all business unit across geographies </p><p> GDM Architecture &amp; Technology Engineer Mayank Misra </p><p> Responsible for technology strategy, enabling standardized, pre-architected patterns of use and pre-engineered hosting environments for Data Warehousing and Business Intelligence initiatives. </p><p> Oversight over data management platforms hosting over 350 business intelligence solutions catering to 85,000 users worldwide. </p><p> @MayankMisra | | </p><p>mailto:mayank.misra@pfizer.com</p></li><li><p>6 </p><p>Starting Point </p><p>Veeva is used as a CRM/SFA solution </p><p> Frequent data synchronization </p><p>between on-premise systems </p><p>and Veeva/ </p><p> Sales representative engagements, product families, territory, addresses etc </p><p> Used by emerging markets </p><p>and in smaller teams </p><p>supporting established </p><p>products </p></li><li><p>7 </p><p>The Challenge </p><p>The Salesforce Apex Data Loader process </p><p>Extremely </p><p>Not easily </p><p>Took a long </p><p>resource intensive </p><p>recoverable </p><p>time troubleshoot </p><p>Prone to errors </p><p>(human and technical) </p></li><li><p>8 </p><p>Fast </p><p>Flexible </p><p>Accurate </p><p>Secure </p><p>TCO </p><p>Set and forget </p><p>data synchronization </p><p>based on a schedule </p><p>or an event/trigger </p><p>Incremental loading </p><p>and use files and </p><p>Oracle tables to drive </p><p>record deletes from </p><p>Salesforce objects </p><p>Data quality relevant, </p><p>timely and trusted </p><p>Complied Pfizer </p><p>information protection </p><p>requirements around </p><p>governance and data </p><p>exchange through </p><p>the firewall (encryption, </p><p>authentication </p><p>authorization, entitlements) </p><p>Lower cost of </p><p>ownership than </p><p>the current process </p><p>(solution and </p><p>platform support) </p><p>The Challenge </p></li><li><p>9 </p><p>Options Considered </p><p> Enables solution support to be self sufficient. Very little training to set </p><p>up and administer </p><p> Simple - Load, Synchronize, Replicate, Profile, Standards based </p><p> Subscription based pricing </p><p>Informatica Cloud </p><p> COTS, mappings are metadata driven, re-usable and highly secure </p><p> Salesforce data synchronization becomes part of the same paradigm </p><p>as PowerCenter little-to-no learning curve for developers </p><p>PowerExchange for Salesforce </p></li><li><p>10 </p><p>Integration Pattern Selection Criteria </p><p>PowerExchange </p><p>for SFDC Informatica Cloud </p><p>Solu</p><p>tion</p><p>Automation, Synchronization </p><p>Load sequencing </p><p>Replication </p><p>Profiling Integration *1 </p><p>Need for specialists *2 </p><p>Security</p><p> Encryption </p><p>Authentication *3 </p><p>Authorization </p><p>Entitlements </p><p>Pla</p><p>tform</p><p> Infrastructure </p><p>Configuration *4 </p><p>Support *4 </p><p>Licensing *5 </p></li><li><p>11 </p><p>Findings </p></li><li><p>12 </p><p>Selected Approach </p><p>Simple Integration No Platform Admin Troubleshoot Anywhere </p></li><li><p>13 </p><p>Fast </p><p>Flexible </p><p>Accurate </p><p>Secure </p><p>TCO </p><p>Informatica Cloud </p><p>enables an </p><p>implementation in </p><p>days </p><p>It can be administered </p><p>from any geography </p><p>regardless of where </p><p>the on-premise </p><p>location is. </p><p>The workflow set up </p><p>is scalable, easy and </p><p>flexible </p><p>Data quality relevant, </p><p>timely and trusted </p><p>Address Doctor for all </p><p>regions always available </p><p>without the need to keep </p><p>it current or update if </p><p>new region is required. </p><p>Provides for delegated </p><p>administration enabling </p><p>provisioning of integration </p><p>environments in multi-</p><p>tenant scenario </p><p>Adequately addresses </p><p>controls for governance </p><p>and data exchange </p><p>through the firewall. LDAP </p><p>integration will be </p><p>addressed in a subsequent </p><p>release. </p><p>Does not require </p><p>specialized skills or </p><p>an investment in IT </p><p>infrastructure </p><p>Overall Impression </p></li><li><p>14 </p><p>Roadmap </p><p>Keep all solutions within </p><p>Informatica Suite! </p><p>Informatica Cloud for emerging </p><p>markets/projects with limited resources </p><p> Business unit SME/ data analysts, self sufficient in </p><p>defining define initial data integration needs. As </p><p>complexity grows, CoE experts to provide assistance. </p><p> As application / data demands grow, the application can </p><p>be seamlessly moved to a more robust on-premise </p><p>environment </p><p>PowerExchange for global solutions developed </p><p>and maintained centrally but </p><p>are used by all geographies </p><p> Require highly complex transformation/ integration logic </p><p> Handle complex business rules in real time and process very large volumes of data </p><p> Data profiling and quality controls require deep integration with on-premise transactional systems </p></li><li><p>15 </p><p>Gurjeet Khanuja, IT Director </p></li><li><p>16 </p><p>About Logitech </p><p> Global leader in consumer electronics </p><p> Diverse but focused portfolio </p><p> PC/Mac/tablets peripherals, Advanced remote controls, Digital music products, Video communications, Digital video security </p><p> Products for retail consumers and business </p><p> R&amp;D centers around the globe </p><p> Doing business in 100 countries </p><p> $2.32 billion in annual revenue </p><p> 3500 professional employees plus factory employees </p><p> Incorporated in Switzerland, key operations in Silicon Valley, </p><p>Switzerland, China </p></li><li><p>17 </p><p>About Me </p><p> IT Director, WW Business Systems Development Applications, Tools &amp; Technology </p><p> Oracle E-Business Suite EDW ETL Informatica PowerCenter, Cloud CRM Application, IT Service Management CA Unicenter Web Development, Lotus Notes, Jive SBS </p><p> Masters &amp; Bachelor degrees in Computer Science </p><p> Over 22 years of experience, worked in Consumer </p><p>Electronics, Software, Hardware, and High-Tech </p><p>industries </p><p> Email: </p><p></p></li><li><p>18 </p><p>Various Technologies @ Logitech </p></li><li><p>19 </p><p>Informatica @ Logitech </p><p>2008 </p><p>2010 </p><p>2011 </p><p>Informatica PowerCenter user since 2008 </p><p>Informatica Cloud Primarily for data replication </p><p>from other Cloud </p><p>applications </p><p>Informatica MDM Product Master 2011 </p><p> Customer Master 2012 </p><p>(Phase I) </p></li><li><p>20 </p><p>Data resides in various applications: </p><p>1. A custom trade promotion </p><p>management (TPM) application was </p><p>built on (PaaS) </p><p>2. Oracle E-Business Suite </p><p> Soft Dollar Accruals </p><p> Customer Claims </p><p>3. Global point-of-sale data resides in </p><p>Enterprise Data Warehouse </p><p>Distributed Systems </p></li><li><p>21 </p><p>Our Situation </p><p>Business wants Trade Promotion </p><p>Analytics and Reporting </p><p>IT wants to safeguard cloud data </p><p>( </p><p>Need to replicate data from </p></li><li><p>22 </p><p>Looked At 4 Solutions </p><p> Very primitive tool </p><p> Works only with </p><p> Works with CSV files only </p><p> Cannot transform data </p><p> Poor error handling </p><p> Simple but very primitive in functionality </p><p> Unable to sustain </p><p> Resource intensive </p><p> Major efforts even for simple replication </p><p> Need skilled resources </p><p> On-going maintenance </p><p> Total cost of ownership is high </p><p> Pros Real-time, Data Orchestration, Post/Pre processing </p><p>2 1 </p></li><li><p>23 </p><p>Looked At 4 Solutions </p><p> Lots of powerful features </p><p> But - for Salesforce - higher IT support for PowerCenter than with Informatica Cloud </p><p> Extra cost for PowerCenter Salesforce adapter </p><p> Need skilled resources </p><p> Although not as robust as </p><p>PowerExchange for Salesforce </p><p>less transformations available - </p><p>the capabilities matched our </p><p>needs </p><p> Data Replication Service perfect </p><p>for our use case </p><p> SaaS subscription </p><p> Support several end-points </p><p>4 3 </p></li><li><p>24 </p><p>Why Informatica Cloud? </p><p>Quick time to Market </p><p>Scalability </p><p>Cost effective </p><p>Live in less than 1 month Various Connectors </p><p>Subscription-based Set and Forget </p><p>Little maintenance needed </p><p>Functionality </p><p>Changes in tables automatically synchronized </p><p> </p></li><li><p>25 </p><p>Business data Flow SECURE AGENT </p><p>(Connections (source &amp; Target) are initiated by the secure agent) </p><p>Metadata Flow (SFDC, BI-DB, Schedule, Mapping, etc) </p><p> BI Database </p><p>$MART Tables </p><p>Informatica Cloud Services (DML Operations) </p><p> </p><p>Activity Customer, Activity Fund, Fund, Activity Product, PayToActivity, User, UserRole &amp; etc </p><p>Architecture </p></li><li><p>26 </p><p>Informatica Cloud vs. PowerCenter </p><p>Informatica Cloud Informatica PowerCenter </p><p>Replicate Data from any public cloud Dealing with multiple source systems </p><p>Simple transformation Handling complex business logics &amp; </p><p>complex transformations </p><p>New data sources need new </p><p>connectors </p><p>Dealing with reusable </p><p>transformations </p><p>Build Operational Data Source (ODS) Stored procedure call for pre/post </p><p>process </p><p>Consider for any data replication, </p><p>integration need </p><p>Integration with OS scripts </p><p>Parallel executions in single task </p></li><li><p>27 </p><p>Cloud Technology at Logitech </p><p>In the next 5 years 80% of our infrastructure will move into the Cloud </p><p> Why cloud? </p><p> TCO is low </p><p> Easier to maintain </p><p> Less resources needed </p><p> Pay-per-use </p><p> Important things to note: </p><p> Security is critical for our organization </p><p> Look into a private cloud solutions if needed </p></li><li><p>28 </p><p>Hindsight is 20/20 </p><p> We currently integrate our custom application TPMS </p><p>with Oracle EBS using Oracle Fusion Middleware </p><p> A resource intensive exercise </p><p> Long implementation time 3 months </p><p> Higher Administration and maintenance overhead </p></li><li><p>29 </p><p>Current Trade Promotion Management </p><p>Enterprise </p><p>Data </p><p>Warehouse </p><p>Projects </p><p>Activities Claims </p><p>Funds </p><p>Sub- funds </p><p>Customers </p><p>Suppliers </p><p>GL Segments </p><p>Data </p><p>Products </p><p>Geography </p><p>Hierarchy </p><p>Currency </p><p>Exchange </p><p>Units of </p><p>Measure </p><p>Calendar </p><p>Users </p><p>POS data Accrual Engine </p><p> GL Purchasing AP AR </p><p>Funds </p><p>SFDC </p><p>Enterprise Data </p><p>Warehouse (EDW) </p><p>Oracle Fusion Middleware </p><p>Oracle Application E-Business Suite </p><p>Calculate </p><p>Accruals </p><p>Generate </p><p>PR/PO </p><p>Generate </p><p>AP </p><p>Invoice </p><p>Generate </p><p>A/R </p><p>Invoice </p><p>Reverse </p><p>Accruals </p><p>0 </p><p>to </p><p>n </p><p>Sale</p><p>sfo</p><p>rce.c</p><p>om</p><p>Sell-in data </p><p>Post </p></li><li><p>30 </p><p>If we had known about </p><p>Informatica Cloud earlier </p></li><li><p>31 </p><p>Trade Promotion Management </p><p>Enterprise </p><p>Data </p><p>Warehouse </p><p>Projects </p><p>Activities Claims </p><p>Funds </p><p>Sub- funds </p><p>Customers </p><p>Suppliers </p><p>GL Segments </p><p>Data </p><p>Products </p><p>Geography </p><p>Hierarchy </p><p>Currency </p><p>Exchange </p><p>Units of </p><p>Measure </p><p>Calendar </p><p>Users </p><p>POS data Accrual Engine </p><p> GL Purchasing AP AR </p><p>Funds </p><p>SFDC </p><p>Enterprise Data </p><p>Warehouse (EDW) </p><p>Oracle Fusion Middleware </p><p>Oracle Application E-Business Suite </p><p>Calculate </p><p>Accruals </p><p>Generate </p><p>PR/PO </p><p>Generate </p><p>AP </p><p>Invoice </p><p>Generate </p><p>A/R </p><p>Invoice </p><p>Reverse </p><p>Accruals </p><p>0 </p><p>to </p><p>n </p><p>Sale</p><p>sfo</p><p>rce.c</p><p>om</p><p>Sell-in data </p><p>Post </p><p>Informatica Cloud </p></li><li><p>32 </p><p>Leveraging Informatica Cloud </p><p> We could have used Informatica Cloud to </p><p> Shorten our implementation time </p><p> Lower development cost </p><p> Minimize administrative and support cost </p><p> Simplify our data replication requirements </p></li><li><p>33 </p><p>Questions? </p><p>Accelerating Cloud Application </p><p>Adoption with Informatica </p><p>Cloud Data Integration </p></li></ul>


View more >