Q&A BY TAG 'XML'
create views over xml columns denodo
answered
06-04-2020 13:35:27 -0400
can I create views over xml columns , as I have view contain colum xml record and I have multiple rows .. so I need to create view to list xml records (as columns)
Answers:
1
create base view for xml record from json file
answered
06-04-2020 12:05:31 -0400
Please i want to ask how i can create base view for spcific key at JSON obect file , which means I import json object from json file and this file contain key which it's value xml .. i need to create base view for this xml key
Answers:
1
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 XML Data Source Denodo Scheduler 7.0 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