Business Connectivity Services BCS Old BDC New read

Business Connectivity Services BCS (Old BDC) • New read and write access to external data – – • • • Line-of-business (LOB) systems Web services Databases Other types of data sources Offline access to external data using cache and offline features More connectivity options and better model designer Batch and Bulk Operation Support External data via External Lists, Chart Web Part and BCS Web Parts Note BCS features vary by Share. Point version Excellent resource for BCS configuration – Fabian Williams blog http: //fabiangwilliams. wordpress. com/category/business-connectivity-services Source: http: //msdn. microsoft. com/en-us/library/ee 557658(office. 14). aspx

Business Connectivity Services BCS (Old BDC) Office Clients (Rich) BCS Describes the schema and data access capabilities of an external data source *formerly known as BDC Entity External Content Type (ECT) BCS Share. Point (Thin) Source: Share. Point 2010 Technical Resource DVD External Data Source (Web Service, DB, . Net object, LOB system, Web 2. 0 service, etc. ) BCS-enabled solutions rely on ECTs to integrate external data into Share. Point and the Office client applications

Business Connectivity Services BCS (Old BDC) Select Data Source Type Create External Content Type in Share. Point Designer Right-click entity and choose operations

Business Connectivity Services BCS (Old BDC) Optionally add a filter Define fields to pick and display Results in an editable External Content Type

Business Connectivity Services BCS (Old BDC) Create an External List Name External List and choose Info. Path Form New External List created with Info. Path Forms

Business Connectivity Services BCS (Old BDC) In Share. Point, Add External List to a Share. Point page Verify external database table populated by the External List Add an Item to the External List

ADDITIONAL RESOURCES

Resources • Choosing a Business Intelligence Tool • Share. Point Chart Web Part • Excel Services 2010 Overview – http: //technet. microsoft. com/en-us/library/ee 424405(office. 14). aspx Office Web Apps – http: //technet. microsoft. com/en-us/library/ee 855124(office. 14). aspx Performance. Point Team Blog • • • – – http: //sharepointsolutions. com/sharepoint-help/blog/index. php/2009/10/the-new-chart-web-part-in-sharepoint-2010 – http: //technet. microsoft. com/en-us/library/ee 681486(office. 14). aspx – http: //blogs. msdn. com/performancepoint/ Power. Pivot – – – • • http: //technet. microsoft. com/en-us/library/ff 394320(office. 14). aspx http: //msdn. microsoft. com/en-us/library/ee 210708(SQL. 105). aspx http: //msdn. microsoft. com/en-us/library/ee 210603(v=SQL. 105). aspx http: //social. msdn. microsoft. com/Forums/en-US/sqlkjpowerpivotforexcel/threads http: //social. msdn. microsoft. com/Forums/en-US/sqlkjpowerpointforsharepoint/threads http: //msdn. microsoft. com/en-us/library/bb 418433(SQL. 10). aspx http: //powerpivot-info. com, http: //powerpivotgeek. com and http: //powerpivotpro. com Reporting Services and Report Builder 3. 0 on Tech. Net – – http: //technet. microsoft. com/en-us/library/ee 210649(SQL. 105). aspx http: //technet. microsoft. com/en-us/library/dd 220460(SQL. 105). aspx – http: //technet. microsoft. com/en-us/library/ee 663482(office. 14). aspx Visio Services Planning

Reporting Services and Report Builder 3. 0 SSRS 2008 R 2 release in Share. Point mode allows two forms of reporting: • Out-of-the-box (OOTB) Local mode reporting : SSRS 2008 R 2 introduces the ability to render reports without an integrated Report server. Details on local mode reporting with Share. Point integration can be found at http: //msdn. microsoft. com/en-us/library/ff 487969(v=SQL. 105). aspx. Only need to install SSRS 2008 R 2 RTM Add-in for Share. Point 2010 on Share. Point 2010 RTM Web-front-end(s) to have the ability to render uploaded reports (. rdl files) for: – Share. Point Lists reports: available in Share. Point 2010 Foundation Editions or higher – Access reports: available in Share. Point 2010 Editions that Access Services is supported in • Connected mode Reporting: Uses an SSRS Report Server integrated into the Share. Point farm. Install SSRS R 2 RTM Add-in for Share. Point 2010. Details on configuring connected mode at http: //msdn. microsoft. com/en-us/library/bb 326213(v=SQL. 105). aspx. – SSRS 2008 R 2 RTM report server: In this case, with SSRS 2008 R 2 RTM Add-in for Share. Point 2010 and Share. Point 2010 refer to the what's new in SSRS R 2 functionality for information on what all is supported at http: //msdn. microsoft. com/en-us/library/ee 210710(v=SQL. 105). aspx – SSRS 2008 Report Server: A patch is needed for SSRS 2008 Report Server SP 1 CU 8 (planned for release in May, 2010) to enable its support with Share. Point 2010 and SSRS R 2 RTM Add-in for Share. Point 2010. Additionally, in this configuration existing SSRS 2008 in Share. Point mode functionality that Share. Point 2010 supports via backward compatibility with Share. Point 2007 is available / supported. New SSRS 2008 R 2 in Share. Point mode functionality like Alternate Access mapping, Access Reporting, Share. Point List reporting, etc. OR new Share. Point 2010 functionality like Claims etc. is not supported in this configuration.

Please Complete the Evaluation Form Pick up your evaluation form: • In each presentation room Drop off your completed form • Near the exit of each presentation room • At the registration area Sponsored by Dell Session Title 10

THANK YOU! Sponsored by Dell For attending this session and PASS SQLRally Orlando, Florida 11 Session Code | Session Title