Sharing SharePoint Knowledge

Technical Solutions for SharePoint Server 2010

Kerberos Authentication in SharePoint 2010

Posted by Chandrasekaran C N on July 16, 2010

Hi All,

Microsoft has published a whitepaper on Configuring Kerberos Authentication in SharePoint 2010 and other articles on technet related to Kerberos Authentication.

Thanks,
Chandrasekaran C N

Advertisements

Posted in Kerberos Authentication, SharePoint 2010 | Tagged: , | Leave a Comment »

Microsoft SharePoint 2010 – More Resources

Posted by Chandrasekaran C N on July 5, 2010

Hi All,

Last week, Microsoft has published more resources on Microsoft SharePoint 2010. Following are the details of those resources

Operations Guide for SharePoint Server 2010  — > http://tiny.cc/xshv8
Operations Guide for SharePoint Foundation Server 2010  — > http://tiny.cc/volz6
Technical Reference for SharePoint Server 2010 — > http://tiny.cc/v30c2
Planning Guide for SharePoint 2010 — > http://tiny.cc/97zwr
Developing Applications in SharePoint 2010  — > http://tiny.cc/rixf3

Hope these resouces are useful for all SharePointers… 🙂

Thanks,
Chandrasekaran C N

Posted in Resources, SharePoint 2010 | Tagged: , | Leave a Comment »

Microsoft TechEd 2010 SharePoint Sessions

Posted by Chandrasekaran C N on June 21, 2010

Hi All,

Here is the consolidated list of all SharePoint related sessions that were held at Microsoft TechEd 2010, North America.

Microsoft TechEd 2010 – SharePoint 2010 Sessions
Session Details
Code OSP301
Title Building RIA with Silverlight and SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP301
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP301.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP301.wmv
   
Code OSP302
Title Building Solutions with Business Connectivity Services
Session http://www.msteched.com/2010/NorthAmerica/OSP302
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP302.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP302.wmv
   
Code OSP303
Title Deploying and Upgrading to Microsoft Project Server 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP303
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP303.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP303.wmv
   
Code OSP304
Title Developing and Branding with the New User Interface Features in Microsoft SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP304
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP304.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP304.wmv
   
Code OSP305
Title Developing Document Sets in Microsoft SPS 2010 Enterprise Content Management
Session http://www.msteched.com/2010/NorthAmerica/OSP305
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP305.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP305.wmv
   
Code OSP306
Title Developing Microsoft SPS 2010 Solutions with Claims Authentication
Session http://www.msteched.com/2010/NorthAmerica/OSP306
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP306.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP306.wmv
   
Code OSP307
Title Developing Office Business Applications with Microsoft Office 2010 and Microsoft SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP307
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP307.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP307.wmv
   
Code OSP308
Title Developing with Microsoft SPS 2010 Sandboxed Solutions
Session http://www.msteched.com/2010/NorthAmerica/OSP308
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP308.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP308.wmv
   
Code OSP309
Title Developing with REST and LINQ in Microsoft SharePoint 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP309
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP309.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP309.wmv
   
Code OSP310
Title Fine Tuning Your Microsoft SPS 2010 Environment
Session http://www.msteched.com/2010/NorthAmerica/OSP310
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP310.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP310.wmv
   
Code OSP311
Title From N to Z: Authentication and Authorization in Microsoft SPS 2010 
Session http://www.msteched.com/2010/NorthAmerica/OSP311
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP311.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP311.wmv
   
Code OSP312
Title Help! My Users Are Everywhere: Designing (Developing) for a Global SharePoint Audience 
Session http://www.msteched.com/2010/NorthAmerica/OSP312
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP312.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP312.wmv
   
Code OSP313
Title Microsoft Office 2010: Developing the Next Wave of Productivity Solutions
Session http://www.msteched.com/2010/NorthAmerica/OSP313
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP313.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP313.wmv
   
Code OSP314
Title Microsoft Outlook and Exchange 2010: Better Together Overview
Session http://www.msteched.com/2010/NorthAmerica/OSP314
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP314.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP314.wmv
   
Code OSP315
Title Microsoft SPS 2010 As a Social Computing Platform 
Session http://www.msteched.com/2010/NorthAmerica/OSP315
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP315.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP315.wmv
   
