Comments on iLove SharePoint: Connecting SQL Azure To SharePoint Online with BCS...

Thanks for following up on this. That means more f...

2011-12-08T12:54:23.166+01:00

Thanks for following up on this. That means more fun for us then, gotta learn Azure Services as well.

Anyway 3rd party connectivity solutions can bridge...

2011-12-06T09:11:31.303+01:00

Anyway 3rd party connectivity solutions can bridge the gap. See this sample of a bi-directional and codeless connection between a native SharePoint list and a SQL Azure table query:

http://www.layer2.de/en/community/FAQs/cloud-connector/Pages/SharePoint-Lists-As-Azure-Web-Frontend-Office-365.aspx

Unfortunately yes, they told me that direct connec...

2011-12-06T08:58:36.079+01:00

Unfortunately yes, they told me that direct connections to SQL Azure are not supported. And the updated the service description accordingly http://www.microsoft.com/download/en/details.aspx?id=13602 (Microsoft SharePoint Online for Enterprises Service Description.docx)
Seems that it was a bug that worked ;-)
You have to use an Azure WCF-Service as wrapper for SQL Azure. Read http://blogs.msdn.com/b/steve_fox/archive/2011/11/12/leveraging-wcf-services-to-connect-bcs-with-sharepoint-online.aspx

Any updates as I am getting the same error?

2011-12-06T00:55:59.099+01:00

Any updates as I am getting the same error?

Christian, I know it is sad to hear, but I'm a...

2011-12-01T06:45:34.867+01:00

Christian, I know it is sad to hear, but I'm actually glad you are now getting the error as well :) At least now we now it is an MS issue and not something we did wrong. Thanks again for you great blog post.

A great step forward with data intgeration in Offi...

2011-11-30T12:44:59.088+01:00

A great step forward with data intgeration in Office 365. At this time our clients use the 3rd party Cloud Connector to sync almost any external on-premise and cloud data directly to native SharePoint lists in the cloud, codeless and bi-directional, if required:

http://www.layer2.de/en/products/Pages/Cloud-Connector-for-SharePoint-2010-Office365.aspx

Would be intersting to compare with cloud BCS. Anny differences to on-premise?

Now I get the same error "Unable to display t...

2011-11-30T09:40:38.915+01:00

Now I get the same error "Unable to display this Web Part... ". I will contact support...

Same here, I keep getting the Unable to displays t...

2011-11-30T02:47:20.941+01:00

Same here, I keep getting the Unable to displays this Web Part error. Any updates on this. Are you still able to connect to your external list now that the BCS update has finally rolled-out completely?

I get the same error "Unable to display this ...

2011-11-21T11:05:26.235+01:00

I get the same error "Unable to display this Web Part". Opening the exteral list in SPD I get this "soap:ServerException of type 'Microsoft.SharePoint.SoapServer.SoapServerException' was thrown.An error has occurred."

Brilliant article. When the external list get rend...

2011-11-20T00:04:54.855+01:00

Brilliant article.
When the external list get rendered in SP-0 I am getting the following error. Only few records. So not a throttling issue. Is there anyway to view the error log SP-O

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:c3f2be92-9463-48d8-a3a5-874eb51bf9cd

Brilliant article

2011-11-13T11:26:59.671+01:00

Brilliant article

Great post, thanks for sharing!

2011-11-10T15:51:25.492+01:00

Great post, thanks for sharing!