I'm thinking of a solution to separate sensitive data from Sharepoint to a secure SQL server. On Sharepoint each user only sees what he/she is supposed to see, the same goes for the SQL Server (I'm not sure yet whether I will have a separate "user"
column, or regular permissions). In Sharepoint the user would only see some descriptive name (and the record would have a GUID) - when clicking on it, data from the SQL Server is loaded.
Basically I will be importing some data and there will be an approval workflow for each record (being assigned to a particular employee) including some kind of approval form per record.
I have two solutions so far:
- A Forms Library with an Infopath Form aggregating the data from the Library as well as the SQL Server via a GUID stored in both. This works well, but Infopath uses either a hardcoded technical user to get to the SQL server or the logged in windows user.
- Use an external Content Type to "import" (rather link) the data from the SQL server into an external list. In a Forms Library I could have the Infopath Forms with a connection to this external list.
I have a question for each:
- (1) If I would want to have a dynamic connection string to the SQL Server (so to speak
SELECT * FROM xxx WHERE USER = dynamic ) - how would I do that? All I ca
View Complete Post