Hi

I am trying to follow the steps here: https://support.office.com/en-us/article/Make-an-External-List-from-a-SQL-Azure-table-with-Business-Connectivity-Services-and-Secure-Store-466f3809-fde7-41f2-87f7-77d9fdadfc95?CorrelationId=43d93a2d-2f41-4ba9-9507-b30bc7b72b37&ui=en-US&rs=en-US&ad=US

To make an external list. First we have to: Step 1: Set permissions on the BCS Metadata Store

Unfortunately the link here to the detailed steps takes you to a page for sharepoint on premises. The instructions for this don't seem to match sharepoint online.

e.g.

1. Open the SharePoint Central Administration website with either a Farm administrator account or an account that has been delegated permissions to administer the Business Data Connectivity Service Applications.

2. On the Quick Launch, click Application Management.

3. On the Application Management page, under Service Applications, click Manage service applications.

I don't see these options in sharepoint online.

In Office 365, it is:

1) Click on the Top Left menu (App Launcher) > Administrator

2) Administrator / SharePoint

3) BCS

When I have a question about O365, I tend to go to this forum:

https://community.office365.com/en-us/f

• Edited by KM KTNN 18 hours 33 minutes ago

Thanks KM

So simple and yet no info online about this. BTW I asked that forum first. They didn't know the answer and just directed me to a Microsoft document that explained how to configure but NOT how to set up / begin.

Thanks for your help. I will try to set up now.

Do you know if its necessary to set up an external data connection like this if only connecting to an azure database in an access web app? In other words, its not a sharepoint list but its not exactly external either as its hosted in the sharepoint site collection.