Latest Activity


XML Datasource unable to "Create Base View"

Followed the following: Created & Saved XML datasource with "GET" method for external "HTTP Client" url, with Proxy as "Default" and Authentication as "Basic" and provided correct userID and Password. I am able to Save and do test connection succes...

XML Baseview end tag


How to get result in array or registered ?

SELECT xpath ( cast ('xml', '<?xml version="1.0" encoding="ISO-8859-1"?> <a> <b>Hello</b> <b>World</b> </a>' ) , '/a/b/text()', false) as xpath_results FROM Dual(); The result is xpath_results HelloWorld ...



XML Data Source : Character reference "&#xB" is an invalid XML character.

Hi, I'm using v7.0 20181011. Attemting to create a base view from an XML data source, I'm getting the error "Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Character reference " " is an invalid XML character....

XML XML Data Source


How to schedule a job to fetch data from an external source (tool) using XML API?

Can you please step down the process on how to schedule an XML API to fetch data from an external source(tool)?

Automic scheduler automation XML XML Data Source Denodo Scheduler 7.0 API


In my Derived view there is one field message. it's return value in XML. How do I get some field from there?

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...



XML Data in BLOB into Columns

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?

XML XML Data Source derive


Issue type casting BLOB to XML Data Columns

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...



xpath function is not working as expected in Denodo

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



source file info

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:

Excel XML Delimited Files


Unable to import XML file .

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...

Excel XML CSV XML Data Source JSON