Latest Activity

code

Include Database name in the alter statement

Hi Team, Is it possible to include the database name in the alter statement? I am trying to automate the process to alter the view/column description using a parameter file which contains view name , column name, column description. I need to inlcude ...

code

Migrate spring boot app from 2.4.4 to 2.6.6 we are getting denodo bean creation issue!

We migrate our application spring boot-2.4.4 to 2.6.6 and below Denodo Bean creation issue facing.. please help me on this issue! <project xmlns="http://maven.apache.org/POM..." xmlns:xsi="http://www.w3.org/2001/XMLS..." xsi:schemalocation="http://...

code

IO Error: Invalid number format for port number

Welcome everyone I'm trying to connect to JDBC, but I'm running into a problem (IO error: Invalid number format for port number) i need help, Thanks

code

TEXT to DATE conversion questions

I am using Denodo 8.0 and have two different date conversion questions. First scenario I have a “date” field that is defined as a TEXT type on the source file. The format is dd-MMM-yy. I want it to be a localdate type (yyyy-MM-dd) I am trying to conv...

code

LIMIT not working in a subquery .

I'm trying to execute the following query : SELECT * FROM (SELECT * FROM Connections LIMIT 1000) AS T LIMIT 1; But its giving the following error : Exception parsing query near 'LIMIT' . Can someone help ? OR suggest any alternative working way of ...

code

Garbage Collector

How do I identify logs for Garbage collector? Where is the Garbage collector located? When does it run? What log file has the information on the Start and Stop time?

code

datamasking

we have snowflake db and we have table masked and unmaksed data based on the role. can we use denodo to display the data depending on the snowflake role's

code

Excel text field is defined as double in base view

I am using Denodo 8.0. I have an Excel spreadsheet data source which contains multiple worksheets. I have created the data source for each worksheet. All of the data columns are defined as General or Text on the Excel spreadsheet. But when I create the...

code

Scheduler Job execution Details

SQL server procedures are loading data to a CSV file. Need to implement this solution using Denodo and send the status of the job execution as view output. We are able to export the view output in a CSV file using Denodo scheduler jobs. Is there...

code

Denodo SSO SAML with Azure AD failing when connection to VDP

I tried setting up Azure SAML SSO in denodo solution manager, I could login to Solution Manager using SSO.From Solution manager, while I tried to connect design studio in preprod /prod environment, It gives me below errors. I tried assigning different ...