Home / Q&A / All Questions

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.

Script to turn Cache on or off
answered 08-08-2017 10:39:19 -0400

Is there a VQL script to turn on or off the cache so that instead of navigating to Administration>Server Configuration and switching the Cache, I can just run the script in VQL shell to get this done. Thanks and regards.

Answers: 3

DENODO Virtual DataPort

Keep view names to cached tables
answered 08-08-2017 09:11:08 -0400

When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Thanks, Sa...

Answers: 1

DENODO Denodo Scheduler 6.0 SQL Server

Avoid deleting the cached data at the time of deployment to upper environments
answered 08-08-2017 09:09:02 -0400

We have some views created in the local environment and when we deploy it the upper environment, we cache the views. So, every time we do a deployment we turn the cache back on all the views. This is making the tables which are cached previously in the...

Answers: 1

cache DENODO SQL Server deploy

updating multiple rows in one table using values obtained from second table in a single statement . . .
answered 04-08-2017 08:28:48 -0400

Hi there - We would like to be able to update one (virtual) table using the values from another table. I've tried several different variations of the SQL syntax, none of which were successful. For example, what we would like to be able to do would look...

Answers: 1

vql; update syntax;

Using Subversion with denodo
answered 04-08-2017 00:50:49 -0400

Hello, We are using subversion with denodo. I have a trunk and branch defined. Everytime I merge trunk to branch many items in the branch go into the red status ( out of sync) I need to check out individual items again to turn them green. Is there any...

Answers: 1

Date Expressions
answered 03-08-2017 09:16:02 -0400

Hi, Can anyone please provide me the expressions for Current quarter begining date, End of current quarter date and Next Quarter begining date? Thanks

Answers: 2

Incremental caching option in Denodo Express
answered 03-08-2017 07:31:34 -0400

Hi, I've been trying out the caching modes available in the express version but I can't seem to find the incremental option under full cache mode. Is this a limitation on the express version?

Answers: 1

Error opening "SELECT oid from pg_type where typname = 'geometry'"
answered 03-08-2017 05:26:36 -0400

I have made ODBC connection to Denodo from Alteryx. Connection is successful. But, when I ran the workflow to query a Denodo table/view in Alteryx, it throws below error. Start: Designer x64: Started running D:\Alteryx\New Workflow1.yxmd at 6/23/2017...

Answers: 4

ODBC Alteryx oid alteryx

Unable to Import Denodo View in SSAS
answered 02-08-2017 12:26:19 -0400

Hi, I am trying to import Denodo derived view in SSAS. But while importing the Denodo view i am facing the below mentioned error. If any one knows the solution please suggest what i have to do in this case. Error Message : "ERROR [ ] ERROR: Syntax e...

Answers: 2

Is there a parameter to identify the user currently connected to Denodo?
answered 01-08-2017 08:04:07 -0400

We have a sensitive data set which includes identifiers for Owner and Manager. For the purpose of this example, assume HR info (it's easy to understand). Manager ID~Employee ID~Some stuff.... 444~222~DataColumns for "222" 444~333~DataColumns for "333...

Answers: 2

parameter