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

SAP Idocs with Denodo
answered 14-08-2019 08:24:51 -0400

hi all, we are connecting Denodo with several SAP systems, receiving master data and transactional data. most of the connections use SAP IDOCs, and as Denodo does not handle IDOCs we have Tibco in the middle as passthrought, converting IDOCs into XML t...

Answers: 1


XML Datasource unable to "Create Base View"
answered 31-07-2019 10:03:39 -0400

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

Answers: 4

XML Baseview end tag

How to get result in array or registered ?
answered 26-06-2019 02:06:07 -0400

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

Answers: 3


XML Data Source : Character reference "&#xB" is an invalid XML character.
answered 24-04-2019 18:09:45 -0400

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

Answers: 1

XML XML Data Source

How to schedule a job to fetch data from an external source (tool) using XML API?
answered 19-02-2019 07:22:45 -0500

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

Answers: 1

Automic scheduler automation XML Denodo Scheduler 7.0 XML Data Source API

How to do error handling on accessing data sources that we do not control + Different REST Web Service formats don't seem to return the same information?
answered 10-01-2019 10:31:48 -0500

Hello! There are two problems, that my team was wondering if there were answers to. The first problem: There are several data sources that we have no control over, and therefore can't tell if those services are live or not. My team was wondering how w...

Answers: 2

denodo platform XML Denodo Testing Tool REST Webservice json HTML Error Handling

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