We are creating a SharePoint based application, client has a data model with about 15 tables with interdependency (reference column). Maximum number of reference columns from a single table may vary from 2-3, one specific table has more than 6-7 reference columns.

Please advice which should be the correct approach, whether to use a SharePoint List with Lookup Columns or use a SQL Database, and use BCS to show it in SharePoint.

I have attached a sample data model image below.

enter image description here

  • Off the cuff, I'd say SQL and surface the data via a view through BCS. There may be a slew of other factors that influence that though based on other features of the system. – Eric Alexander Feb 17 '15 at 13:25

SharePoint is not designed to work with sophisticated data models, either using lists or BCS. SharePoint has about the same capabilities as linked Worksheets in Excel.

That is not to say you can't use this data model in your SharePoint pages and web parts, you'll just have to build custom user interfaces to interface with data instead of using the OOB list UI.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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