SharePoint 2010: Using Secure Store Service with ECT Data Source

SharePoint 2010: Using Secure Store Service with ECT Data Source

From this article you will be able to design External Content Type Connection on SharePoint 2010 with Impersonated Custom Identity
 via Secure Store Applications.


On SharePoint Central Admin level:

1. First of all, we have enable the “Secure Store Service” from the Central Admin:

Form Central Admin ==> Services on Server ==> start the Secure Store Service. 

2. Create  new secure Store Target application:

Form Central Admin ==>  Application Management  ==>  Manage Service Applications

==> Then select the “Secure Store Service Application" => Click Manage form the ribbon menu.

 

 3. Create new Secure Store for Target Application To set our credential on SharePoint

So insert any name for Target Application ID, Contact E-mail and we will make the type to be Individual as snapshot below:

 

 

 

 

Click next to set the fields of credentials  4. Set the credentials field type base the target application property So I’m going to change the filed to be User Name and Password For our external SQL server 

  

 5. Click Next to set the Target Application Administrator

 

 

 

 

 

 

Click OK  to save.
Then you’ll find the new Target Application Secure Store ID been created as below: 

 

 6. Set the User Name and password for External SQL and the Credential Owner by click on "Set Button" :

 

 

 

Then Save. 

On this stage we have our External SQL credential Stored on SharePoint Farm. 

On SharePoint Designer level :

1. Create new external content type.

 2. Then let’s discover our external Content type.
 

3. Add connection and select SQL type: 

Now it is the Showtime:

In connection details we will use our Applications ID which we crated in pervious steps and saved on SharePoint to as Impersonated Custom Identity via Secure Store Applications.

 

 

Leave a Comment
  • Please add 5 and 3 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • Richard Mueller edited Revision 6. Comment: Removed (en-US) from title, added tags

  • Gokhan Ozcifci edited Revision 5. Comment: New Title, change content and add taggs + design

  • Craig Lussier edited Revision 4. Comment: added en-US to tags and title

  • Megren.Net edited Revision 3. Comment: Change Title

  • Megren.Net edited Revision 1. Comment: Update the contents

Page 1 of 1 (5 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Megren.Net edited Revision 1. Comment: Update the contents

  • Megren.Net edited Revision 3. Comment: Change Title

  • Hey,

    There are so much missing on this post..

    Why use Custom Identity and not Windows?

    Why are'nt you talking about external list's?

    about permissions on bdc ?

    about secure store services permissions?

    I'am going to write an post, and will made changes on you're post..

    Gokan

  • Hi Gokhan,

    I'm happy to see your feedback here,

    Actually in this post I focused on how to link (SSS) with (ECT),that’s why it become a high-level post.

    But from here we can adjust and update the post based on your suggestion..

    Megren

  • Craig Lussier edited Revision 4. Comment: added en-US to tags and title

  • Gokhan Ozcifci edited Revision 5. Comment: New Title, change content and add taggs + design

  • Richard Mueller edited Revision 6. Comment: Removed (en-US) from title, added tags

Page 1 of 1 (7 items)