Code OSP316
Title Microsoft SPS 2010 for the Microsoft ASP.NET Developer
Session http://www.msteched.com/2010/NorthAmerica/OSP316
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP316.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP316.wmv
   
Code OSP317
Title Outlook Social Connector: Deployment and Development Overview
Session http://www.msteched.com/2010/NorthAmerica/OSP317
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP317.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP317.wmv
   
Code OSP318
Title SharePoint is Down: Solutions for High Availability and Disaster Recovery
Session http://www.msteched.com/2010/NorthAmerica/OSP318
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP318.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP318.wmv
   
Code OSP319
Title Upgrading and Improving MOSS WCM Sites to SOS 2010 Web Content Management
Session http://www.msteched.com/2010/NorthAmerica/OSP319
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP319.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP319.wmv
   
Code OSP320
Title Workflow Development in Microsoft SPS 2010 with Microsoft Visual Studio 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP320
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP320.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP320.wmv
   
Code OSP321
Title Microsoft IT: How MSIT Upgraded Microsoft to SharePoint 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP321
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP321.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP321.wmv
   
Code OSP401
Title Upgrading Microsoft Office SharePoint Server 2007 to SPS 2010
Session http://www.msteched.com/2010/NorthAmerica/OSP401
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP401.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP401.wmv
   
Code OSP402
Title Windows PowerShell Made Less Scary for the Microsoft SPS 2010 Administrator
Session http://www.msteched.com/2010/NorthAmerica/OSP402
Presentation http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/pptx/OSP402.pptx
Video http://ecn.channel9.msdn.com/o9/te/NorthAmerica/2010/wmv/OSP402.wmv

Thanks,
Chandrasekaran C N

Posted in SharePoint, SharePoint 2010 | Tagged: , | Leave a Comment »

SharePoint MVP Experts Chat – Q & A

Posted by Chandrasekaran C N on June 20, 2010

Hi All,

Any questions on SharePoint? Join live chat with SharePoint MVP Experts online on 23rd of June 2010 between 9:00 am and 10:oo am PST  (21:30 pm and 22:30 pm IST)

So start preparing questions 🙂

Thanks,
Chandrasekaran C N

Posted in Chat, SharePoint | Tagged: , | Leave a Comment »

No Code Solution: Connecting to external systems using BCS and SharePoint Designer

Posted by Chandrasekaran C N on June 17, 2010

Hi All,   

Microsoft SharePoint is a powerful tool to interact with external system such as SQL Server, SAP, Sibel, Oracle, etc., from MOSS 2007. But there are certain limitations in MOSS 2007 like  

  • Read-only access to external systems
  • No intiutive ways to create application definition file (XML)
  • Possible error-prone due to manual creation of XML file

With the latest version of SharePoint 2010, the limitations aforesaid has been addressed and new functionalities are also included.   Microsoft SharePoint Designer 2010, the successor of SharePoint Designer 2007, is used to create no code solutions that interact with external systems with all sets of CRUD operations.  

Interactions between the SharePoint 2010 and external systems is made possible using the new feature called “External Content Types” (ECTs).  An external content type is a special content type contains all the metadata that helps to access the external systems.  External content type is something similar to “Entities” in business data catalog (BDC).  

As we know, in SharePoint 2010 there a lot of services introduced, one of them is Business Connectivity Services (BCS) which uses the external content type to interact with external systems.  

To view all the external content types available in SharePoint 2010, go to Central Admin -> Manage Service Application -> Business Connectivity Services  

Fig1: Existing External Content Types

Okay. Now we will start creating a no code solution to interact with the external systems in SharePoint Designer 2010. We will split this walkthrough into sections so that it will easy to follow Section 1: Creation of External Content Type 

  1. Open up the SharePoint Designer (SPD) 2010 and select the site you want to create external content type
  2. In the left hand navigation panel, select External Content Type option. This will show up all the existing external content types, if available
  3. On the ribbon menu, select New External Content Type as shown in the diagram below

Fig 2: External Content Type creation in SPD 2010

Once we created the external content type, it will ask to fill some basic information such as Name, display name, etc., about the content type as shown below  

Fig 3: Basic Information about External Content Type

One important option we need to fill is Office Item Type. There are five different options available namely  

  • Generic List   
  • Appointment
  • Contact
  • Task
  • Post

