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?
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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:
Set permissions on the BCS Metadata Store.
Create a Secure Store Mapping.
Create an External Content Type (ECT) by visual studio.
Create an External List.
Grant permissions to manage your ECT.
For more detailed information, refer to the articles below.
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.