Latest Activity

code

JSON Datasource

I am trying to create JSON datasoure using DEN70EDUD1201LAB01 data but when i am trying to run start.bat file I am getting the below. Error : WARN::FAILED SelectChannelConnector@0.0.0.0:8081: java.net.BindException: Address already in use: bind. How ...

code

Denodo on Azure SQL MIS Source

Azure Replication DB Source for Denodo Hi there, I have a requirement where I need to source a near-real-time Azure MIS SQL instance for Denodo. The Replcation happens every 5-10 minutes. What are the design considerations in order for Denodo to use/ ...

code

Creating materialized tables in Snowflake

Hello. I have an online data source from which I extract data in Denodo. The data source has lots of rows of data corresponding to many months in the past. I want to retrive, every month, the data related to the month just ended and use it to create ...

code

Find occurrence of a character in a string

I have similar data as below in a field. asgbf-4567-7836-001 asgbf-4568-238965-0471 uhsnfhed-248-76398-46921-89432 AA-001-567-8934-98345-200 The requirement is to find out the occurrence of '-' in the data and extract the particular substring of data....

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