Sharepoint 2007: best practice to put external database data onto web page
I have Sharepoint 2007 site and have to implement filter (comboboxes) for the list of employees stored in external database.
I can develop web part with asp:DropDownList(s), data access library and asp:Repeater stuff, but don't wanna mess with paging and sorting. May be it's better to p开发者_开发知识库opulate standard sharepoint list that will be present under my filters via my DAL ?
How would you implement such a task?
Here are my suggestions:
- SharePoint List Source and Destination - this is a CodePlex project for an SSIS SharePoint adapter. We used it successfully earlier this year for transferring data between SQL Server and SharePoint.
- Custom Timer Job - you could create a SPJobDefinition class that is your own mini-homespun ETL comparing the SharePoint list to the database tables and then making any necessary transfers.
- Business Data Catalog (BDC) - I'm not a fan, but you might have better luck with it.
- SharePoint 2010 - I'm not sure if this is an option, but I'll mention it. The BDC of SharePoint 2007 has grown into Business Connectivity Services (BCS) in SharePoint 2010. I haven't had a chance to play with it yet, but it is supposed to be much improved for accessing external data.
精彩评论