Latest Activity

code

Custom policies - Trying to get data from Denodo base view

Using Denodo 8.0, I'm trying to build a custom policy that will be applied to a specific derived view, that works this way: When user tries to access the data of a derived view, the policy checks to see if the current user is in a config table. If th...

code

Denodo 8.0 connect to JDBC failed

I use denodo 8.0 and mysql 8.0 to connect JDBC, test connection is show Unable to establish connection: Access denied for user 'root'@'localhost' (using password: YES).

code

Query for eliminating non-dependent/unnecessary views

Hi, I have migrated views to QA environment and there are some views that are not dependent of the final Interface view, to retrieve the dependent views, I use this query : SELECT DISTINCT view_database_name, view_name, view_type, private_view, depen...

code

Prioritize operational over analytical queries

Hi, Can I check how can prioritze operational queries over analytical queries? Can I check if the above question can be achieved in resource manager? if yes, if there's any documents that I can refer to do the setup? Thanks!

code

Link broken in Usage Statistics (404not found)

Load the Denodo Incremental Cache Load stored procedure in Denodo Virtual DataPort. The link was broken in 「Denodo Incremental Cache Load」part. Usage Statistics

code

Denodo Pagination - JSON Source

I am facing an issue while paginating the data. We are getting response details in JSOn format and we are simply passing the path of that next page in JSON data source. But the Denodo Pagination mechanism is something where complete URI will be replac...

code

Not able to use order by clause for multiple columns

hi i have joined two views and i am trying to use order by clause on the view with the provided functionality in denodo 7 . but i am not able to use two or more columns, Is there any way i can use order by on the integrated view for multiple columns

code

We are able to see lists, yet files attached are only retreived as filenames and not a BLOB

We have been able to follow the procedure as stated from: https://community.denodo.com/kb/view/document/How%20to%20connect%20Denodo%20to%20Sharepoint%20Online%20using%20OData%20with%20OAuth%20authentication?category=Security We can see the lists data ...

Related to: Microsoft SharePoint as data source;jsessionid=58872EBE9D683D863D1323A2BA8F8100

code

Denodo Driver with Java 7.1 version

Hi All, We are tring to connect with IBM Infosphere Datastage 11.5 v with Denodo through ODBC. IBM Infosphere supports Java 7.1 version and it cannot be update to Java 8 Can you please tell whether denodo have ODBC Drivers of Java 7.1 version to insta...

code

Common Table Expression (CTE) and Recursion

I see there is support of WITH statements allowing CTE work. Does Denodo support recursion in CTE's? I have tried to get it working, but the error back is that the name of the CTE does not exist. When I remove the recursion piece of the query, it wo...