Latest Activity

code

File system URI as an interpolation variable for DFSListfile wrapper?

Hi Team, I am working on denodo 8.0 I can read the file names from Azure blob storage using com.denodo.connect.dfs.wrapper.DFSListFilesWrapper and specifying File system URI value. I want to make this connection a variable so that i can declare it ou...

code

Custom function

Hi Team, I would like yo use the function, Leftpad and rightpad. Could you please help to how i can use in VPD. I tried but ended up with the error 'Finished with error: Function 'leftpad' with arity 2 not found'.

code

Error accessing the metadata while loading/storing objects

I have created a job in the scheduler for loading the oracle transcodification tables and while executing I am getting error as "Error accessing the metadata while loading/storing objects". Please help on this.

code

How to create a cache over a JSON data source which is has around 66GB data (paginated)

HI Team, We have a JSON data source which has huge number of records( nearly 170 million), is there any way to cache the same, without getting JVM heap space issue. Kindly advise. Awaiting for your response ASAP

code

to get the count of all view in single qurey

Hi team, Is any possible way to get the count of records from the views in one folder, without implementing store procedures. Thank you

code

MS Access DB --- directly connect to a file on File Server

We have an access DB that is accessible via our File Server and a network location. I am trying to figure out what custom wrapper or jar file is required to get this to working. This is for MS Access 365. I have read through many of the community en...

code

Unable to establish Connection: JDBC Driver not found

Hello Team , Am trying to create a JDBC Data source in denodo design studio, in denodo community they have mentoned to add jdbc driver in this path File>Extention Management>Libraries ,however when i navigated to the path ,there is no such tab a...

code

Custom Script

How can i achieve this.. I am having couple of tables T1 with column C1, C2, and C3 T2 with column D1, D2, and D3 I need to look into a table T1 based on where condition (where C1 = 'ABC') and check if column C3 having value. - If so i need to pick...

code

How to configure data catalog as a separate instance?

Hi Team, Is it possible to run data catalog as a seperate instance on different VM than VDP server? I could not find where in data catalog we should be configuring the VDP server addess. By default the Data catalog looks for VDP server on localhost, w...

code

Dynamic unpivoting

Hi Team, I am working on Denodo 8.0 and need your suggestion with dynamic unpivoting. Whats the best way to handle this unpivoting dynamically scenario? The IDs and date range can change. There can be various IDs in the rows and Dates in the column...