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