My organisation has got a SQL Server database that contains all employee information. I want to use that information inside of SharePoint, for example by creating a Lookup field that shows all employees from the SQL Server database.
I wonder how to go about that?
a) Do I somehow need to synchronise the content of the SQL Server database with a SharePoint list (effectively creating a copy of the Data inside of SharePoint)?
b) Can I create a Lookup field that gets data from an external Source (custom SQL Server database)?
I have got MOSS, so I wonder if the Business Data Catalog does something like this, but so far I couldn't figure out how. All I seem to be able to do is display data from SQL Server as a Data View, which is all nice but doesn't really give me what I need.
Thanks for the info.
View Complete Post