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 September 2019.

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.

Audit List of query execution time is more than 800Sec
answered 13-01-2020 21:19:38 -0500

Hi Team, Could you please share the query or steps to take Audit list of query execution time is more than 800Sec

Answers: 1

Denodo version
answered 13-01-2020 12:55:43 -0500

Hi, How to get Denodo version using VQL script?

Answers: 1

Error connecting to SQL Server
answered 13-01-2020 09:40:32 -0500

I cannot connect Denodo with an SQL Server data source. I have used ODBC and JDBC, if someone can send me the step by step I would appreciate it. Greetings from Ecuador.

Answers: 2

Join views: Can Denodo fetch JOIN branches sequentially rather than in parallel?
answered 13-01-2020 08:37:25 -0500

Hi team, I'm working on an Oracle datasource. There is an Oracle procedure that accepts a test parameter and dynamically creates a view based on this parameter. Depending on the parameter, view columns are different but view name stay the same. I kn...

Answers: 2

Load data from Denodo View to Google Cloud Storage
answered 13-01-2020 04:58:28 -0500

Hi. We have views created in Denodo that we would like to load into Google Cloud Storage (which will eventually be moved to BigQuery to create a subject layer). Has anyone been able to complete this? We are currently in the very early stages of testing...

Answers: 3

google analytics google cloud storage googlecloud

Connection from Python to Denodo
answered 13-01-2020 03:33:12 -0500

Hello, I want to access data from denodo using python3. My code looks like the following: import jaydebeapi hostname = '####################' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '#####' password = '#####' path = '/home/I011404...

Answers: 9

Python

Incompatible subtype
answered 10-01-2020 20:49:26 -0500

Hi there, The data source data type has changed from int to text. I would like to change the my base you to reflect this new data type. The error im getting is "the field has a compatible subtype for type "text": INTEGER Please assist with me with c...

Answers: 1

string conversion

in selection view, is there any way that input parameter can accept values from subquery rather direct assignment
answered 10-01-2020 19:26:28 -0500

in selection view, is there any way that input view parameter can accept values from subquery rather direct assignment of values. if i assign values through sun query like below SELECT GETDAYSBETWEEN(in_from_effective_date, in_to_effective_date), p_p...

Answers: 1

Parameter View Parameter entry selection view

Issues with "Denodo Email Exported Files Custom Handler" on Denodo Scheduler.
answered 10-01-2020 06:07:17 -0500

Hi Team, I have configured "email export files" on Denodo Scheduler as given in the document link "https://community.denodo.com/docs/html/document/denodoconnects/7.0/Custom%20Handler%20Email%20Exported%20Files%20-%20User%20Manual". But I am facing is...

Answers: 1

Issues connecting to RDS mysql V8 from Denodo VDP client.
answered 09-01-2020 14:37:07 -0500

Hi Team, We use AWS RDS for Denodo Cache. We have upgraded RDS mysql version from 5.6.41 to 8.0.16. When trying to connect from Denodo VDP to RDS, it is throwing below error. Unable to establish connection: Communications link failure The last packe...

Answers: 1

Cache