x
login about faq Site discussion (meta-askssc)

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
112 4 4 6

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

0 answers: sort oldest
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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x1612
x116
x2

asked: Oct 18 '11 at 08:30 AM

Seen: 637 times

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

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.