• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Technology
    • Development
    • Hardware
    • Intune
    • Microsoft
    • Office
    • Office 365
    • Security
    • SharePoint
    • Software
    • SQL server
  • Personal development
    • Blog
    • Career
    • Freelancer
    • Knowledge
    • NEWS
    • Private
    • Thoughts
  • Consulting services
  • Contact me

Not only IT

About life, IT and other things...

Home » Technology » SharePoint » How to use SharePoint 2010 BCS

How to use SharePoint 2010 BCS

March 28, 2011 By Tomasz Szulczewski Leave a Comment

In previous post I’ve presented how to configure SharePoint secure store. Now it’s time to use it with BCS, which make them excellent team. It’s not a big deal, you need just SharePoint Designer.

When you connect with Designer to your site

imageyou have to select “External Content Types”, it will allow you to create connection to your database. Now it’s time to make our connection, so please select “Add connection”

imageimage

And then we need connection to SQL Server. Ok almost there. Now we have to enter all information necessary to connect to database and use our Secure Store application – select “Custom Identity” as shown.

imageAnd in the last step enter login and password which you used during secure store setup. To check that we did it you have to run SQL Server Profiler and run trace with filter for a login name

image

Now each time you explore created connection in SharePoint Designer (Drill down), you will see that these information are requested by our custom SQL Server account.

[adblockingdetector id=”5770e6ed85560″]

Related

Filed Under: SharePoint Tagged With: SharePoint

About Tomasz Szulczewski

I've got more than 20 years of IT experience. IT is my passion and I am still increasing my skills. I work as a SharePoint, Office 365 and Azure architect.

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the Newsletter

Social media

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Search this site

Sign up for Wise accounts

Signup and earn $25

payoneer
payoneer

My latest achievement

Microsoft 365 Certified: Enterprise Administrator Expert
Microsoft 365 Certified: Enterprise Administrator Expert

Tags

Azure Azure Active Directory BizSpark Blog career Certification cloud conference edge freelance Freelancer Hardware home office InfoPath Intune Knowledge licensing Microsoft Microsoft 365 News Office Office 365 Personal development Power virtual agent Private security SharePoint SharePoint designer SharePoint online Software SQL server upwork Windows Windows 365 yammer

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2022 Tomasz Szulczewski