Latest Activity

code

Denodo support for something like SQL EXECUTE AS function?

Hello, Does Denodo support some kind of impersonation feature like EXECUTE AS in SQL Server? This would allow a functional user to execute a query on behalf of another user. If Denodo doesn't support it through this kind of statement, does Denodo su...

code

Build a custom docker image to avail denodo so that later denodo database could be accessed via Databricks

I have a problem where my requirement is to Build a custom docker image to avail denodo so that later denodo database could be accessed via Databricks . The problem is to set up everything inside docker image so that any developer is able to use denodo...

code

Invalid object name 'fn_listextendedproperty' when introspecting tables in SQLServer2000 via JDBC

We are trying to create base views on tables in a SQLServer2000 dataase using Microsoft SQL Server 2000 (JTDS) datbase adapter. However in the "Create base view" tab if we select a table we get an error: Invalid object name 'fnlistextendedproperty' . T...

code

Datediff/timestamp diff

Hi, I have the below SQL server query, how would I interpret this in Denodo? I want to get time difference in days, hours, month, seconds. I am aware of "cast" function which equals "convert", "GETDATE()" which equals "CURRENTDATE()", "Varchar" will ...

code

Access Dynamic file name from API

Hi, I have a scenario where in I need to pull the data from the public API HTTP link and the file name keep on changing. But the structure/format/columns remains the same. How can I handle this scenario within denodo so that view still connect to the l...

code

Role management in solution manager

Hi Denodo Team Could you tell me does the configuration store in metadata database or properties file when i add a new group in role management. I deployed denodo on k8s and using external metada database now. I was thought the data will be store into...

code

Load Denodo Data to Oracle Apex Table

I have used the Denodo Scheduler to access a Denodo interface view and load data to an Oracle 12c table, but can the Denodo Scheduler be used to load data into an Oracle Apex table?

code

Connection error when authenticating

Hi, when i try to connect to the Denodo Schduler on the Soultion Manager web tool through the Virtual DataPort server it is showing me this error "Connection error when authenticating". I can access the Scheduler from the denodo platform where the VDP ...

code

API usage Reference?

Hi, I am new to denodo. We are using Denodo. Where can I find reference links to API usage and troubleshoot? E.g., if I have API performance issues or if it hang, where should look for help? Thanks you!

API
code

How Move table from one database to other database through VQL Shell?

Suppose i have x and y database folders. there are subfolders (A,B) under X and Y having subfolders(C,D). i want to move views from X(A) to Y(D). Please share VQL command and help me its needful.