Latest Activity

code

Connecting to Denodo via PyCharm

Hi there, Is there a way to add Denodo as a data source in PyCharm? The website has this information: https://www.jetbrains.com/help/pycharm/managing-data-sources.html#show-comments-for-data-sources-and-database-objects But Denodo isn't listed as a ...

code

Denodo 8.0 Express - Extensions

I need test some custom function and did compile the sample function to jar. However, when I try to add it to Denodo. I don't see extension tab on extension management. I only see "Libraries" tab. File -> Extension Management -> (Only Libraries ...

code

WEBCONTAINER_ELEMENT_STATUS() "modified" column

I need a more detailed explanation of what WEBCONTAINER_ELEMENT_STATUS() "modified" column means. I tried to attach images of the stored procedure run and the VDP webservice status. This applies for all webservices. in the return from the stored proced...

code

JBOSS TO DENODO

Can you pls throw some light and possible ways/process to do easy migration from JBOSS to Denodo?

code

Error While Saving Derived View "Error saving view: Syntax error: Exception parsing query near 'WITH'"

Hi, I am creating a derived view over top a base view generated from a postgres table (10.x). I can configure a view parameter and add it in the where clause, but it will not let me save the view due to the error "Error saving view: Syntax error: Exce...

code

Is Denodo TO Azure Data Factory possible?

Is it possible for Azure Data Factory to connect to Denodo after Denodo has materialzed or virtualized a view? If yes, what are the connection details to accomplish that?

code

Databricks utilization for cache

I would like to get better understanding on how the Denodo caching with Azure Databricks + ADLS v2 works. My understanding is that we could also use directly ADLS v2 as a cache, but thanks to its computing power of Databricks, it is enhancing even more...

code

Denodo 8.0 Express - Web Tools not starting

I am trying to test out a couple of connections and I read an article where I had to set up some configuration in the Scheduler Admin Tool. I can start the servers from the express console, however all web tools refuse to start. It doesn't look like co...

code

Cannot setup Databricks as cache

Hi, I am trying to setup Azure Databricks + ADLS as cache. On the Linux server, logged into the docker container runnig Denodo instance, and I installed databricks-cli and configured with token. I can see the directories when executing dbfs ls, which m...

code

Joining 2 files and runs a long time

When I run the below, it runs in 10 seconds. When I uncomment out the join, it runs a long time. The join file only has 1 record on it. Is there a way to get this to run in 10 seconds or so with the join file? Thanks. Neil With V5035_A_GROUP as (selec...