Today, one of my colleagues reported an issue with Business Connectivity Services (BCS ) in Office 365. Microsoft support's response has been: SharePoint On-Premises environments are dedicated environments where as SharePoint Online is a shared environment, hence it would be slow as compared to SharePoint On-Premise. Since the SharePoint Online List has to fetch data … Continue reading Office 365 – BCS – Performance issues – Don’t use it!
Connecting SharePoint to AS400 To connect SharePoint 2013 with data on an AS400 there are two options available: 1. Connect your BDC to the AS400 system by creating an ODBC connection on your SharePoint servers and then specifying the ODBC DSN in the connection details. 2. On the SQL Server link create a linked server … Continue reading SharePoint 2013 – Connecting SharePoint 2013 to AS400 using iSeries drivers and the Business Connectivity Service
Update an External Data field using PowerShell The situation is as follows. I have created an external list (using BDC/BCS in SharePoint 2013). My external list is called "External Users" and I have a normal custom list (Called "Custom List") with an External Data (Called "External User") field taking it's data form the External List. … Continue reading SharePoint 2013 – Update an External Data field using PowerShell