Home

Connecting on premise SQL to sharepoint online

%3CLINGO-SUB%20id%3D%22lingo-sub-767299%22%20slang%3D%22en-US%22%3EConnecting%20on%20premise%20SQL%20to%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767299%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20display%20data%20from%26nbsp%3Bon%20premise%20SQL%20express%20table%20to%20sharepoint%20online%20list.%20What%20is%20the%20best%20way%20i%20can%20achieve%20the%20things%2C%3C%2FP%3E%3CP%3E1)%26nbsp%3Bon%20premise%20Data%20gateway%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E2)%20BCS%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhich%20on%20will%20suitable%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ESakthi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-767299%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767462%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20on%20premise%20SQL%20to%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767462%22%20slang%3D%22en-US%22%3EIf%20you%20want%20to%20integrate%20in%20your%20SPO%20sites%20as%20a%20list%2C%20your%20only%20choice%20is%20BCS...but%20you%20might%20find%20problems%20because%20BCS%20has%20not%20been%20improved%20by%20Microsoft%20for%20the%20last%20few%20years%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-767600%22%20slang%3D%22en-US%22%3ERe%3A%20Connecting%20on%20premise%20SQL%20to%20sharepoint%20online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-767600%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20information%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F60%22%20target%3D%22_blank%22%3E%40Juan%20Carlos%20Gonz%C3%A1lez%20Mart%C3%ADn%3C%2FA%3E%26nbsp%3B.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20that%20possible%20to%20use%20on%20premises%20data%20gateway%20for%20my%20case.%20If%2C%26nbsp%3B%20yes%20how%20could%20i%20start.%3C%2FP%3E%3CP%3EAny%20alternate%20solution%20there%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3ESakthi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Sakthisp
New Contributor

Hello,

 

I want to display data from on premise SQL express table to sharepoint online list. What is the best way i can achieve the things,

1) on premise Data gateway  

2) BCS

 

Which on will suitable for me.

 

Thanks,

Sakthi

2 Replies
If you want to integrate in your SPO sites as a list, your only choice is BCS...but you might find problems because BCS has not been improved by Microsoft for the last few years

Thanks for the information @Juan Carlos González Martín .

 

is that possible to use on premises data gateway for my case. If,  yes how could i start.

Any alternate solution there?

 

Thanks,

Sakthi

 

Related Conversations
Extentions Synchronization
ChirmyRam in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies