Q&A

denodo testing with nested complex structure
answered 27-04-2021 06:34:00 -0400

Hi, I am trying to test some complex structure. Suppose I have the following view: tech_data Array and Array is: measurements weights additional Register Register R...

Answers: 1

Denodo 7.0 Denodo Testing Tool complex array

Denodo Solution Manager installation
answered 26-04-2021 15:07:45 -0400

Assuming, I have 3 enivronments Development, UAT and Production. I would like to know if we need to install the Solution Manager in all the 3 environments (of course on a separate machine than the Denodo Platform) or we just need to have one Solution M...

Answers: 1

Wrapper name cannot be updated when changing the base view name
answered 26-04-2021 08:26:58 -0400

Hi Team, We understandm when we create a base view, Denodo will get the wrapper created firstly and then the base view created on the basis of wrapper. And the wrapper name has the same name as the base view. However we found this case, after we create...

Answers: 1

base view name update wrapper name

Establish SSL connection to Denodo from MATLAB
answered 26-04-2021 07:59:51 -0400

I am trying to connect to Denodo virtualization layer via MATLAB and am getting the following error: "JDBC Driver Error: connection error: Cannot trust the server to establish a SSL connection." I have a SSL certificate for the Denodo connection that...

Answers: 1

SSL MATLAB

Unable to launch Denodo Express on port //localhost:9999/admin
answered 23-04-2021 18:12:49 -0400

I have installed Denodo Express and tried launching but an getting the error message "Connection error: check the host name and port number are correct and that client and server belong to the same Denodo major version. Connection refused. No further i...

Answers: 1

JBDC Drive loading issues
answered 23-04-2021 16:12:36 -0400

We are getting this issue while creating new JDBC data resorces from weblogic console. Message icon - Error Connection test failed. Message icon - Error Cannot load driver: com.denodo.vdp.jdbc.Driver

Answers: 1

outer join with filter on the outer table.
answered 23-04-2021 01:31:25 -0400

I am facing a situation in Denodo where it does not support a scenario with outer join and filter on outer table. if we dont have a lookup value on the outer join table along with filter on the outer table how to retrive the data. In Oracle I will ...

Answers: 1

outer joins

Json-HTTP client as data source
answered 22-04-2021 18:44:08 -0400

I am trying to confugure Json (HTTP client) as datasource in Denodo . Where do I give the Authorization token access like Bearer <> . Has any body tried this datasource configuration

Answers: 1

Access to data sources on S3
answered 21-04-2021 23:41:07 -0400

Hi. Several days ago I started to test Denodo Standard 8.0 (free trial) for learning yours platform on AWS. And now when I try to connect S3 file system for my test cluster I have such problems (https://community.denodo.com/kb/view/document/How%20to%20...

Answers: 1

AWS S3

Reply to my another question - How to use 3 parameters in 'instr' function?
answered 21-04-2021 21:01:42 -0400

Hi DENODO Team, I need to read the given string in reverse order ( from reverse position). STRING: ‘abcd-E3/FGHIJ:KL-MNOP-QRST’ As per your last reply answer, I will get the 1st position of symbol ‘-‘, which is 4 SELECT INSTR(SUBSTR(‘abcd-E3/FGHIJ:...

Answers: 1

INSTR