Latest Activity

Creating Base View using Delimited files

Hi Team, I have one requirement: There is one folder on FTP path which contains text files(many text files) having record like Name:Neetu Age:34 Department:IT ContactDetails: Mob:123456 Phone:56778 Address:xyz EducationDetail: HighestQualification:...

Need to extract the second row of a duplicate in a table

Hi Folks! I have a scenario where I have a list of customers with a driver number. In some instances, the customer is duplicated because of a second driver being assigned to the customer. Such as this; Customer Driver 101369 5058 101369 5602 How do ...

Using com.denodo.scheduler

Hi, I'm using Denodo 7.0 update 20200803 and attempting to use the scheduler api via Python/Jpype. Is there a particular jar file I need for the Scheduler? The code below is my attempt. import jpype import jpype.imports from jpype.types import * jp...

Connecting to data lake gen2 with a free trial

Would like to download The Distributed File System Custom Wrapper to connect to a data lake store gen2 in Azure. I cannot download the file from support.denodo.com as I have a trial license only. How can I get the wrapper, my trial is running out, so ...

Losing connectivity for Denodo user

When I provision the Denodo AMI as an EC2 instance, I follow the directions to get it going and everything is fine. However, if I stop that instance (e.g. working on something else for a while) and then restart it, all of a sudden the Denodo user can'...

Fetching View's underlying query

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Full Caching mode

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.

Caching issue while sending data to MYSQL workbench.

Hello, I have a problem with caching the data I got an error : Finished with error: Error loading cache: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Loading local data is disabled; this must be enabled on both the client and server sid...

Use Denodo Web Service as a Data Source in Denodo

Hi, Is it possible to creat a Data source on a Denodo REST web service ? We have a requirement where we want the Denodo Web service to be utilized as a Data Source .

Time zone differences and daylight savings

I need to account for Daylight Saving Time with the data I am processing. One of the rows has a date time of '01-Nov-2009 01:59:00'. When I set the Locale value to us_cst: English (United States) via the Denodo Administration/Admin Tools Preferences op...