Q&A

Long time execution | No. of rows Variation in results
answered 23-08-2021 07:06:47 -0400

What is the problem when execute, it takes more than 1 minute to execute and shows variation in records? Sometimes shows error also.

Answers: 1

#Source Data Error executing

Custom policies - Trying to get data from Denodo base view
answered 23-08-2021 04:36:06 -0400

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

Answers: 6

Denodo 8.0 custom policy jmx

Denodo 8.0 connect to JDBC failed
answered 23-08-2021 01:32:11 -0400

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).

Answers: 1

Query for eliminating non-dependent/unnecessary views
answered 20-08-2021 17:34:22 -0400

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

Answers: 3

Prioritize operational over analytical queries
answered 20-08-2021 17:28:02 -0400

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!

Answers: 1

Link broken in Usage Statistics (404not found)
answered 20-08-2021 17:27:18 -0400

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

Answers: 1

Data Catalog

Denodo Pagination - JSON Source
answered 20-08-2021 16:20:51 -0400

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

Answers: 1

Denodo Pagination

Not able to use order by clause for multiple columns
answered 20-08-2021 14:04:02 -0400

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

Answers: 1

We are able to see lists, yet files attached are only retreived as filenames and not a BLOB
answered 19-08-2021 19:33:35 -0400

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

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

Denodo 8 BLOB SharePoint

Denodo Driver with Java 7.1 version
answered 19-08-2021 03:36:18 -0400

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

Answers: 1

java 7.1 version ODBC Driver IBM INFOSPHERE Datasatge 11.5 v DATASTAGE