I am trying to connect to external SQL database and want to show up select query data in SharePoint list. I did create External Content Type but that doesn't allow me to use custom query for the table. I know there are some third party tool. I was wondering is there any easier way of doing this.




It would be best to create a SQL table view and then connect to it via BCS (this will require use of SharePoint Designer). Business Data Connectivity Service needs to be created in Central Administration.

There is an extensive article on this here: http://prairiedeveloper.com/2016/01/sharepoint-business-connectivity-service-create-external-content-type-and-external-list/

  • 1
    Thanks Paul, I think creating view would be best option. As I don't want third party web part to use. – Rishabh Shukla Sep 13 '16 at 15:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.