Solved

How can I use SharePoint to talk to a MS SQL Server?

Posted on 2010-11-12
6
525 Views
Last Modified: 2013-11-05
Hi,

I want to use my SharePoint site to talk to a MS SQL Server to do some customized forms.  My users are going to use those forms to view data in the database or submit new entries.

I'm new to the SharePoint, but I don't think this could be very difficult.  Any resource would be appreciated.  Thanks.

Tom
0
Comment
Question by:pisceswzh2010
  • 3
  • 3
6 Comments
 
LVL 16

Expert Comment

by:quihong
ID: 34122516
There are many ways for SharePoint to "talk" to SQL, but it all depends on what you are trying to do exactly.

What version of SharePoint are you using? WSS 3.0, MOSS 2007, SP Foundation or SP 2010? Do you have Enterprise Features (eCALs)?
0
 

Author Comment

by:pisceswzh2010
ID: 34122557
I'm using SP2010.  

I'm not sure what is Enterprise Features (eCALs).

What I want to do is to design a table view of the data in the MS SQL Server and my users are going to be able to read/add/update/delete records in the database using the SharePoint interface.

Thanks.
0
 
LVL 16

Expert Comment

by:quihong
ID: 34122801
Here is more info on the different version of SharePoint - http://sharepoint.microsoft.com/en-us/buy/Pages/Editions-Comparison.aspx

Any reason why you need to use SQL? Is this an existing database that you're trying to tap into from SharePoint?

SharePoint is very good at displaying data from external datasources such as your line of business application, but once you start talking about update/delete it can get complex and will quickly get into custom development.

A few options:

1) Custom Web Parts as a interface to the data
2) Custom Application Pages (basically .NET webapp built on top of SP)
3) Business Connectivity Services
4) If you are license for SharePoint 2010 Enterprise, Access Service.

My recommendation would be to look into BCS (part of SharePoint Foundation). It now has read/write capabilities. If you are licensed for SP Enterprise and the data doesn't need to reside in SQL (and you have Access experience), consider Access Services. If the data doesn't need to be in SQL (not existing database) consider storing the data directly in SharePoint List and using SP natively to edit/update.





0
Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

 

Author Comment

by:pisceswzh2010
ID: 34122893
My SharePoint version is SP2010.

The reason why I want to use SQL server is that SharePoint is really not a good place for data storage.  If we just store data in the SharePoint lists, it might cause us some long term problem as we are experiencing now.  MS SQL Server would provide us with better data import/export features.

For now, I don't think we have the manpower to really do custom development.

Can you provide me with more information about BCS?  Where can I get started?  Thanks.
0
 
LVL 16

Accepted Solution

by:
quihong earned 500 total points
ID: 34123084
Its always a balance...

If you don't want to do custom development, then you're pretty much stuck with native SP List as the "database" and the native SP GUI (or InfoPath) as the front end interface and maybe some workflows/event handlers for business logic.

BCS is going to requirement development work also. Don't want to imply that its not needed.

http://msdn.microsoft.com/en-us/magazine/ee819133.aspx


0
 

Author Closing Comment

by:pisceswzh2010
ID: 34406768
OK
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

I recently came across an issue with a MOSS 2007 deployment where access into some sub-sites were denied, even for the MOSS farm administrators. A bit of background to the setup of this MOSS farm; this was a three server setup, consisting of a fr…
SharePoint Designer 2010 has tools and commands to do everything that can be done with web parts in the browser, and then some – except uploading a web part straight into a page that is edited in SPD. So, can it be done? Scenario For a recent pr…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now