SharePoint Blogs / SharePoint University
SharePoint Blogs and SharePoint University - all in one place!
SharePoint And Building Data Portal Applications (spdata) » 7 Ways I Know of to Add Database Data to SharePoint Pages
Need SharePoint Training? Attend a SharePoint Bootcamp!

Please delete cookies related to sharepointblogs.com and sharepointu.com to resolve login issues!

7 Ways I Know of to Add Database Data to SharePoint Pages

Here’s a list of ways to get database data into SharePoint pages.  This is all the ways I can think of but I would welcome input/ideas on ways others have used.  I will discuss most of these in more detail in future posts. 

1.     Business Data Catalog (BDC)  – Usually the one most people think of when considering how to get data into SharePoint (at least for MOSS)

2.     Data Form Web Part – An updated version available since 2003 as the Data View Web Part for those who like to use SP Designer.

3.     Report View Web Part – Comes with the SP Reporting Services Add-In.

4.     Vendor/Application provided web parts – Many major applications have available a web part(s) built specifically for the application.

5.     3rd Party Data Web Parts – Use a generic web part that can tie into any data source and provide a number of unique display options

6.     Forms Server – Use InfoPath.

7.     Build-Your-Own web part – You can always get out Visual Studio!

 

Did I miss some?

 

Posted 01-21-2008 10:59 AM by mikec

Comments

John Thomas wrote re: 7 Ways I Know of to Add Database Data to SharePoint Pages
on 01-21-2008 11:17 AM

On our intranet, several people contribute Excel charts for display.  We set it up for them to publish their charts from within Excel as web pages to a sharepoint site, and then we use the Page Viewer web part to display the multiple charts on the site in an organized way.  It provides a great deal of flexibility as the user can change the charts without worrying about restraints.

Derek wrote re: 7 Ways I Know of to Add Database Data to SharePoint Pages
on 01-21-2008 11:48 AM

Access 2007 has some very good SharePoint features.  You can connect to SharePoint lists, take data offline then re-sync,  and use Access queries to append external data to lists.  And Access has a very good report designer if you need something a little more sophisticated than SharePoint list views.

SharePoint Link Love: 01-27-2008 part six at Virtual Generations wrote SharePoint Link Love: 01-27-2008 part six at Virtual Generations
on 01-27-2008 8:13 AM

Pingback from  SharePoint Link Love: 01-27-2008 part six at  Virtual Generations

SharePoint Link Love: 01-27-2008 part four at Virtual Generations wrote SharePoint Link Love: 01-27-2008 part four at Virtual Generations
on 01-27-2008 8:21 AM

Pingback from  SharePoint Link Love: 01-27-2008 part four at  Virtual Generations

Add a Comment

(required)  
(optional)
(required)  
Remember Me?
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2009 SharePoint Experts, Inc.