Custom forms in Sharepoint with MS SQL Server as Backend. Is it possible?
- by Kaan
We're evaluating using SharePoint 2010 as our project management tool.
Specifically, the system needs to satisfy the following:
Discussion groups
Project management (simple issue tracking, no complex workflows or vcs integrations)
News feed for the project(s)
File sharing based on authorization/user-roles
Custom homepage
Custom forms using MS SQL Server as a backend and contents of old forms searchable from the user interface.
Now, I think [1-5] is possible using SharePoint (Comments are always welcome :)). I'm not sure about [6]. Is it possible? For instance, can an admin or a user of the SharePoint portal, create a custom form (without any programming) that uses MS SQL Server as a backend and publish it to the portal so that other users can also perform data entry?
If it can be done (be it with or without some programming), can users perform text search on form data using the SharePoint interface?