I'm starting a new SharePoint 2010 web content management project where a portion of the site's content is driven by an external system (SQL Server based). Think employee bios... The external system is the system of record for this data, we need to expose it (read only) in publishing pages on the site - for each record, we want to create a publishing page.
I've done some research but haven't come across examples of using BCS and ECTs in publishing sites. Considering this approach and hoping to get some feedback on it from the community:
- Create External Content Type to represent the data in the external system
- Use an item event receiver to create a publishing page for new records
- The item event receiver might also update a term store for tagging use elsewhere
- The publishing page layout would be based on the external content type
I'm concerned that one ore more of the above things might not even be possible with External Content Types - or have serious limitations.
Would appreciate any thoughts on this approach vs. directly accessing SQL from web parts on a publishing page based on a query string parameter.