synchronize data from external list and SPList

Question

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?

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.

Mary Rivers · Answer 1 · 2011-11-11 17:05:58Z

up vote 0 down vote

Create an External Content Type (using sharepoint designer)
go to CA and set up BCS permissions (may want to secure store)
If it's one time load into SP list then create a list based on External list (your bcs connection should show up)
You can then use powershell to populate your target SP list.

answered Nov 11 '11 at 17:05

Mary Rivers
328310

	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

1 Answer