1 / 17

Empower SharePoint with SQL Server Features !

Empower SharePoint with SQL Server Features ! . v. Who am I ? . Solution Architect SharePoint MVP Responsible for the SharePoint area, tends to use innovation in creating new solutions and development strategies. Love the idea by and for the community. v. v. Rodrigo Pinto.

fai
Download Presentation

Empower SharePoint with SQL Server Features !

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Empower SharePoint with SQL Server Features!

  2. v Who am I ? Solution Architect SharePoint MVP Responsible for the SharePoint area, tends to use innovation in creating new solutions and development strategies. Love the idea by and for the community v v Rodrigo Pinto Portuguese SharePoint User Group founder (SPUGPT- www.sharepointpt.org) v @scoutmanpt stationsolutions@gmail.com

  3. Agenda 01 – SharePoint platform 02 – Business Connectivity Services 03 – Demo time!

  4. SharePoint platform

  5. SharePoint platform 10 years of history

  6. SharePoint platform Caracteristics

  7. SharePoint platform • Scalable

  8. SharePoint platform • Core FIELD FIELD FIELD CONTENT TYPE FIELD FIELD CONTENT TYPE FIELD FIELD LIST .NET FRAMEWORK (2.0, … 3.5)

  9. SharePoint platform • DATABASE SCHEMA

  10. Business Connectivity Services

  11. Business Connectivity Services • BCS • Provides read/write access • to external data • Line-of-business (LOB) systems • Web services • Databases • Other external systems

  12. Business Connectivity Services • Availability + FREE NOT FREE

  13. Business Connectivity Services • Limitations • Capabilities • Write-Back to External Systems • Familiar UI • Offline Access to External Data • Connectivity Options • Databases, Web/WCF services • .NET connectivity assemblies, Custom ds • Extensible Provider Model • Batch and Bulk Operation Support • Enhanced API Set and Extensibility • ECT concept ! • No versioning or version history • No inline editing or DataSheet View • No item Level Permissions • No REST access • No RSS feeds • No Lookups, Attachments or Ratings • No Information Management Policies • Worlflowscannot be configured on External Lists  …

  14. Demo Time!

  15. Some Links & Tips SharePoint List Adapters http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 File Tables http://msdn.microsoft.com/en-us/library/ff929144.aspx • B.C.S. http://msdn.microsoft.com/en-us/magazine/ee819133.aspx • Think outside the box Build Services, not stuff • K.I.S.S. TheoryKeep It Simple Stupid – Don’t reinvent the wheel

  16. Q&A

  17. EMAIL stationsolutions@ gmail.com TWITTER @scoutmanpt Rodrigo Pinto EMAIL

More Related