Author Topic: XML AS A SOURCE!!!  (Read 2233 times)

Offline anjidwh.cognos

  • Full Member
  • ***
  • Join Date: Oct 2013
  • Posts: 44
  • Forum Citizenship: +0/-0
XML AS A SOURCE!!!
« on: 28 Jun 2014 11:02:33 am »
Hi Folks,

Can we read xml file using with SQLTEXT designer. I tried to load it but its throwing an error for me. Can anybody suggest how to get this done.

Appreciated your help!!!

Thanks,
SRK

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,891
  • Forum Citizenship: +648/-10
  • Cognos Software Muppet
Re: XML AS A SOURCE!!!
« Reply #1 on: 10 Jul 2014 09:57:39 am »
Hi Folks,

Can we read xml file using with SQLTEXT designer. I tried to load it but its throwing an error for me. Can anybody suggest how to get this done.

Appreciated your help!!!

Thanks,
SRK

Not with SQLText Designer, no. There is no inherent XML input directly into Data Manager - the best approaches are either to consume the XML in your database and present it as tables Data Manager can read, or else to connect to the XML document from Cognos 10 BI and use this Cognos data source as a source in DM.

To add a little more detail to the first option above, someone much wiser than me once wrote:

Database vendors allow you to use SQL/XML which essentially includes syntax to query and extract information that can be consumed as standard SQL datatypes. There is no intrinsic support of the SQL-XML type nor automatic generation of SQL that emits the SQL/XML functions on your behalf in Data Manager and there is no local execution support of the aforementioned SQL/XML functions.
 
In short, you will have to hand write the SQL statements in your chosen database and consider how to expose the XML document/fragment as a tabular representation.


Cheers!

MF.
Meep!

Offline davidrobert1

  • Associate
  • **
  • Join Date: Sep 2010
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: XML AS A SOURCE!!!
« Reply #2 on: 05 Aug 2014 08:24:49 am »
Hello,

For XML  and Web Service we use Cognos Virtual view manager that transform any xml /webservice into SQL and data manager connect via ODBC to virtual view manager to get the data

Rgds

David

Offline cog_ta_user

  • Associate
  • **
  • Join Date: Jul 2014
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: XML AS A SOURCE!!!
« Reply #3 on: 12 Aug 2014 01:10:44 am »
Is there a download link for the VVM?

Offline MFGF

  • Never knowingly correct
  • Super Moderator
  • Statesman
  • ******
  • Join Date: Jul 2005
  • Posts: 10,891
  • Forum Citizenship: +648/-10
  • Cognos Software Muppet
Re: XML AS A SOURCE!!!
« Reply #4 on: 12 Aug 2014 04:09:42 am »
Is there a download link for the VVM?

All downloads of IBM software are via the Passport Advantage site. Details of how to connect and log in are here:

http://www-01.ibm.com/support/docview.wss?uid=swg21622147

Cheers!

MF.
Meep!

 


       
Twittear