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.

I am a student entering the industry as a data analyst...
answered 05-12-2017 05:26:13 -0500

I am a student entering the industry as a data analyst. I use various data sources including SQL server, Oracle 12c, Apache Hive tables, MySQL. I just learned about Denodo in a job inquiry and was interested in how I can integrate it into analytics pip...

Answers: 1

New

REST API Paging Response Links
answered 05-12-2017 02:29:39 -0500

Hi, I have two environments where Denodo is installed. One environment was set up a few years ago, and the other was set up recently. The response from REST APIs are coming in differently for the paging information. The newer environment is returning ...

Answers: 1

REST API

Unable to connect to MSSQL Server using denodo
answered 05-12-2017 02:22:29 -0500

Hello, Im trying to create a Denodo Data source connection to a MSSQL Server 2016 database. Since im using a trial version im not able to create a ODBC connection. So, i tried to create JDBC connection. Both MSSQL Server and Denodo are installed on ...

Answers: 2

ReST API PDF
answered 04-12-2017 23:30:22 -0500

I have Rest API which will retrive the PDF content , How would I stroe this file in specific folder As well as , I would to like to schdule the process so that pdf will get stored in daily basis Is this possible with Denodo ? Thanks

Answers: 1

REST API REST

Cache invalid rows.
answered 04-12-2017 07:38:13 -0500

Hi guys, There is a situation when we created a view which uses two different data sources (db2 as/400 and ms sql server). Also this view has denodo parameter "IN_Role" with three values: 'DB2' - choose from db2 'MSSQL' - choose from ms sql ser...

Answers: 2

Cache error

Denodo JDBC Connectivity
answered 04-12-2017 07:16:37 -0500

We have identifed that Denodo JDBC is based on RMI. Do you have JDBC Drivers for version 6.0 without RMI.

Answers: 1

Denodo 6.0 JDBC JDBC

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