Latest Activity

code

Virtual DataPort 8.0: Remote license not found. The server is not registered in Solution Manager. When 2 SM server is load balanced

We have installed two solution managers and configured Postgresql as an external metadata database. These two SM machines are load balanced using an external TCP load balancer. Firewall ports 10091, 19090, and 19443 are opened in the load balancer so i...

code

ISO_WEEK in denodo

Hi team Is there any way to calculate julian day in denodo? I am unable to find any solution. Kindly help. For iso_week, got a solution...unable to find a solution for julian day

code

views exclusion parameters

Hi team, Is it possible to create a denodo view which contain two parameters, but when queries running users cannot input the two paramters together, they can only input value to either one parameter, if input two of them, we want to the error retruned...

code

JDBC REDIS connector

Hi, Is there a JDBC REDIS connector available ? (https://redis.io/) Anyone tested JDBC REDIS for Deneodo Cache ? Thanks, José

code

Denodo Express - Connecting to Snowflake Database

I am attempting to connect to a Snowflake Database via Denodo Express 8.0 on a Linux CentOS VM in Azure. JDBC connection - tried snowflake 1.x which comes with Denodo Express and also tried snowflake 3 (which was set up using snowflake-jdbc-3.13.1.jar...

code

Denodo ODBC Driver - Incorrect Username/Password

Hi - very new to this so sorry if anything is missing! Installed Denodo 7 ODBC driver and setup under system DSN with my computer sign on information (I am an admin). I have this installed to run Power BI refreshes, everything was great for about a mon...

code

Denodo Training Files

Hi, Where are the sql denodo training files?

code

Needed ports for promotions both in Denodo Application Server and Solution Manager instances

Hello, we plan to deploy our Denodo services in the future using the Solution Manager, as explained here: https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/promotions/promotions We use AWS and we have several AWS Acc...

code

Read an element in an array

Hi Team, How to read the elements of an array at specific index? I have also tried using flatten, but i am unable to achieve.Kindly help me on this. e.g : array = {'a','b','c'} i want to read the element at specific index, for eg : at index 1 , outp...

code

dynamic parameters value in where condition

Hi team, Does denodo has the function to suport dynamic paramters input in where condition, e.g. where (case when parameter_flag = 'A' then date_column = baseview.date_col_a when parameter_flag = 'B' then date_column = baseview.date_col_b else '190001...