Show SQL query results in Sharepoint

Posted by JoeOD on Stack Overflow See other posts from Stack Overflow or by JoeOD
Published on 2010-05-13T18:28:51Z Indexed on 2010/05/13 21:44 UTC
Read the original article Hit count: 538

Filed under:

sharepoint

|

clearquest

|

sql

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

© Stack Overflow or respective owner

Related posts about sharepoint

SharePoint 2010 MSDN Labs

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Eric Ligman, from Microsoft, posted a great blog post this week listing all of the SharePoint 2010 Virtual Labs that are available from Microsoft. His blog entry is here: http://blogs.msdn.com/b/mssmallbiz/archive/2012/03/13/sharepoint-server-2010-msdn-virtual-labs-available-to-you-online-plus-more-sharepoint-2010-resources… >>> More
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hos

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
Enterprise SharePoint 2010 Hosting, SharePoint Foundation 2010 Hosting, SharePoint Standard 2010 Hosting, Michigan Sclera, a Microsoft Hosted Services Provider Partner, is offering key Service Offerings around the Microsoft SharePoint Server 2010 stack. Specifically – if you’re looking for SharePoint… >>> More
SharePoint Personalization Site Links - Les liens personnalis?s des MySite SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Nous avons vu dans les articles pr?c?dents comment agr?menter les pages de recherche afin de permettre une meilleure adoption du produit par les utilisateurs. Il existe une autre fonctionnalit? de Microsoft Office SharePoint Server 2007 (MOSS) qui permet aussi de personnaliser un peu le MySite des… >>> More
Auditer une ferme SharePoint - Assurer le bon fonctionnement de SharePoint

as seen on ASP-PHP.net - Search for 'ASP-PHP.net'
Dans le cadre de la bonne gestion de son environnement SharePoint, il est utile de faire un contr?le de son installation afin d'assurer le bon fonctionnement des fermes et donc, la meilleure disponibilit? pour les usagers. Dans ce but, nous verrons comment auditer sa ferme facilement et les traitements… >>> More
Using jQuery and SPServices to Display List Items

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
I had an interesting challenge recently that I turned to Marc Anderson’s wonderful SPServices project for. If you haven’t already seen or used SPServices, please do. It’s a jQuery library that does primarily two things. First, it wraps up all of the SharePoint web services in a nice little AJAX wrapper… >>> More

Related posts about clearquest

Clearquest Database Timeout

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a tool that is setup to query our Clearquest Database to return information to the user automatically every 9000 milliseconds. I came in today and the connection had timed out over the weekend, I found in the oSession object a "check heartbeat" function, but I'm not sure that is what I want… >>> More
TFS Integration with Rational ClearQuest and Requirement Manager

as seen on Stack Overflow - Search for 'Stack Overflow'
I am working on an integration approach for integrating Rationa (IBM Jazz) Requirement Manager (RM) and Clear Quest (CQ) with TFS. As the teams are moving from ClearCase to TFS, what we are looking at is still being able to manage the requirements in RM and manage testing using CQ. The flow will… >>> More
Show SQL query results in Sharepoint

as seen on Stack Overflow - Search for 'Stack Overflow'
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… >>> More
Birt 2.5.2 report generates empty table data when run from a cron job

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a shell script that runs genReport.sh in order to create a .pdf formatted report, and it works perfectly when it's run from the command line. The data source for the report is a ClearQuest database. When it's run from a CRON job the .pdf file is created, except that only the various report… >>> More
How to manage two separate testing teams using different test tracking tools

as seen on Super User - Search for 'Super User'
I have two independent testing teams currently testing the same application. One team is using ClearQuest, and the other is using Mantis. It has been a huge effort to manage all of the duplicate reported bugs. What options would improve this situation? My constraint is that the ClearQuest team will… >>> More