Guide for Excel Integration Fusion CRM ADFdi

1. Guide for Excel IntegrationFusion CRM ADFdi Derrek Greenleaf Product Manager derrek.greenleaf@oracle.com

2. Agenda • An overview of CRM Excel Integration Framework • End-user flow for CRM Excel Integration Framework • Authoring and administration tasks • Example of CRM Excel integration Framework template and usage • Excel forms and examples • Contact information, additional reference Goal – To promote the usage of the CRM Excel Integration Framework to product managers and to assist pillar product managers in documenting requirements (FDD) for specific business processes where Excel integration is needed. Oracle Confidential, DRAFT

3. 1. Overview of CRM Excel Integration Framework • When and why to utilize Excel Integration Framework? • When end-users need a fast and easy way to make mass changes to large amounts of CRM data (which is very difficult and timely to do inside Fusion CRM) • To increase end-user adoption - enable CRUD operations of CRM data in Excel (a familiar, user-friendly desktop application) • To lower TCO - based on CRM-built Excel components & Oracle Application Development Framework Desktop Integration (ADFdi) • Who should utilize Excel Integration Framework? • CRM product managers and engineers • Standard toolkit for delivering OOTB Excel templates for specific business processes (e.g. Territory Management, Opportunity Management) • CRM customers • To modify OOTB Excel templates or to create new Excel templates for specific business processes • What are capabilities of Excel Integration Framework? • Bi-directional data exchange between Fusion CRM and Excel • End-user control over data downloaded from Fusion CRM to Excel • End-user access of Excel templates from Fusion CRM or stand-alone • User authentication, data access, server-side validation consistent with Fusion CRM • Administrator authoring and distribution of Excel templates • It is not designed to be… • One-way, static export of data from Fusion CRM to Excel • Reporting tool • Replacement for the CRM client Oracle Confidential, DRAFT

4. 1. Overview of Excel Integration - framework • CRM Excel Components • Export from Fusion • Custom download • Saved searches • Multi-sheet navigation • Template admin • Starter kit FINANCIALS HCM SCM CRM Excel Integration Framework = red blocks • ADFdi Features • Download & upload • Create, copy, delete records • Track changed records • Form and list layout • Template authoring • User authentication • Single sign-on • Support for Excel 2003, 2007 (forthcoming) Oracle Confidential, DRAFT

5. 2.User flow for CRM Excel Integration Framework Optional ~ advanced search User can pull data from the application to work with, in the Excel template A. Download Start from within an application - OR – Start direct from an Excel template (from attachment, url, etc.) B. Working in Excel Within Excel template, use native Excel features (e.g. drag & drop, calculations) to create, review, update, delete data For a sales rep, this could include mass edits, calculations, advanced formulas, and formatting C. Upload Modified data uploaded back to application D. Validation Server side data validation Oracle Confidential, DRAFT

6. DownloadStart from application or template directly User selects to work in Excel If there are multiple templates available, user selects from list Oracle Confidential, DRAFT

7. B. Working in Excel (opportunity ex. below) Oracle Confidential, DRAFT

8. Optional – advanced searchfrom within the template, user can query data Oracle Confidential, DRAFT

9. C. Upload - data uploaded back to application Oracle Confidential, DRAFT

10. 3. Author and Admin tasks for CRM Excel Integration Framework Developer constructs Excel template and the application administrator associates application objects in JDEV Excel elements defined and constructed using developer tool (such as the DEG- data entry grid) in the Excel Template (This step is a developer assisted operation ) Distribution of the template to the field Template posted to shared location Template sent as an email attachment or URL Administrator associates the template w/in the application through administration Screens • Of note: • Multiple templates can be associated within an application view; a selection box will appear for the user to choose correct template. • A content management system can be used to manage templates : to version, expire templates etc. Oracle Confidential, DRAFT

11. 4. Example usage and template Oracle Confidential, DRAFT

12. 4. Example – step 1. Search for oppty’s and select the Excel template Step 1. Sales rep searches for opportunities > $100M • Sales Rep searches for opportunities > $100M • Sales Rep wants to manipulate and edit multiple opportunities, using most convenient, familiar tool: Excel Step 2. Select Excel Template Oracle Confidential, DRAFT

13. 4. Example- step 2. End user updates data (oppty’s) in Excel • Sales rep updates probability and amount of several opportunities, using native Excel • Sales rep creates new opportunity (copy, paste) Oracle Confidential, DRAFT

14. 4. Example- step 3. Updates made by user are uploaded End user can upload from CRM ADFdi enabled template menu, or from upload button Oracle Confidential, DRAFT

15. 5. Product manager next steps and action items • Product manager’s (you the audience) next steps: • Please construct an Excel mock up for your specific needs: • Select data • Think about data layout and presentation • What layout you want • references • Last – take that template mockup and put in your FDD • Your engineers can then mock-up the templates for inclusion in the product package, and ADFDI enable them. Oracle Confidential, DRAFT

16. 6. Contact info, reference materials Author and product manager owner for the CRM Excel Integration Framework: Derrek Greenleaf, derrek.greenleaf@oracle.com User experience’s team Excel ADFDI recommendations and site: http://fusiongps/guidelines/content/guidelines/adfdi/index.htm I’ll reference this presentation – The CRM Excel Integration Framework Guide – and updated versions in Oracle files at the following location: http://files.oraclecorp.com/content/MySharedFolders/DPS%20Team%20Folder/Excel%20Integration%20(Fusion) For additional information on the framework and/sample etc., please direct your technical resources (development & engineering) to the following: • FDD – Excel Integration ADFdi Fusion Sales CRM • CRM Engg wiki: http://www-apps/cgi-bin/fdi/wiki • ADF Wiki • Includes Technical requirements for ADF • Technology stack and includes Sample Project for ADF setup • Learn ADF Site: http://www.oracle.com/technology/products/adf/learnadf.html • Alex Davis’ (ADF – Desktop Integration – ‘DI’) wiki:  http://aseng-wiki.us.oracle.com/asengwiki/display/ASDevJDeveloper/ADF+Desktop+Integration Oracle Confidential, DRAFT

17. END Additional Reference Materials follow Oracle Confidential, DRAFT

18. Excel Integration • Templates are constructed within a Java Enterprise • Client side element that enables ADFdi Excel interaction • Authoring kit, that allows for the interaction with ADFdi / JDev. • See ADFdi internal engineering Wiki Programming Guide: • http://aseng-wiki.us.oracle.com/asengwiki/display/ASDevJDeveloper/Desktop+Integration+Development+Guide/ • Templates are maintained and created externally • Can use a Content Management Tool • See Stellant documentation • Oracle’s Content Management toolkits • http://my.oracle.com/portal/page/myo/ver-1/ROOTCORNER/SALES_KIT_REPOSITORY/Products/Fusion%20Middleware/Content%20Management/OracleSocialTaggingWhitePaper.pdf • Implement through a shared folder structure • Sharepoint Structure / Windows • Webserver folder structure Oracle Confidential, DRAFT

19. ADFdi enabled Excel template screenshot What ADFdi looks like from an end user perspective (old visual style) Oracle Confidential, DRAFT