Archive

Archive for July, 2012

Download SharePoint Server 2013, SharePoint Foundation 2013, SharePoint 2013 Designer, Language packs

July 16, 2012 1 comment

Now, download links available for  Microsoft SharePoint Server 2013 Preview , SharePoint Foundation 2013 Preview, SharePoint 2013 Designer, and Language Packs for SharePoint Server 2013 Preview

You can download Microsoft SharePoint Server 2013 Preview

You can download SharePoint Foundation 2013 Preview

You can download SharePoint Designer 2013

You can download Language Packs for SharePoint Server 2013 Preview

Advertisements
Categories: SharePoint 15

Approaches to Access SharePoint Data Programmatically (Part 1)

Microsoft SharePoint Server 2010 introduces several new approaches to interact with SharePoint Data . LINQ to SharePoint feature allow to build complex query with user friendly LINQ syntax , also both CAML and LINQ to SharePoint support join predictae in queries.one of major evolutions in SharePoint 2010 is the blurring of the distinction, between internal and external data.we can use many of the same techniques to query extenal data.

Key Approaches to Data Access

SharePoint 2010 introduces 3 key approaches to query data :CAML queries, LINQ to SharePoint, and BCS object model.

1- CAML queries

SPQuery and SPSiteDataQuery classes support submitting queries in CAML syntacs, in SharePoint 2010 CAML support JOIN predicate in queries ,also SPQuery class is using to query external list and the result are non-type items.

2- LINQ to SharePoint

SharePoint 2010 allows you to use LINQ queries to perform data operations on SharePoint Data. LINQ to SharePoint works against strongly typed entities . There is a command-line tool in SharePoint 2010 called SPMETAL that we can use to generate thses entities. internally , the LINQ to SharePoint provider generates the underlying CAML queries that perform data operations.

3-Business Connectivity services (BCS) object model

BCS object model enable us to ineract with external data .

In Next Part (Part 2), i’ll explain Query Classes (SPSiteDataQuery and SPQuery classes ) in details and what are the best practices of using these classes .

 

the following screenshot is taken from MSDN , this screenshot illustrate the usage of using each of Queries classes , LINQ to SharePoint , and BCS Object Model

references :-

http://msdn.microsoft.com/en-us/library/ff798432

Publish Service Applications

Publishing service applications enables remote farms to consume the services of the primary farm. SharePoint Server 2010 supports publication of the following services :-

  1. Managed Metadata Service.
  2. User Profile.
  3. Search
  4. Secure Store Service.
  5. Business Data Connectivity.
  6. Web analytics.

The consuming and publishing farms have to be hosted within domains that share a trust.

Once the infrastructure requirements have been met, publishing service applications requires exchanging trust certificates between the farms. These trust certificates include one root and one Security Token Service (STS) certificate. Exchanging trust certificates ensures that each farm acknowledges that the other farm can be trusted.

The following steps for exchanging the trust certificates between farms :-

  1. Export the root certificate from the consuming farm.
  2. Export the STS certificate from the consuming farm.
  3. Export the root certificate from the publishing farm.
  4. Import the root certificate and create a trusted root authority in the consuming farm.
  5. Import the root certificate and create a trusted root authority in the publishing farm.
  6. Import the STS certificate and create a trusted service token issuer on the publishing farm.

First step: – Export the root certificate from the consuming farm

  1. From start menu, find Microsoft SharePoint 2010 Products, then select SharePoint 2010 Management Shell , then write the following commands

    $certificate=(Get-SPCertificateAuthority).RootCertificate

    $certificate.Export(“Cert”) | Set-Content <drive>:\<path>\Root-Consuming.cer -Encoding byte

    Note : <drive>:\<path> here write any path in your environment .

Second step : export the STS certificate from the consuming farm

  1. From start menu, find Microsoft SharePoint 2010 Products, then select SharePoint 2010 Management Shell , then write the following commands

    $certificate = (Get-SPSecurityTokenServiceConfig).LocalLoginProvider.SigningCertificate

    $certificate.Export(“Cert”) | Set-Content d:\Certificates\STS-Consuming.cer -Encoding byte

Third Step : export the root certificate from the publishing farm

  1. From start menu, find Microsoft SharePoint 2010 Products, then select SharePoint 2010 Management Shell , then write the following commands

    $certificate=(Get-SPCertificateAuthority).RootCertificate

    $certificate.Export(“Cert”) | Set-Content d:\Certificates\Root-Publishing.cer -Encoding byte

Fourth Step: Import the root certifi cate and create a trusted root authority on the consuming farm

  1. From start menu, find Microsoft SharePoint 2010 Products, then select SharePoint 2010 Management Shell , then write the following command

    $certificate = Get-PfxCertificate d:\Certificates\Root-Publishing.cer

    New-SPTrustedRootAuthority -Name WFEFarm1 -Certificate $certificate

    -Name paramte represent a new trusted root authority

Fifth step: import the root certifi cate and create a trusted root authority on the publishing farm

  1. From start menu, find Microsoft SharePoint 2010 Products, then select SharePoint 2010 Management Shell , then write the following commands

    $certificate = Get-PfxCertificate <drive>:\<path>\Root-Consuming.cer

    New-SPTrustedRootAuthority -Name WFEFarm2 -Certificate $certificate

    -Name parameter represents a new trusted root authority

Sixth Step: import the STS certifi cate and create a trusted service token issuer on the publishing farm

  1. From start menu, find Microsoft SharePoint 2010 Products, then select SharePoint 2010 Management Shell , then write the following commands

    $certificate = Get-PfxCertificate <drive>:\<path>\STS-Consuming.cer

    New-SPTrustedServiceTokenIssuer -Name WFEFarmTrust1 -Certificate $certificate

    -Name parameter represents the name of the trust.

Service Applications in SharePoint Server 2010

In MOSS 2007 the services were contained within SSP ( Shared Service Provider ), SSP contains services such as search, Profile, BI, and Excel . although SSP provide benefit such as isolating search service and shared across multiple web applications) , also SSP have challenges such as flexibility , deployment, and didn’t provide third-part extensibility .

In SharePoint Server 2010, services can be distributed as individual service applications, provisioned on demand at run time, or later in the deployment cycle, as business needs change and evolve.

Here in the following table we are listing all service applications which are available in SharePoint Server 2010

Service Application Edition
Business Connectivity Service SharePoint Foundation 2010
Usage and Health Data collection SharePoint Foundation 2010
Subscription Setting Service SharePoint Foundation 2010
User Profile SharePoint Server 2010 Standard Edition
Managed Metadata Service SharePoint Server 2010 Standard Edition
Search SharePoint Server 2010 Standard Edition
Secure Store Service SharePoint Server 2010 Standard Edition
State SharePoint Server 2010 Standard Edition
Web Analytics SharePoint Server 2010 Standard Edition
Word Automation Services SharePoint Server 2010 Standard Edition
Access Services SharePoint Server 2010 Enterprise Edition
Excel Services Application SharePoint Server 2010 Enterprise Edition
PerformancePoint Service Application SharePoint Server 2010 Enterprise Edition
Visio Graphics Service SharePoint Server 2010 Enterprise Edition

Service applications are deployed through three primary entry points:

  1. Windows PowerShell
  2. Farm Confi guration Wizard
  3. SharePoint 2010 Central Administration