Publishing changes in SQL Application to WSS 1

[mrsnrub]

Hi, this is a bit of general question, I'm hoping for a nudge in the right direction.

We have a wiki type WSS site that we use to publish announcements, basic procedures, etc.
We also have a SQL based help desk application for logging support requests.
I would like to publish certain details of particular help desk items on the WSS site as they are created in the application. I would be looking at publishing data such as description, date requested, etc and only if the item was of a particular category or priority level.

I'm not sure which way to go to start on this, or what methods I should be investigating further.

Can anyone offer any advice on the direction they would take to achieve such a task?

Many thanks.

 

[dinger2121]

You may be able to use the business data catalog with correct filters in place to display the data. here is a link to some information -

http://msdn.microsoft.com/en-us/library/ms563661.aspx

you would also do well to google business data catalog.

You may also be able to develop a custom web part which would query your help desk data and return, filter and present the data as needed.

just a couple of quick thoughts.....

carl
MCSD, MCTS:MOSS

 

[mrsnrub]

Thanks for the input, these are a couple of good places to start.

Cheers.