Latest Activity

code

LIST DATASOURCES

Hi Guysi am struck with getting List all datasources for Excel dataSourceType i am using this LIST DATASOURCES Excel ON scholar; query it is not working can any one help me on this

code

A subquery is not delegated to the source and facing a timeout

In this, the subquery is not delegated to the source because it is executed from dual(). when we execute this full query, it is loading more than 2ml records first (Reason for query timeout) and then it applies the subquery logic in where conditi...

code

Passing case statement as subquery in select statement.

We are automating function to get prior two business days excluding weekends using below logic : select * from dw_vdb.cib360_bv_daily where as_of_date in (select case getdayofweek(current_date) when 3 then addday(current_date, -4) when 2 then addday(c...

code

I am integrating denodo view with Spring DATA JPA and facing unrecognized ssl connection error.

(http://)com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@987ff5 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed a...

code

Modifying the Scheduler export .

Hi , I have an export of DENODO scheduler of DEV environment ,When I promote it to higher environment like ST or UAT I want to modify the name of denodo Data source that I have created as per the respective environment . E.G - if in DEV I have - se...

code

Preserve View Comments

I have noticed when creating a view any comments inserted are stripped out. I can't understand why stripping out comments would be a feature as comments are an extremely important part of development. Is there a way to preserve the comments like there ...

code

Connecting from Microsoft PowerBi

Hi Team, Quick question, I've just downloaded and installed MS PowerBI on one of my VM's, however, am struggling to figure how can I connect it with Denodo. If I go to PowerBI then > Get Data > Database - in the dropdown list Denodo doesn't sh...

code

denodo-v80-update-202107152200.jar fails command line update

./jre/bin/java /opt/denodo/updates-for-denodo-20210715/denodo-v80-update-202107152200.jar "/opt/denodo/denodo_platform_8_0" -c Error: Could not find or load main class .opt.denodo.updates-for-denodo-20210715.denodo-v80-update-202107152200.jar Caused b...

code

Create base view from sql query - Oracle

Hey, I'm trying to create a base view from a sql query where one of the fields in the oracle table has the name SERIAL#. I can import the table if I remove this field, but I need this field! How should i put the field in the select: select sid, SERIAL...

code

Web Service Data Source: error building classes

I am trying to create a Web Service Data Source from Denodo Design Studio. I have proper WSDL and authentication (they work in Postman and Oracle PL/SQL code). When I try to "Create a Base View" the "Loading" gif spins for 2-3 minutes, then I get an er...