Sync a Sql Server Table with a SharePoint list

Question

Is there a way to automatically sync a Sql Server Table with a SharePoint list? (Sql as source and SharePoint as destination).

I tried to connect MS Acces to a SharePoint list as source and seem to work. However now I sould need to sync Sql with Acces... Maybe is there a direct way to link the SharePoint with a Sql DataTable?

Answer 1

You can do this using Business Connectivity Service with an "External List". Here you will find the steps needed. Here you will find more information about External content types.