I need to provide list data to an external system. Once the data has been accessed, we need to write a flag to the list as accessed.
The external system will probably be another SQL Server query. This query will grab info from sharepoint and other systems, and feed it to a dialler.
For the external SQL to access and write to the list on SharePoint I was thinking of providing access directly to the SharePoint SQL server. I've heard this is a bad idea, even for Read access. Could someone confirm this?
The other option is to use webservices, or a read-built SQL connector. I found this but dont know if it will work. http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652
Using SharePoint Standard Edition. But options for enterprise welcome.
Any advise welcome.