SOLVED

Office 365, Sharepoint and problem with BCS

%3CLINGO-SUB%20id%3D%22lingo-sub-265504%22%20slang%3D%22en-US%22%3EOffice%20365%2C%20Sharepoint%20and%20problem%20with%20BCS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-265504%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%20we've%20been%20searching%20around%20for%20this%20%22problem%22%2C%20asking%20uncle%20Google%2C%20but%20didn't%20really%20found%20any%20solutions%20(if%20there%20is%20any%3F).%20In%20our%20company%20we%20are%20using%20Sharepoint%202016%20on-premises%20and%20Office%20365%20ProPlus.%20If%20we%20open%26nbsp%3Ba%20Word%20document%20(with%20Word%20dektop%20app)%20which%20has%20Sharepoint%20fields%20with%20external%20data%2C%20we%20get%20the%20well%20known%20error%20%22In%20order%20to%20pick%20external%20items%20you%20must%20have%20Microsoft%20Business%20Connectivity%20services%20client%20components%20installed%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20to%20%22install%22%20BCS%20in%20Office%20365%3F%20Is%20there%20any%20solution%20at%20all%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3EUros%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-265504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBusiness%20Data%20Connectivity%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-266342%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20365%2C%20Sharepoint%20and%20problem%20with%20BCS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-266342%22%20slang%3D%22en-US%22%3E%3CP%3EHey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F220968%22%20target%3D%22_blank%22%3E%40Uro%C5%A1%20Mrak%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20do%20BCS%20in%20SharePoint%20Online%2FOffice%20365.%20However%20the%20issue%20you%20are%20having%20is%20a%20bit%20different.%20You%20are%20using%20SharePoint%20On-prem%20with%20Office%20365%20pro%20plus%20deployments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20you%20are%20going%20to%20have%20is%20googling%20this%20you%20are%20going%20to%20find%20ways%20to%20turn%20on%20BCS%20on%20sharepoint%20online%2C%20but%20if%20your%20data%20is%20not%20there%2C%20its%20not%20much%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20you%20ultimate%20solution%20would%20be%20a%20hybrid%20BCS%20deployment%2C%20as%20explained%20here%20-%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fhybrid%2Fdeploy-a-business-connectivity-services-hybrid-solution%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fhybrid%2Fdeploy-a-business-connectivity-services-hybrid-solution%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20will%20mean%20surfacing%20data%20into%20SharePoint%20Online%2C%20but%20that%20would%20then%20make%20that%20data%20available%20to%20your%20cloud%20office%20deployments.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAdam%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi there. we've been searching around for this "problem", asking uncle Google, but didn't really found any solutions (if there is any?). In our company we are using Sharepoint 2016 on-premises and Office 365 ProPlus. If we open a Word document (with Word dektop app) which has Sharepoint fields with external data, we get the well known error "In order to pick external items you must have Microsoft Business Connectivity services client components installed".

 

How to "install" BCS in Office 365? Is there any solution at all? 

 

Thank you in advance.

Uros

 

1 Reply
Highlighted
Solution

Hey @Uroš Mrak,

 

You can do BCS in SharePoint Online/Office 365. However the issue you are having is a bit different. You are using SharePoint On-prem with Office 365 pro plus deployments.

 

The problem you are going to have is googling this you are going to find ways to turn on BCS on sharepoint online, but if your data is not there, its not much help.

 

I think you ultimate solution would be a hybrid BCS deployment, as explained here -https://docs.microsoft.com/en-us/sharepoint/hybrid/deploy-a-business-connectivity-services-hybrid-so...

 

This will mean surfacing data into SharePoint Online, but that would then make that data available to your cloud office deployments. 

 

Adam