How can I create a SharePoint List with a connection to a SQL Database, where i can write my own query to retrieve data from different tables ? (ie. from a star schema)

I checked with 'external content type' in SP Designer, but there i can choose just one table ?!

Or are there any other solutions to populate custom data in a SP List from a database ?

I am working with SP2013 Enterpise

1 Answer 1


All of the info you need is located here:

How to: Create external content types for SQL Server in SharePoint 2013 https://msdn.microsoft.com/en-us/library/office/jj220063.aspx

Select a table, view, or routine:

In the Data Source Explorer, expand the database to view the tables, views, and routines that it contains. Select a table, view, or routine.

Another resource: http://lightningtools.com/bcs/creating-an-external-content-type-with-sharepoint-designer-2013/


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.