Q&A

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

JBDC Drive loading issues
asked 22-04-2021 14:51:17 -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: 0

'[Unexpected error creating a connection: Pool not open]' - Scheduling VPDcache job
answered 22-04-2021 11:09:45 -0400

I am scehuling the VDPcache job, I can select the datasource, views to be cache from the denodo db. I have added two views by choosing load process for each one as 'Non-incremental' . While manually started the job it end up with error '[Unexpected err...

Answers: 4

About Scheduler Administration Tool
answered 22-04-2021 10:47:51 -0400

two questions about denodo Scheduler tool: does denodo Schedule tool can call shell script job or python script job Does only the administrator of VDP has the access/write right for tool Scheduler Administration?

Answers: 2

Denodo Scheduler 7.0

After enabling HTTPS can't connecto to virtual data port server nor webtools
answered 22-04-2021 08:11:21 -0400

Hello, I was doing the exercise of the DEN80EDU13DS05 module to enable the HTTPS in tomcat.properties and server.xml and did everything as was shown. But after I start the servers VDP server can be started, but it does not connect to server. It says i...

Answers: 1

HTTPS WEB design Studio Web Service

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

Denodo dialect for python
asked 21-04-2021 17:58:11 -0400

Hi, I downloaded the denodo dialect for python connexion to use with sqlAlchemy on the support site. (Denodo Dialect for SQLAlchemy). I tried to add the dialect like I was told in this article : https://community.denodo.com/docs/html/document/denodoco...

Answers: 0

python dialect