In this case, we select “Generic List” office item type that maps to a SharePoint custom list.  

Section 2: Connect to Datasources  

Once section 1 is finished, we need to configure the connection to the datasources. In Fig 3, click on the link (arrow marked) to configure the data connection. This will open up the screen below to configure the data connection  

Fig 4: Configure Data Source Connection

In the above diagram, click on the Add Connection button, this will popup a window asking which type of connection we want to connect to. Those are  

  • .NET Type – Use to connect to any custom .NET component
  • SQL Server – Use to connect  to existing SQL Server database
  • WCF Service – Use to connect to WCF Service

Fig 5: Data Connection Types

Select SQL Server type and click ok to continue.  

Provide the SQL Server information and select ok to continue in the SQL Server Connection window as shown below.  

Here in this window there are three different options on how to connect to SQL Server  

  • Connect with User’s Identity – Indicates to connect to SQL Server with current user identity
  • Connect with Impersonated Windows Identity – Indicated to connect to SQL Server with impersonation of other’s windows identity
  • Connect with Impersonated Custom Identity – Indicates to connect to SQL Server with impersonation of other’s custom identity (non-windows identity such as SQL Server identity or some other)

Last two options are mainly depends on the Secure Store Service configuration, which is configured in the SharePoint central administration and it is similar to Single Sign-On in MOSS 2007.  

Configuration of Secure Store Service is out of scope in this post. May be I will post later sometime on how to configure the same.  

Section 3: CRUD Operations  

After finish providing the SQL Server information, it will connect to database and shows up the provided database instance as shown in the above diagram (Fig 4). In this case it is “AdventureWorks”.  

Expand the AdventureWorks to select the database objects such as Tables, Views, etc.,  Select any table you want to show up in the external list and right click the table name to define the operations we want to perform like create,update, etc.,  

Fig 6: CRUD Operations

In the above diagram, there are several operations available to define. In this walkthrough, we select “Create All Operations” meaning we need to perform all CRUD operations on this table.  

Once we select the above operations, SPD opens a wizard like dialog to configure additional parameters on the data source such as limiting the data to pull from external data sources at a time, to provide filter conditions, etc.,  

Below screenshots show how we provide the necessary information in order to complete the wizard.  

Fig 7: Startup Wizard

   

Fig 8 : Parameter Settings

   

Above diagram shows the parameter configuration, we can set which column should be read only, required, etc., One of the  property we need to focus is “Office Property”. This property needs to set for each column, if we select the office item type in Fig 3 apart from “Generic List”.  

Fig 9: Filter Settings

Following steps describes on how to provide filter conditions

Click on “Add Filter Parameter” button

Select the data source element for which we need to provide filter condition in the above diagram

Click on Filter option (Click to Add) to open the dialog box as shown in the below diagram

Fig 10: Filter Condition

  • In the above diagram, select filter type as “Limit” and Filter Field as “WorkOrderID” and click ok.
  • Provide any default value for the limit and in this case it is 100 as shown in the above diagram.
  • Finish the wizard by clicking the finish button and save the content type in the SPD.
  • After saving the external content type, you can view the created ECT in the “Business Connectivity Services” section in the central administration

    Fig 11: Created ECT in Central Administration

    Now we can able to create the external list in SharePoint site. Below screenshot shows how to create external list in SharePoint site. It is very similar to normal custom list creation except we need to select which external content we need to use for this list.

    Fig 12: Create External List

      

    Section 4: Assigning Permissions 

    In order to view the data in the SharePoint external list, we need to provide necessary permissions to the external content type. Below steps show on how to assign permissions to the external content type

    • Go to Central Admin -> Application Management -> Manage Service Applications
    • Select Business Connectivity Service option
    • Select the external content type to which we need to provide permissions
    • Select “Set Object Permissions” option as shown in the below diagram

    Fig 13: ECT Permissions

     Select the user and assign permissions to the selected user as shown in the below diagram

    Fig 14: Assign Permissions to ECT

    Click Ok to set the permissions. Now we are able to view the external data in the  SharePoint list with no code.

    Fig 15: External List with Data

    Now, it is very easy to interact with external system using BCS and SharePoint Designer with no code.

    Thanks,
    Chandrasekaran C N

     

    Posted in BCS, SharePoint 2010 | Tagged: , | Leave a Comment »