SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a customer with a customer database which represent projects. The DB only manage approved projects.

I'm working on an application than have to works with project in both early stages (project proposition) and approved projects. The data structure is nearly identical, only few fields will changes, and the status.

I cannot change the project database, but my SharePoint app have to transparently link project proposition and approved project in a unique way, with a higher container (a plan, which is composed with projects).

In a ideal way, the user should manager in the same GUI both kind of projects. Project proposition, in a standard read-write-collaborate sharepoint way, and approved project (read-only, as it should be managed in the legacy projects management).

A project proposition can also be approved eventually. In this case, the project proposition item has to be pushed to the project database, keeping the link for the user perspective (it will probably be a new object).

How should I implement such requirement ?

FYI The target platform is SP 2010 Enterprise, self hosted.

share|improve this question
up vote 0 down vote accepted

Yuo can create external columns and external lists with BCS to wrap your database and employ them in conjunction with standard SharePoint lists for new types of objects. You can manage what data will be readonly or CRUD-enabled.

share|improve this answer
yes, but the question goes beyond the database link. I'm especially wonderning how to deal with same type of data, sometimes "local", sometimes "external", keeping a single management perspective for users... – Steve B Feb 12 '12 at 8:42
Can you provide more details on requirements? Can you simply create two identical content types one of which is external and add them to the same list? – Alex Boev Feb 12 '12 at 11:13

Your Answer


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.