Q&A

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

How to use 3 parameters in 'instr' function
answered 21-04-2021 20:59:08 -0400

SELECT * FROM <view_name> where instr(<column_name>,'|', 2); Like from which position we need to search the given character.

Answers: 3

instr function

Get all JSON results from restful webservice
answered 21-04-2021 07:22:54 -0400

I have the following URL that is return JSON format for one of my views: http://mycompany:9090/denodo-restfulws/hcc_dv/views/mytestview/?$format=JSON However, it only returns the first 25 rows. I have tried every conceivable varitation to get all 150 ...

Answers: 1

pagination json REST Webservice

Apache Zeppelin for Denodo - Shared Server - Not found
answered 20-04-2021 19:20:29 -0400

Hi, Need help to install Zeppelin. I followed the Denodo documentation. But the link to download Denodo Apache Zeppelin on this page is not working. Are we supposed to install only from Denodo site to get the interpretor ? https://community.denodo.com...

Answers: 3

Zeppelin