Q&A

To add a parameter to a derived view
answered 14-01-2020 02:37:03 -0500

I have Denodo Express v7 and I'm trying to generate a view which handle view parameters, but the button to handle it in the Model Tab is always disabled, is it because I am using Denodo Express or it might be something else? (like some configuration is...

Answers: 3

Parameter View Parameter entry derived view

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