Show SQL query results in Sharepoint

Question

Hi All

I support Rational clearquest for my company and have been asked to show some of the data in Sharepoint.

I can query the data in Clearquest no problem (Using Toad) but have no idea about how to go displaying it in Sharepoint.

The data I'm querying contains dates and ideally I'd like to be able display it in a sharepoint calendar but list format would do for the moment.

Can anybody offer advice on even where to start?

Thanks,

Joe

Answer 1

You would have to develop a sharepoint "feature" such as a webpart. You could then display retrieve the data from the db and display it however you want. You would basically be developing a asp.net component/application but with certain restrictions that sharepoint forces on you. You can read the basic steps here

Answer 2

Whilst you could do the bare bones approach suggested by Ben there are lots of options that will give you a 'leg up' especially if you are just displaying data.

• Your first look should be at SharePoints Data View Web Part (DVWP). There is a length walkthrough here and some great tutorials by Laura Rogers

• Very similar but if you hate SharePoint designer there is Lighting Tools Data Viewer Web Part

• If you are using MOSS you could use the Business Data Catalog (BDC) - Display business data on a SharePoint site

• There are other 3rd party options too that don't require MOSS such as Layer2's Business Data List Connector (BDLC)

• If you have technical resource you could (expanding on approach suggested by Ben) write your own Reusable SQL Data Viewer Web Part