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

How to deploy the derived view in the different environments (Staging/Production) from Development with updated fields without modifying the individual derived views?
asked 21-01-2019 12:38:29 -0500

I have created a "Selection" Derived View. I would like to add a field in the Derived View for "URL" in the final output for Tableau reports like "https://DevTableauServerName/DevReportname". So, I added like this, Output Tab -> New Field -> Fi...

Answers: 0

derived view URL deployment

NEST() aggregation function ERROR when (Snowflake) source configuration has "Delegate aggregate functions list" checkbox is "unchecked"
asked 21-01-2019 10:19:47 -0500

Dear Denodo Support Team, I am encountering below error while delegating the aggregate functions setting is unchecked. Error: Finished with error: Error executing query. Total time 0.117 seconds. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] ...

Answers: 0

Denodo 6.0 Delegate nesting delegation data aggregation

Function LASTDAYOFMONTH not delegated to Teradata
answered 21-01-2019 08:54:31 -0500

Hallo Denodo Team, Investigating the reasons why a query is not delegated to the Teradata data source, we have read this explanation: The function 'lastdayofmonth' cannot be delegated to this database Teradata has a corresponding function, namely LA...

Answers: 1

delegate lastdayofmonth teradata delegation

Details required about optimization techniques
answered 21-01-2019 07:49:22 -0500

Hi Team, While going through optimization i have few doubts regarding the same. 1.Regarding cost based optimization, Denodo estimates the associated cost for different possible execution plans. It will choose the plan with the lowest estimated cost.C...

Answers: 1

Error creating database: error accessing the metadata while loading?stroring object
answered 18-01-2019 13:10:06 -0500

We just got Denodo 7.0 and try to create the database from 'administration/Database management' and having this error. "Error creating database: error accessing the metadata while loading?stroring object".

Answers: 1

Export/Import Views and/or Data sources from one environment to another
asked 18-01-2019 08:29:12 -0500

Hello, Can you please direct me to a step by step guide on how to export views or data sources from one enviornment and move it to another? Example...many times I will create a view or update a view in our Dev enviornment and then move that update to o...

Answers: 0

Import Export

Error Loading View in Denodo VDP Tool
asked 18-01-2019 07:39:01 -0500

Hi Team, When I am trying to edit a Base view or double click and try to open a Base View I am getting a error : "An internal error occurred when loading this wizard. Check the application log for details in Denodo" May I know why do I get these erro...

Answers: 0

VQL Generation
answered 17-01-2019 13:03:07 -0500

Hi Team, I am trying to create a wrapper with below query. And it's been creating successfully. CREATE OR REPLACE WRAPPER JDBC test_select FOLDER = '/data sources' DATASOURCENAME=consolidator SQLSENTENCE='DESC VQL VIEW BookBalancesContractLevel (''dr...

Answers: 1

Having issue to connect the local SQL server 2017
answered 17-01-2019 10:14:30 -0500

I have denodo 7.0 on my local computer and I would like to connect the local SQL datbase source (SQL server 2017 adventure Database) for testing. I don't see any adeptor for SQL server 2017. I try with 2016 but didn't work.

Answers: 1

how to create a base view on a json web service which has multiple arrays
answered 17-01-2019 08:42:08 -0500

I am reading the following web service https://download.open.fda.gov/drug/label/drug-label-0001-of-0007.json.zip the results is an array which has other arrays inside in a hierarchy. Is there a function which i can call to return the fields in the sele...

Answers: 1

Denodo 6.0 array hierarchy