Home Page Link
  Skip Navigation Links
Log in to create posts To create new posts or to reply to existing ones, you must be registered and logged in!
  
View: 
Post
Started: 11/13/2009 12:04 PM
Picture Placeholder: Chester Thomas
Chester Thomas
Show SQL data in SharePoint list
Hi all,
 
I have a SQL view that I would like to show as a sharepoint list. Does anyone have a smart way to do this? Would BDC be the only way? I am trying to use a solution for MOSS that will work with  standard edition as well.
 
Also I tried Application definition designer and it bombs out without a specific error when I try and add a LOB - I can provide specific details if anyone can help.
 
Chester
Posted: 11/18/2009 3:30 PM
Picture Placeholder: Francois Pienaar
Francois Pienaar
Hi Chester,
 
I suggest the BDC and BI type web parts, but they are part of the eCal components.  Here is a comparison between the various versions of the product:  http://office.microsoft.com/en-us/sharepointserver/HA101978031033.aspx
 
Have you tried to write your own web part?
 
Regards,
Francois P
Edited: 12/23/2009 10:11 AM
Picture Placeholder: Kevin Coetzee
Kevin Coetzee
Hi Chester

It is possible to display data from an SQL database in both WSS 3.0 and MOSS 2007 without coding. To display data you need to open a list with SharePoint Designer, add a Data View to the list, define a connection to the SQL database, and the query the data with a SELECT statement.

With SharePoint Designer you can do SELECT, INSERT, UPDATE, and DELETE statements, which allows you to make some quite useful applicaions in WSS or MOSS.

Microsoft has this guide for adding db connections: http://office.microsoft.com/en-us/sharepointdesigner/HA101009081033.aspx

Otherwise..
1) Open SharePoint Designer
2) Open the correct site and navigate to the list where you want to show the data
3) Doubleclick the view name (e.g. AllItems.aspx)
4) Click on the view then click 'Insert' -> 'SharePoint Controls' -> 'Data View'
5) In the 'Data Source Library' window select 'Database Connections' -> 'Connect to a database'
6) Follow the Wizard, click save and the data is returned to the view.


Alternatively, Bamboo Solutions has a web part that will create sql views from lists for you. You can download a trial version and try it out. http://store.bamboosolutions.com/pc-30-1-sql-view-web-part-release-12.aspx
Hope this gives you alternate options
Posted: 1/8/2010 9:23 AM
Picture Placeholder: Chester Thomas
Chester Thomas
Thanks this helped. I also ended up creating my own webpart which talks to the SQL database. I can share it with anyone who wants it.
Feedback