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
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