I would like to create an External Content Type (ECT) inside SharePoint Online to connect to an Azure SQL Database.

I cannot use SP Designer, what options do I have to create an ECT on a Macbook?



If you cannot create external content type by SharePoint designer, you could create external content type by visual studio.

Then you could follow the steps below to create external content type:

  1. Set permissions on the BCS Metadata Store.

  2. Create a Secure Store Mapping.

  3. Create an External Content Type (ECT) by visual studio.

  4. Create an External List.

  5. Grant permissions to manage your ECT.

For more detailed information, refer to the articles below.

Make an External List from a SQL Azure table with Business Connectivity Services and Secure Store.

How to create an “External Content Type” using Visual Studio 2012 for SharePoint 2013 Online and OData.

Create an OData data service for use as a BCS external system on SharePoint Online.


I suggest you could create external content type by SharePoint designer.

The most are the same for creating external content type in visual studio 2012 and visual studio 2019.

| improve this answer | |
  • Thanks, however a lot of these links seem really old. For example, it's 2019 and this article references VS 2012? Do you know of any newer links? Secondly, this doesn't quite answer the question on how this works on a Macbook? (e.g. can you even install Visual Studio on a Mac and it works?)... – Ushka Jun 20 '19 at 14:44
  • Lastly, it seems restrictive from Microsoft to only allow ECT's to be created from SharePoint Designer (which is being discontinued) and Visual Studio..with the advent of SPFx, surely it could be done via that model or via a UI configuration. – Ushka Jun 20 '19 at 14:45
  • I have updated my reply. – Amy_MSFT Jun 21 '19 at 8:39
  • Hey Amy, not sure if you read the original question but I said I cannot use SP Designer....do you know if Visual Studio for Mac is capable of doing the same as VS for Windows? Thanks. – Ushka Jun 22 '19 at 1:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.