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

Suppose I have multiple instances of some line of business app in my environment. Is there a way to create a single External Content Type that can be parametrized and reused? If I have 5 instances, is it necessary to create 5 external lists and 5 external content types, or can the lists indicate which data source should be used?

share|improve this question
can you give an example (in business terms) of how these content types would be parameterized? – Derek Gusoff Sep 12 '12 at 14:09
Can I have a single Extenal Content Type called 'customer' when the California customers are in a db on one server and the New York customers are in another? Can the target of a ECT be parameterized as long as the schema is identical? – Jeff Sacksteder Sep 13 '12 at 12:29
oh, I get it - same schema, different database connections. That's a great question. I would probably just create the separate ECTs, but I'd be interested to hear if there is a solution out there. – Derek Gusoff Sep 13 '12 at 23:55

I think the best approach in this case would be to do the CRUD routing at the web-service/stored procedure level.

Alternatively you could write the models in Visual Studio and build logic into the CRUD methods to determine where the record should end up.

Depends where you feel more comfortable placing your business logic, if this is going to be common practice then I would say webservice.

share|improve this answer

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.