If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

XML AS A SOURCE!!!

Started by anjidwh.cognos, 28 Jun 2014 11:02:33 AM

Previous topic - Next topic

anjidwh.cognos

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

MFGF

Quote from: anjidwh.cognos 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

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!

davidrobert1

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

cog_ta_user

Is there a download link for the VVM?

MFGF

Quote from: cog_ta_user on 12 Aug 2014 01:10:44 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!