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 April 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

temporarily disable connection and related base views
answered 04-12-2017 07:07:22 -0500

We have a complex view stack with data that is pulled from several base views from different databases. One of the databases is going offline (that several base views are built off of) for a week and will not allow connections, thus this will cause our...

Answers: 1

calculation referring to previous row values
answered 04-12-2017 07:03:57 -0500

Hi, I am trying to create a Denodo view in VDP. Requirement is that a field value refers to previous records' field values. Example, Col1 Col2 Col3 10 25 10+25=35 35 5 35+5=40 40 30 40+30=70 70 7 70+7=77 In above, value of previous Col3 should get pop...

Answers: 2

#cyclic #calculated fields

Issue after updating Denodo License file in AWS Instance
answered 04-12-2017 01:38:52 -0500

Hello, I have chef automation script which installing Denodo and Updating license file which got expired with new one. The Denodo server is running in AWS Cent OS. In AWS Instance do we have any scripts which are Reinstalling / Resetting the environm...

Answers: 1

License File

Function similar to LISTAGG in Oracle
answered 01-12-2017 07:24:53 -0500

Hi Team, I am trying to create a VQL similar to an existing Oracle query. In one part of the query, LISTAGG is used. Is there any Denodo function avaliable similar to LISTAGG. Below is the sample oracle query: SELECT DISTINCT WHOLESALER_ID, LISTAGG(L...

Answers: 1

Associations in Denodo
answered 01-12-2017 05:01:00 -0500

Good Afternoon. Some questions looking for help. Can the associations be defined on base views only ? maybe on derived views ?! Can the associations be used to drill down ? for instance from a list of customers drill down to the rows showing thei...

Answers: 1

Unable to import XML file .
answered 30-11-2017 07:29:36 -0500

We have multiple data present in multiple files (xml,csv,json,excel) in multiple linux servers . When we tried to connect using available option under connections -> Data route ->configurations (FTP/SFTP/FTPS) using URL ftp://server_ip:port/dir/f...

Answers: 1

Excel XML CSV XML Data Source JSON

RANK Function
answered 30-11-2017 06:49:27 -0500

Can I use rank function to a csv data source?

Answers: 1

Job execution when Denodo Scheduler service is down
answered 30-11-2017 05:36:26 -0500

Hi Team, I have seen a scenario as below. Please guide if this is the expected behaviour. Denodo Scheduler 5.5 When Denodo Scheduler service is down- • Auto scheduled jobs do not run, • But, login and manual execution of jobs can be done Thanks.

Answers: 4

denodo scheduler

data source connection string information
answered 29-11-2017 22:26:55 -0500

Hi, Is there a view in Denodo which could tell me the connection url configured against each data source ?

Answers: 9

export job from one project and import it to another project
answered 29-11-2017 04:51:55 -0500

Hi Team, Can this be achieved. Please guide. Importing / Copying / Cloning a Job, say, "Job1" from Project, say, "P1" to Project, say, "P2" as Job, say, "Job2" Or, the option I see is manually modifying the exported xml and other files. Thanks.

Answers: 3

denodo scheduler