You must sign in to ask a question. If you do not have an account, you can register here

In my Derived view there is one field message. it's return value in XML. How do I get some field from there?
answered 08-11-2018 06:32:44 -0500

In my message field I got ><ns2:ResponseDateTime>2018-09-20T14:10:26.607-04:00</ns2:ResponseDateTime>><ServiceName>test</ServiceName><ServiceRequestDateTime>2018-09-20T14:10:26.508-04:00</ServiceRequestDateTime&gt...

Answers: 3


XML Data in BLOB into Columns
answered 01-10-2018 11:00:24 -0400

A base view created from Oracle has a column of BLOB Data Type. This column has XML stored. How can I extract data out from XML. How Can I convert the XML data from BLOB field into Adject columns in the Derived View?

Answers: 3

XML XML Data Source derive

Issue type casting BLOB to XML Data Columns
answered 01-10-2018 10:45:55 -0400

Hi , I am trying to extract the XML data from Blob column in oracle database. I was refreing the below solution to convert blob to XML data. but still I am getting the error. ‘cast($1 as $0) -> Cast to xml not supported in Oracle’. XML Data in B...

Answers: 1


xpath function is not working as expected in Denodo
answered 26-09-2018 19:20:25 -0400

SELECT xpath ( cast ('xml' , '<Entries> <ChargebackClaim DebitMemoRefNum="61186134101">123 </ChargebackClaim> </Entries>' ) , '/Entries/ChargebackClaim/@DebitMemoRefNum/text()', true) as xpath_results FROM Dual(); I am getting...

Answers: 2


source file info
answered 07-08-2018 15:14:16 -0400

Hi, I found some interesting predefined stored procedures here, but as far as I've seen, they don't deliver output I'm looking for: https://community.denodo.com/docs/html/browse/6.0/vdp/vql/stored_procedures/predefined_stored_procedures/predefined_sto...

Answers: 3

Excel XML Delimited Files

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Answers: 1

Excel XML CSV XML Data Source JSON

File Generation
answered 22-11-2017 08:09:14 -0500

I need to publish a Flat and XML file to Unix server. I have already created views as required. Is it possible to create a job to publish data in an given external location ?

Answers: 1

XML Delimited Files

Creating an XML output view using the existing base/derived Views
answered 01-09-2017 09:29:26 -0400

How to Create an XML output using derived view ? for example: I have 3 base view Party, Party Address, Party Related Party. I will need to create an XML output, which needs to be published as SOAP Service. the structure should as below. <PartyServi...

Answers: 1

XML DENODO XML Data Source derived view XML request to response

Flatten a register in XML
answered 14-04-2017 13:00:07 -0400

Hi team! I have a couple of XML files with a register in it. These are orderfiles from different sources, so they use different names for fields. I'd like to make a new virtual generic table (ordertable) with these XML files, but it seems I can't fl...

Answers: 1

Register XML

xml data structure in database source
answered 30-05-2016 07:10:51 -0400

HI, I have data in a database which is stored in a XML structure. The data can be accessed as database fields with a JDBC connection. I would like to acces the data as some kind of XML datasource in order to flatten the elements as fields in a table. I...

Answers: 1