SharePoint Online Custom Search on OnPrem SQL Server

%3CLINGO-SUB%20id%3D%22lingo-sub-2367394%22%20slang%3D%22en-US%22%3ESharePoint%20Online%20Custom%20Search%20on%20OnPrem%20SQL%20Server%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2367394%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewithin%20our%20SharePoint%202016%20on%20prem%20environment%20we%20connected%20local%20SQL%20servers%20via%20BCS%20then%20added%20a%20search%20content%20source%20for%20that%20and%20used%20custom%20search%20templates%20to%20visualize%20this%20SQL%20data%20in%20SharePoint%20search.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERecently%20Microsoft%20provided%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D2eOazbV2qLI%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EPnP%20Search%20Web%20Parts%20Version%204.0%3C%2FA%3E%20after%20they%20showed%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DSG3ngNXGUX8%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehow%20to%20use%20custom%20search%20in%20SharePoint%20Online%3C%2FA%3E%26nbsp%3Bin%202020.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20it%20is%20possible%20to%20use%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DGRwqvobkRHQ%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EBCS%20with%20Azure%20SQL%20in%20SPO%3C%2FA%3E%20as%20well%2C%20I%20see%20a%20way%20how%20to%20show%20SQL%20based%20data%20in%20modern%20SharePoint%20sites.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EAs%20the%20data%20I%20want%20to%20use%20in%20on%20prem%20and%20I%20have%20no%20chance%20of%20getting%20them%20to%20Azure%20I%20wonder%20if%20it%20was%20possible%20to%20connect%20External%20Content%20Type%20in%20SharePoint%20Online%20to%20local%20SQL%20over%20the%20%22%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fpower-bi%2Fconnect-data%2Fservice-gateway-onprem%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EOn%20Premises%20Data%20Gateway%3C%2FA%3E%22%20that%20Power%20Bi%20and%20Power%20Apps%20use%20easily.%26nbsp%3B%26nbsp%3B%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EOr%20do%20you%20see%20another%20way%20of%20getting%20lots%20of%20local%20SQL%20data%20to%20be%20shown%20in%20modern%20SharePoint%20Search%3F%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20be%20pleased%20to%20hear%20your%20opinion%20about%20how%20to%20do%20that%20or%20if%20it%20was%20possible.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance!%3C%2FP%3E%3CP%3EPhilipp%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2367394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

Hi, 

 

within our SharePoint 2016 on prem environment we connected local SQL servers via BCS then added a search content source for that and used custom search templates to visualize this SQL data in SharePoint search. 

 

Recently Microsoft provided PnP Search Web Parts Version 4.0 after they showed how to use custom search in SharePoint Online in 2020. 

 

As it is possible to use BCS with Azure SQL in SPO as well, I see a way how to show SQL based data in modern SharePoint sites. 

 

As the data I want to use in on prem and I have no chance of getting them to Azure I wonder if it was possible to connect External Content Type in SharePoint Online to local SQL over the "On Premises Data Gateway" that Power Bi and Power Apps use easily.  

 

Or do you see another way of getting lots of local SQL data to be shown in modern SharePoint Search?

 

Would be pleased to hear your opinion about how to do that or if it was possible. 

 

Thanks in advance!

Philipp

0 Replies