Latest Activity

code

Bit datatype transforms to boolean in denodo base views

I have one scenario where one of the fields from the source(MSSQL) is a bit datatype while creating a base view in denodo it gets transformed into boolean datatype. Users want to see the results in 0/1 instead of true/false. Even end user application...

code

Best way to export all catalog permissions to a report?

Hello. What would be the best way to automatically export all users and roles catalog permissions to be used in audit reporting without the need for sysadmin priviliges? We would prefer if reportdevelopers did not have acces to admin-accounts.

code

Schedule a remote table refresh

The remote table is created in a jdbc source system and the base view is created in Denodo. But how do I schedule a job to refresh this Remote table

code

Performance Issue

We need help here as in what could we be the ways to further optimize as it is taking forever to run. There are two branches on a high level/ Left branch - Union of 6 regions data with required customizations/joins happening for each branch (data - to...

code

Columns used in DB2 11 SYSCAT.ROUTINES

What columns form the DB2 11 SYSCAT.ROUTINES view dose Denodo access?

Related to: Denodo Development Best Practices

code

List Database Folders

Hi, is there a way to list the denodo folders for a particular denodo database via VQL? so for example: sandbox (database) - 0. Raw Data (folder) - 1. Interfaces (folder) - 2. Derived Views (folder) - 3. Final Views (folder) So i want to be able t...

code

API error - 429

Hi Team, I am connecting to an API and started getting error 429 - too many requests. Is there a way where in i can put a wait before the next request? Or any other recommendations? Thanks!

code

Posting data to materialized view via Denodo web service

Hi, We're using a separate software to route messages between a Denodo webservice and an external webservice. What is the best option to store the replies from the external webservice? It could be both error messages and data. I tested using a separate...

code

Corresponding function Denodo to ORA_HASH in Oracle

Can you help me with corresponding function to ORA_HASH function in oracle. we're using Denodo 7.0

code

scheduler load process report

Hi Team, how denodo stores scheduler load process reports for cache jobs. how can we bring that in to denodo vdp. Thanks.