0

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

Improve this question

1 Answer 1

Reset to default
0

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/

Improve this answer
0

Your Answer

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

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