In SharePoint 2013, Business Data Connectivity (BDC) is effected through SharePoint Designer 2013, as opposed to the prior process through Central Administration. For those who have grown accustomed to the SharePoint 2007 model of BDC creation, this change may take some getting used to. This series of articles will walk you through the process of creating a model for the BDC service that returns information about contacts in a sample database.
Part 1: Generating a new key for using BDC on a portal site
Select the Secure Store Service hyperlink to generate the new key:
Enter the Pass Phrase (which was created when installing the machine) into the “Generate New Key” form:
Step 2: Click on the New menu under “Manage Target Applications” to create a new key:
Input the required information into the form that appears.
Click Next to continue:
Step 3: Enter the user(s) who will have permission to use the BDC when logging onto the site:
Click OK to complete. Make sure that you see the new key on the page after creating your new key.
Step 4: Click on the context menu, and select Set Credentials to set permissions:
Enter the user name and password for the user(s) who should have permission, and click Save to finish:
Check out the rest of the series here:
- Part 2: Connecting to a Portal Site and Creating BDC
- Part 3: Creating an Association Between External Content Types for BDC
- Part 4: Setting Permissions for your BDC and Data-Viewer Web Part Integration
The cloud parts are functional components that extend your SharePoint Online environment in Microsoft 365.
Supports Classic and Modern sites for SharePoint Online/Microsoft 365
Small Business Pricing and Discounts
These web parts extend SharePoint beyond its out-of-the-box capabilities by tailoring it to your requirements with Bamboo Solution’s growing portfolio of SharePoint Web Parts.
SharePoint 2016, 2019, 2022 – Classic Pages Only
Our team of Microsoft 365 Technology Consultants helps you get the most out of your Microsoft technology, we have the best Microsoft 365 talent to streamline your organization.
Consulting to Streamline Your Department