Show SQL Query Results in Sharepoint

Question

Show SQL Query Results in Sharepoint

I maintain a Rational clearquest for my company and was prompted to show some data in Sharepoint.

I can query Clearquest for data without issue (using Toad), but have no idea how to show it in Sharepoint.

The queries I am requesting contain dates, and ideally I would like to display them in a sharepoint calendar, but the list format will be valid for now.

Anyone have any advice on even where to start?

Thanks,

Joe

+2

sql sharepoint clearquest

JoeOD May 13 '10 at 18:28

a source to share

2 answers

You would need to develop a sharepoint feature like a web part. Then you can display data from db and display it however you want. Basically you are developing asp.net component / application, but with certain restrictions that apply to you. You can read the basic steps here

+1

Ben robinson May 13 '10 at 18:57

a source to share

Ryan · Accepted Answer · 2010-05-13T21:38:46+0000

While you can do the bare bones approach suggested by Ben, there are many options that will give you a leg up, especially if you're just showing data.

Your first glance should be in the SharePoint Data Viewer Web Part (DVWP). There is a walkthrough here and some great tutorials from Laura Rogers
Very similar, but if you hate SharePoint Designer, Lighting Tools Data Viewer Web Part
If you are using MOSS, you can use Business Data Catalog (BDC) - Display Business Data on SharePoint Site
There are other third party options that do not require MOSS, such as Layer2 Business Data List Connector (BDLC)
If you have a technical resource that you could (expanding on the approach suggested by Ben) write your own Recurring SQL Data Viewer Web Part

Show SQL Query Results in Sharepoint

More articles: