Latest Activity

code

About Oracle Clob columns shown properly in Denodo when group by

Hi team, we have clob column sourced from oracle table, when group by this clob column in Denodo, we will get error “ORA-00932: inconsistent datatypes: expected - got CLOB” , so we add cast function to this column, and the group by can run properly. bu...

code

Get latest excel file from a folder in excel datasource

Hi We have created a delimited datasource to fetch details from latest excel file in the folder in server. We have a job which will create new files everyday in this folder. We need to fetch the latest file daily by the datasource we are creating. Is ...

code

alternate function for PostgreSQL to_date() in denodo 8

Hi, I have date column in text as 'yyyymmdd' format from PostgreSQL source. I tried to_date() in denodo to convert into 'date' datatype as 'yyyy-mm-dd' but it shows 'date' as deprecated. Then I tried to_localdate() to convert - I got the required forma...

code

Assign property groups automatically with a trigger

I created a stored procedure with java to assign property groups to interfaces views. I would to create a trigger to executes automatically the stored procedure after each interface view created in design studio (AFTER INSERTED ON GET_VIEWS). If we c...

code

Error when creating remote table in denodo express

i have an error when creating remote table from denodo express my base source in oracle and target in MySQL error message Error creating remote table Error executing VQL query. QUERY [VIRTUAL] [ERROR] QUERY [JDBC WRAPPER] [ERROR] QUERY [JDBC ROUTE]...

code

UNABLE TO SEE THE TABLES AFTER CLICKING ON CREATE BASE VIEW

Hi, I am trying to create JDBC datasource using MYSQL adaptor. The test connection is successful but when Save the source and try to create base views of tables I am unable to see any tables in my database. I have granted all the access to the databas...

code

Dockerfile for Denodo Image

Hi I have my docker file as below and followed instruction preparing the Docker build folders and files. but i got the error as below: => ERROR [builder-updater 2/2] RUN find /opt/denodo-update/ -name "denodojar" | sort | while read file; do echo...

code

Error executing query

Hi All, I'm Getting an error while executing a query in VQL please provide a solution for below error. Error executing query. Total time 8.267 seconds. QUERY [ORDERBY] [ERROR] QUERY [PROJECTION] [ERROR] QUERY [SELECTION] [ERROR] EMPLOYEE_SALES [PROJE...

code

Convert 2 date values(in text) to a standard format in timestamp

Hi Team, I have a single attribute agreed_due_date which is returning date (in text) result in 2 formats as below: dd/MM/yyyy format (e.g. 30/06/2008) yyyy-MM-dd''T''HH:mm:ssZ format(e.g. 2023-11-02T14:00:00.999Z) How can I handle such kind o...

code

Same SSL Certificate in denodo 7 and 8

Hi Team We are upgrading denodo 7 to 8.Can we use same SSL Certificate in both versions. If so, how can we move ssl from 7 to 8?