I need to display the results of a SQL query within SharePoint 2013. I have written the query, which is saved as a view within SSMS however can't see an obvious way to simply display the results, formatted as a table, within SharePoint.

I appreciate that I will need to define data connections to the SQL Server instance, however once that is in place I can't see an obvious way of adding the results.

I would appreciate any advice on how to achieve this - should I be using Reporting Services or can this be done natively within SharePoint with a web part (I assume that it can)?

1 Answer 1


You can use Business Connectivity Services to gather the data from SQL-Server. You can check the following link for detailed inforamtion about BCS: Business Connectivity Services in SharePoint 2013

  • Thanks, it took a while as authentication wasn't working but once that was fixed your link sent me in the right direction.
    – Steve
    Commented Aug 15, 2014 at 10:37

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.