Latest Activity

code

Pivoting data

Hi I have a view called "marketplace" Fields: id, name and value I would like to put the id in rows, name in columns and values in the row or column for that id and name. id Name Value 001 ABC 123 002 ABC 123 001 BCD 123 to Id ABC BCD 001 123 002...

code

Combining values of two rows into one row

Hello. I have a Denodo integration view with 2 columns: person_id_column pet_column 0 Cat 1 Dog 1 Cat 2 Dog 2 Rabit 3 Cat ...

code

Issue in the lab "Lab Connecting to Virtual DataPort server from DBVisualizer "

Hello, I am following the course denodo platform endpoints, and I am stucked in the first lab "Connecting to Virtual DataPort server from DBVisualizer ". I do not have DBVisualizer but instead DBeaver (and I cannot install DBVisualizer because of some...

code

Validate Revision On Target Environment

Hi Team, How can I validate the Revision, whether it is already deployed or not in target environment using API

code

How to convert datetimestamp to utc format

one of field is havinf timstamp in another format but the requirement to convert it into utc format. we cant change view setting is there any way where we can change timestamp format to utc.

code

remove parameters from query output

Hi, Parameters added in a selection or join are always shown in the query output as a new column, is it possible to hide these columns in the query output? The reason I use parameters in some views, is due to the parameter is mandatory for execution,...

code

Utilization in Denodo View

Can I check how do I know the memory usage in Denodo View? Does the number of columns affect the denodo view memory usage? Is lesser columns selected more feasible for a view?

code

Denodo integration

Can I consume msg (message) on Confluent using Denodo. And what about Intergration Denodo with AD/LDAP.

code

Error while executing query

Facing error while executing the below query SELECT AQ_1.COL_1,AQ_1.COL_2,AQ_1.COL_3 OVER(ORDER BY AQ_1.COL_1 ASC ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING ) FROM ( SELECT TC_1."col1" COL_1, TC_1."col2" COL_2, SUM(TC_1."col3") COL_3, AV...

code

Pyodbc Denodo

Hello, I am working with a business partner to connect to Denodo using pyodbc. I was able to get my script to work, but when she tried she is getting the following error: OperationalError: ('08001', '[08001] ERROR: SSL connection required\n (101) (SQLD...