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

How do we synchronize data from an external list (BCS) into a custom SharePoint list? I have tried using a timer job, but it did not help. Any ideas?

share|improve this question
Why did the timer job not help? I've done that in the past in an environment that did not have the BDC or BCS. – Mike Oryszak Nov 12 '11 at 15:49
possible duplicate of SPTimer job and BCS External list – Eric Alexander Dec 9 '11 at 21:40
  1. Create an External Content Type (using sharepoint designer)
  2. go to CA and set up BCS permissions (may want to secure store)
  3. If it's one time load into SP list then create a list based on External list (your bcs connection should show up)
  4. You can then use powershell to populate your target SP list.
share|improve this answer
This would be only a one time deal. I would like to keep the data synchronized items between external and SP list. – vamsy Nov 11 '11 at 18:07
I have been trying to do something similar to Step 4, and get stuck with some extra issues that seem to arise when you try to access an external list via PowerShell. If you (Mary Rivers) have done step 4, an example would be useful. – lwbecker2 Nov 11 '11 at 20:40
Where is the data in the external list coming from and why do you want to duplicate it? What do you mean by sync? Is this a purge then re-import method or is the intention to update existing data and add new? – Robert Kaucher Mar 11 '12 at 2:30

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.