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.

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

CLEAN_CACHE_DATABASE
answered 01-03-2019 07:58:35 -0500

Hi Team, I have a Full Cache Job in Denodo which invalidates existing records and loads the new data. But in this process am still having a invalid records present in the cache view table. My question here, is there a way in the same Job I can trunca...

Answers: 1

Connect to SAP HANA 2
answered 01-03-2019 03:37:33 -0500

How can I connect denodo to a SAP HANA 2 datasource?

Answers: 3

SAP HANA 2