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.

Cache Error Modifying View
answered 05-03-2019 06:48:57 -0500

Hi - we have been having intermittent problems with our cache. Randomly, when I try to change the cache mode on any view, I receive the error: Error modifying view: Error getting valid table name At this point, I have to ask our admin to reboot or res...

Answers: 2

Cache

connection with phyton
answered 04-03-2019 11:47:46 -0500

we install the ODBC and it does not mark us any error, nevertheless when executing from the Python (version 3.6) it marks us error for lack of the file denodoodbc.so: import pyodbc pyodbc.dataSources() {} cnxn = pyodbc.connect('DRIVER=Deno...

Answers: 1

connection from phyton to denodo
answered 04-03-2019 11:39:30 -0500

we install the ODBC and it does not mark us any error, nevertheless when executing from the Python (version 3.6) it marks us error for lack of the file denodoodbc.so: import pyodbc pyodbc.dataSources() {} cnxn = pyodbc.connect('DRIVER=Deno...

Answers: 1

Number of Denodo Servers that can run simultaneously
answered 04-03-2019 07:38:00 -0500

Please let me know how many servers can run simultaneously in Denodo? What is the affect of all the servers running? (WRT The licenses only keep a limitation of the number of Denodo servers you can run simultaneously, in addition to certain limitations...

Answers: 1

VDP server

Getting column specific information on the views
answered 04-03-2019 07:19:59 -0500

Hi, is there any dendo predefined procedure that tells the infomation about when a particular column was last modified with either the description info or any other changes. I see the predefined procedure like "get elements" which is giving info at th...

Answers: 1

Join view OR Operator
answered 04-03-2019 05:53:50 -0500

Hi How to use OR operator in join condition my query looks like this bv_1.id = bv_order.id AND (UPPER(bv_code.CODETYPE) = 'ADMINISTRATIVEGENDER' **OR** bv_ce.C_CODE IN('4','5')) ERROR what i am getting currently The join condition is not vali...

Answers: 3

can this be used for solution manager
answered 04-03-2019 04:44:40 -0500

can above funtion also be used for solution manager?

Answers: 1
Related to: Automating status check of Denodo services

Can Denodo integrate with SSIS packages?
answered 04-03-2019 04:42:01 -0500

We're a software company that is hosting a secure set of data for client in a private security group under RDS SQL instances. Many of our clients use MS SSIS to perform common queries. Is there a way to import SSIS packages to have Denodo supply the sa...

Answers: 1
Related to: How to access Denodo Virtual DataPort from Microsoft SQL Server Reporting Services

DENODO SSIS

Importing Users from a CSV.
answered 01-03-2019 08:35:13 -0500

Hi We have over 5000 users that access a Oracle Data warehouse directly. We can extract all these users into a csv file. Is it possible to import all these users into Denodo?

Answers: 1

How to pass multiple DB's to Procedure : CLEAN_CACHE_DATABASE
answered 01-03-2019 08:03:50 -0500

Hi Team, Currently I am passing a single database to the procedure : CLEAN_CACHE_DATABASE, to truncate the invalidated records within a Single DB. So there might be cases where few Project DB's/Application teams might don't know this. so as part of A...

Answers: 1