We have a need for end users to see documents with additional 'live' columns, i.e. I would like to show a view of documents with employee id JOINED with data from sql server (for some additional columns).
The system is primarily document based but in the views that the users see I want to show a typical document list (from SharePoint with checkin/out functionality, open/edit etc.), along with columns from SQL Server related to employee.
How should this be done?