x

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 '11 at 08:30 AM in Default

Bugmesh gravatar image

Bugmesh
132 5 6 8

(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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1816
x136
x2

asked: Oct 18 '11 at 08:30 AM

Seen: 833 times

Last Updated: Oct 18 '11 at 08:30 AM