Share Point Club Interoperability MOSS Pascal Scheller Consultant

Share. Point Club – Interoperability MOSS Pascal Scheller, Consultant, Getronics SA

Agenda • Access of external Data Sources Introduction Share. Point Business Data Catalogue Implementation BDC / Best Practices • Info. Path and Reporting Services linked to external Data Sources • Lesson Learned 01 December 2020 Page 2

Introduction – Accessing external Data Sources • By means of Share. Point Enterprise Server 2007 Business Data Catalogue (BDC) Individual developed Web Parts and Features Info. Path 2007 & Office Form Server Reporting Services Reports 01 December 2020 Page 3

Introduction – Business Data Catalogue (BDC) 01 December 2020 Page 4

Introduction/Business Case – Business Data View 01 December 2020 Page 5

Introduction/Business Case – KPIs on External Data 01 December 2020 Page 6

Introduction/Business Case – Business Data Columns 01 December 2020 Page 7

Implementing BDC – Connecting External Data • Application Definition file by hand/code (xml) Toolbased • Web Part for storing data within any data source Toolbased web part generation Programming your own solution based on a BDC Application Definition 01 December 2020 Page 8

Implementing BDC - Toolbased Application Definition 01 December 2020 Page 9

Implementing BDC - Toolbased Application Definition 01 December 2020 Page 10

Info. Path & Reporting Services on external Data Sources DWH 01 December 2020 Page 11

Lesson Learned • Business Data List Web Part without grouping functionality on external data • Quick generation of BDC connection (Application Definition XML) by means of tools (Meta Man etc. ) • Info. Path 2007 Office Form Server lacks on feature for storing data to external sources • BDC enables integrating external data sources into Share. Point without programming efforts 01 December 2020 Page 12

Q&A 01 December 2020 Page 13

Thanks for your attention! 01 December 2020 Getronics Confidential Page 14