Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Protocol to connect Denodo Scheduler from a third party
answered 27-09-2017 04:31:29 -0400

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

Answers: 4

DENODO Denodo Scheduler 6.0

Denodo Monitor log
answered 26-09-2017 09:40:38 -0400

Hi Team, It is possible to get a monitor log,VDP-threads.log,VDP-resource.log for the particular date if the log is not available for that date. Thanks

Answers: 1

records limit in derived view in VDP
answered 26-09-2017 09:15:13 -0400

Hi Team, I have a derived in Denodo with many views joins, i have same SQL code. when I run this SQL in oracle its showing 380000 records but when I run the derived view in denodo it not populating all the records ...at least its now showing the number...

Answers: 3

Virtual dataport security exception: dsa signature not available
answered 26-09-2017 07:04:39 -0400

Hi, I am getting below error while staring VDP . 1 [main] ERROR 2017-09-26T12:05:05.601 com.denodo.vdb.catalog.storage.DBDerbyStorageManager - Unable to initialize databasejava.sql.SQLNonTransientConnectionException: Connection refused : Fatal: There...

Answers: 1

Need to find Pipe character in a column value
answered 26-09-2017 01:11:55 -0400

I need to find the Pipe character ( | ) in the column value of a field in a view.This is the SQL I am using for my query, however I am not having luck in the reults: SELECT * FROM "My_View" where instr(my_column,'|') <> 0 Please let me know the ...

Answers: 1

VQL instr function

Number to date format in Case Statment
answered 26-09-2017 00:48:47 -0400

Hi All, I have one case statment as below case when view1.columname='A' then view2.date else v3.days end but here, v3.days is number, this column shows data as 1, 3 , 4,.. like ..so case stament is not working due to compatbility issues. how would we ...

Answers: 1

Denodo view
answered 25-09-2017 09:33:43 -0400

Hi, is there any internal Denodo function to which if we pass a existing Denodo view name, it should give out the views create script ?

Answers: 1

catalog view to list base view along with data source information
answered 25-09-2017 09:31:13 -0400

Hi , is there a way I can list out all the base view from each data source in Denodo ? I am not looking to manually go and check it under data source, I want something like Denodo view CATALOG_ELEMENTS() which does give me Base view name but not the ...

Answers: 1

Denodo custom functions - connect to vdp
answered 25-09-2017 09:16:46 -0400

Hello, Is there any way to get getEnvironment() in a custom function using java to run a vdp query ? Thanks!

Answers: 1

Encryption & Decryption of the Cached data
answered 21-09-2017 09:55:17 -0400

In denodo, we have ln-built functions to encrypt/decrypt data for each column but we need it as all data together send it to caching should be encrypted and when we retrieve all together from cache should be decrypted. Any suggestions should be appre...

Answers: 1