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

Analytic function in Denodo
answered 10-09-2018 19:13:50 -0400

How to write this in denodo select col1, col2, col3, col4, col5 , sum() over (partition by col1) as col1_summary , count() over () as total_count from t1

Answers: 2

How do I enable Denodo to connect AWS athena to create base view on the table
answered 07-09-2018 17:17:42 -0400

How do I enable Denodo to connect AWS athena to create base view on the table. Using Denodo VDP v.6.0

Answers: 1

AWS athena

check data source status
answered 07-09-2018 12:32:55 -0400

Hi Team, Denodo 5.5 DB1 JDBC, sql server - DS1, DS2, DS3, DS4,DS5 I want to get email notification about any DS failure while establishing connection with sql server database. What I am looking at it is any power shell script or batch script or an...

Answers: 1

Data Source Connection

environment variables set
answered 07-09-2018 06:01:53 -0400

I Installed applcaton in D: , when i am running the denodo lab files to create json DS , DEN60EDU0111LAB01.start.bat file is not executing . Can you help me to solve this . do i need to change the environmental veriuables or should i set an new one .

Answers: 3

error accessing metadata
answered 07-09-2018 05:15:55 -0400

Hi Team, Denodo 5.5 DB1 - elevation in progress DB2 - query - select * from catalog_elements() DB2 - error - received exception with message 'error accessing the metadata while loading/storing objects' Is this error intended ? Please tell. Thanks.

Answers: 4

metadata

Download Express
answered 07-09-2018 04:59:25 -0400

I am trying to download the express edition. But I am getting below error. Forbidden You don’t have permission to access /community/licenses/denodo-express-lic-7_0-201803.lic on this server.

Answers: 1

new installation

Unable to download express edition
answered 07-09-2018 04:58:08 -0400

I am trying to download the express edition. But I am getting below error. Forbidden You don't have permission to access /community/licenses/denodo-express-lic-7_0-201803.lic on this server.

Answers: 1

Cannot connect to JDBC database for Lab
answered 06-09-2018 12:55:21 -0400

I'm going through the Lab: DEN60EDU0105LAB01 - Create ds_call_center data source and import all tables I've installed Denodo AccessDatabaseEngine_X64 Calltracking.mdb is in: C:\Users\ehayes\Desktop\Denodo\DEN60EDU0105LAB01 I've configured th...

Answers: 3

Access JDBC

How does "Case sensitivity in comparison of literal strings" work in Denodo? I am getting the same results for Uppercase and lowercase strings.
answered 06-09-2018 10:48:12 -0400

I am implementing a search module on Denodo REST API. When the users perform a search, they are likely to use lower case for all their search terms. However, if it is case-sensitive, if the search information was spelled with an uppercase in our system...

Answers: 1

REST API search REST

Cannot Connect to Denodo using JDBC via Mulesoft code
answered 06-09-2018 10:01:02 -0400

Hi All, We are trying to figure out this issue since long but no help. I am trying to connect to Denodo via JDBC from my Mulesoft code (Anypoint Studio) on my desktop but always getting connection timeout. URL: jdbc:vdb://${denodo.host}:${denodo.por...

Answers: 2

Denodo VDB Connection Time out Connection JDBC