Latest Activity

code

Automation of admintask

We are trying to automate our user requests to get acces to Denodo. This requires us to automate the fomlowing tasks: Creation of roles in solution manager Assign permissions for the user role to the correct environment Creation of users roles...

code

Denodo Docker Image Build / Container Run

Hi I am using Denodo Express 8 and I have built the Denodo image. When i exec the following: sudo docker run -d -h denodo-vdpserver \ -p 9999:9999 -p 9997:9997 -p 9996:9996 -p 9995:9995 -p 9990:9990 \ -e DENODO_USERNAME=admin -e DENODO_PASSWORD=admin...

code

Interface view -Data type

Hi, How to change the data type in interface view.

code

How to use Kerberos authentication with sqlalchemy

Hi, I try to find an example how to connect to python to denodo using sqlalchemy with kerberos. appreciate any guide. Best regards, Pon

code

What all the different conditions that can be applied in Rules

What all conditions can be applied in Rules , I know some rules like username = 'xxxx' (roles).value in('xxxx') access_interface = 'JDBC' what more conditions can be applied and where can I find all the conditions

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