Q&A BY TAG 'XML'
strip XML tags from a column
answered
19-11-2019 04:23:06 -0500
Hello, I am getting the data to a column as <p><span style="color: black; font-family: arial,sans-serif; font-size: 10pt;">1: Communication with CNF GM Wallice</span></p><p>hdsfgkwlfewfw</p<ul><li>somethin...
Answers:
3
XML file configuration as view
answered
05-11-2019 05:21:16 -0500
We can configure below format of XML as view in denodo <Quote> <XSD_PERSISTID>"PRV123456"</XSD_PERSISTID> <XSD_PERSISNAME>"Srinivas"</XSD_PERSISNAME> <XSD_PERSISADDRESS>""</XSD_PERSISADDRESS> <XSD_POSTCODE&...
Answers:
1
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
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 "" 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
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>...
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