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
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.
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
Is there a download link for the VVM?
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.