Latest Activity

Denodo doesn't recognize local file within stored procedure

I have denodo platform 8.0 running on EC2 installed using cloudformation template as per the installation guide by Denodo. I am trying to create a custom stored proc which has to read a license file (locally saved inside /opt/denodo/denodo-platform8.0/...

Display Trailing zeros solution not working

I tried the following and i still dont see the trailing zeros for decimal data... Generally, in Virtual DataPort “decimal“ type, precision, and scale of the decimal type is obtained from JDBC data sources. The Virtual DataPort Administration Tool wil...

Decimal data type column inconsistent results

Hi team, we are using denodo 8.0 and heres the issue: Source and target field are decimal. In SQL database source its numeric (19,8) and in denodo its decimal. When quering the view heres the data descrepncy : | SQL | Denodo 204481.43592593 | 204481.4...

Multi Cloud Integration in Denodo

HI Denodo SME, Do we have multi-cloud integration capability in Denodo ? Scenario : Integrating AWS Redshift data with Azure Synpse (analytic service) or something thing similar where customer wants to integrates data from two cloud provider , i...

Export File Using Denodo Design Studio

Hello, is there a way to export results in Denodo Design Studio? PS: don't want to use admin tool(thick client) or Denodo-Data-Catalog. Thanks.

Automatic redirection of http calls

Hi, I am trying tu publish via Denodo web services some views that retrieve source data from an external site. To do that I have to get company's firewall open for those calls. Calls to retrieve dta from external site look like: https://<server-nam...

Denodo not connecting

I exported the vdb to a local path , and later ran that using VQL shell , after that i tried to stop the execution and it hanged , now when i am trynig to connect denodo it just showing Connecting ........ Please help as it stays on same login page and...

Can Denodo 7 ODBC connect to Denodo 8 Server

Hi Team, Can Denodo 7 ODBC connect to Denodo 8 Server? Or it is a must to connect Denodo 8 with Denodo 8 ODBC? I mean both windows and linux. How about JDBC, for both windows and linux. Thanks.

Can someone help me how to implement the below logic that uses sub query?

SELECT DISTINCT pd.PROJECT_ID, vuc.ID, vuc.NAME, vuc.PARENT_ID, ( SELECT DISTINCT CASE WHEN vuc.NODE_LEVEL=2 THEN 'null' WHEN vuc.NODE_LEVEL=3 THEN vuc.NAME WHEN vuc.NODE_LEVEL=4 THEN (select mo.name from unit_code mo where mo.id= vuc.PARENT_ID) END FR...

Base view Milli Seconds Issue

I have created base view with the data type as 'ENDDATE' :'java.sql.Timestamp' (OPT) (sourcetyperadix='10', sourcetypename='TIMESTAMP(6)', sourcetypeid='93', sourcetypedecimals='6', sourcetypesize='11') SORTABLE. In my source date having milli seconds ...