So I have a client who has arranged for their SharePoint environment to be housed and managed to by an external entity (not my contracting group) and we have limited access to administrative configurations.
The constraint I have is this, any personally identifiable information cannot be housed on the main SharePoint environment. The client was planning on using an internal SQL server and storing all of that data on that SQL.
The issue I am having is the configuration of that, in conjunction with the designing of workflows to write to/read from that external SQL source. I have found some plugins that may enable that, but the client is insistent that we cannot use any of these plugins, and must use what they have on hand.
Is this possible? For workflows to write to/read from a SQL server, as well as call lists from that external SQL. Is this a native capability for SharePoint 2010?