140 likes | 276 Views
SharePoint Club – Interoperability MOSS. Pascal Scheller, Consultant, Getronics SA. Agenda. Access of external Data Sources Introduction SharePoint Business Data Catalogue Implementation BDC / Best Practices InfoPath and Reporting Services linked to external Data Sources Lesson Learned.
E N D
SharePoint Club – Interoperability MOSS Pascal Scheller, Consultant, Getronics SA
Agenda Access of external Data Sources Introduction SharePoint Business Data Catalogue Implementation BDC / Best Practices InfoPath and Reporting Services linked to external Data Sources Lesson Learned Page 2 20 August 2014
Introduction –Accessing external Data Sources By means of SharePoint Enterprise Server 2007 Business Data Catalogue (BDC) Individual developed Web Parts and Features InfoPath 2007 & Office Form Server Reporting Services Reports Page 3 20 August 2014
Introduction –Business Data Catalogue (BDC) Page 4 20 August 2014
Introduction/Business Case –Business Data View Page 5 20 August 2014
Introduction/Business Case –KPIs on External Data Page 6 20 August 2014
Introduction/Business Case –Business Data Columns Page 7 20 August 2014
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 Page 8 20 August 2014
Implementing BDC - Toolbased Application Definition Page 9 20 August 2014
Implementing BDC - Toolbased Application Definition Page 10 20 August 2014
InfoPath & Reporting Services on external Data Sources DWH Page 11 20 August 2014
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.) InfoPath 2007 Office Form Server lacks on feature for storing data to external sources BDC enables integrating external data sources into SharePoint without programming efforts Page 12 20 August 2014
Q & A Page 13 20 August 2014
Thanks for your attention! GetronicsConfidential