Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I'm developing a visualization application on SharePoint Enterprise 2010. This involves doing some SQL queries I would love to expose as external lists in SharePoint. All interfacing with the database which contains the data we want to analyze happens through Business Connectivity Services.

SharePoint designer easily lets you expose a single database table as an external content type/external list. The question is, is there an easy way to create an SQL query involving multiple tables where the result of the query becomes the contents of an external list? I'm pretty sure the third-party BCS Meta Man will let you do this, but is there an easy way to do it directly?

share|improve this question
add comment

1 Answer 1

up vote 5 down vote accepted

SharePoint Designer will also expose any views or stored procedures you have. You can set those up for use in the external contenttype. If you go into the data source explorer in sharepoint designer you will see views and routines in the tree under your database. If you can add a view or a stored procedure in SQL, then it will show up there and you can take it from there to implement readlist, readitem and so on.

share|improve this answer
    
+1 for that, I didn't know SPs and views carried over, that's definately a plus. –  PirateEric May 4 '11 at 18:03
    
Awesome, thanks. –  Geir Smestad May 5 '11 at 7:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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