Using Cognos to query XML in a SQL Server 2008 database

Our management uses Cognos and would like to query our SQL Server 2008 database which is storing data as XML. Can anyone help me with a process, tool or method that can be used to achieve the results. It is unclear as to whether they want to format it for reporting as part of the process or just read the data from the XML.

Any assistance with this would be gratefully accepted.
more ▼

asked Oct 18, 2011 at 08:30 AM in Default

Bugmesh gravatar image

162 8 10 11

(comments are locked)
10|1200 characters needed characters left

0 answers: sort newest
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 18, 2011 at 08:30 AM

Seen: 950 times

Last Updated: Oct 18, 2011 at 08:30 AM