question

Shri-6058 avatar image
0 Votes"
Shri-6058 asked Shri-6058 commented

SharePoint Online External Content Type not available

Hello,

We are heavily dependent on external content type. Currently BCS options available in hidden feature. Is there mean Microsoft going to depreciate this service? Should I use any other PowerApps options to connect external content type? Please advise on recommended way to setup an external content type in SPO.

So far I tried to import .bdcm from service application interface and it was successful. I also added "Enable Profile Page Creation Host SharePoint site URL" however when I go to tanent application, external content type itself is not available.

I then tried with SharePoint Designer 2013 and I get the following error:
Always it shows the error:
134297-image.png

If I click "External content type" button on the designer, it throws the following error:
134319-image.png




Please advise on how to enable/configure the BCS for external content type.

office-sharepoint-onlineoffice-sharepoint-server-administrationoffice-sharepoint-server-developmentoffice-sharepoint-server-customizationoffice-sharepoint-server-itpro
image.png (16.9 KiB)
image.png (41.4 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Also, is SharePoint Online BCS works only with SQL Azure or any other onpremises SQL server connections can be made?

0 Votes 0 ·

1 Answer

CaseyYangMSFT-4714 avatar image
0 Votes"
CaseyYangMSFT-4714 answered Shri-6058 commented

Hi @Shri-6058,

You could create an External List by using Business Connectivity Services (BCS) and Secure Store to access data from a Microsoft SQL Azure database. BCS connects SharePoint solutions to external data, and Secure Store enables user authentication for the data.

1.Create a Business Connectivity Service
SharePoint admin center > Active sites page > More features > BCS > Manage connections to online services
2.Create a Secure Store Service ID
SharePoint admin center > Active sites page > More features > Secure store > New
3.Create the External Content Type
SharePoint designer 2013 > External Content Type > Add Connection
4.Adding external list

You could get more details from the following link. It is a article describes how to configure the SharePoint Online Integration with Azure SQL Server step by step. Hope it will help you. Office 365 SharePoint Online BCS with Azure SQL Server Database


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you. We dont have a plan to use Microsoft SQL Azure and I am wondering any other gateway opens to connect to onpremises sql server database?
We are heavily depending on these external content type. When I did research, WCF service might help to connect but I havenot any idea. If there are any adapter or configurations to access onpremise option would be really helpful. Is that PowerApps allows onpremises database connections?

Many thanks in advance!

0 Votes 0 ·