0

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.

Thanks,

Rishabh

Improve this question

1 Answer 1

Reset to default
1

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/

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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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