Doug Ortiz's Blog
Architecture and Development blog postings from technologies ranging from Big Data, Data Science, Cloud, Business Intelligence, SQL and SharePoint
I realize this isn't related to this particular post but I'm hoping you can answer a SharePoint question for me. I am very, very new to SharePoint. So I apologize if this is a dumb question. Using SharePoint Designer 2007, is it possible to execute a SQL Server stored procedure that inserts, updates, or deletes data from tables instead of accessing the tables directly? Thanks!!!
R,Thank you for following the blog; it is not a dumb question in fact it is a great question because it is easily overlooked what can be achieved with SharePoint Designer.The answer to your question is: "Yes, you can!"Although, with the answer there are other questions that should be asked:- Is this something that will happen in more than a single site? If so, using SharePoint Designer might not be the adequate solution to this problem; in this case a custom Web Part would be a better solution providing much more alternatives and options than using SharePoint Designer.- How will solution impact an upgrade to SharePoint 2010?While these are not the only questions that should be asked, these are good starting points aimed to help you reach a well thought out solution not only for the present but for future solutions as well.Regards,Doug Ortiz
Thanks for responding to my question. I'm just a DBA and haven't really been involved in this particular decision-making process for this particular project. I'm glad to know that it is possible to execute insert/update/delete procedures using a web part, even if it's custom. I do know the people involved in this particular project are also looking to possibly use InfoPath with SharePoint. I'm not sure what kind of impact this will have. I will keep your other questions in mind as well. Thanks!!
R,You are welcome, glad to have been able to answer your previous questions.Since you have mentioned that InfoPath is also being considered, I would caution to be extremely aware of how InfoPath works and how it would benefit a project with its use. Mostly because specific tasks do require a significant investment of time and effort.Regards,Doug Ortiz