Latest Activity

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

code

Mix Optional and Non-Optional Interpolation Variables in Base View from Query

Hi Denodo Team, Please let me know how to set up a mix of Optional and Non-Optional parameters for the base view query in Denodo. Example: SELECT * FROM Offchain.Movement M WHERE M.OPERATIONALDATE BETWEEN ''@START_DATE'' AND ''@END_DATE'' AND M.NAM...

code

Create field from an array

In Denodo 8.0 I have a json source. It has a feature array with a bbox array inside it. I would like to create a new field that has the text of the bbox array. I can't figure out how to do it. The original json from the url is: { "features": [ { ... ...

code

splunk cloud connection

Hi Team, Using CData JDBC JAR driver we are connecting to splunk cloud to fetch information in Denodo 7.0 20210224, but are unable to. error while running query on existing base view and also if new base view is tried to be created: Error executing s...