Latest Activity

code

desc datasource meta info

Hello , I am trying to get the metadata information using desc datasource command. While I am running desc datasource jdbc "source_name" in VQL Shell, we could see the full output. Whereas if we are creating view using the same command and using the...

code

How Can I implement SSO in Power BI or Tableau to connect to Denodo?

We want our users to connect to Denodo in applications like PowerBI, Tableau, Qlik, DBeaver using SSO so that they don't need to provide their credentials everytime while connecting to the views in Denodo. Any suggestions or inputs on how to implement...

code

rownum to reset the generated sequence after a certain number

We need to generate a sequence and then reset the counter after 100. We are able to use rownum function to generate the sequence but it doesn't reset after a certain number. How can we achieve this?

code

Data Movement to DataBricks via JDBC connection

Is there a JDBC driver available for connecting to Databricks (Azure) which enables data movement to Databricks?

code

Installing Denodo Express

I am attempting to install Denodo Express 8.0 on a Linux CentOS VM in Azure but get the following message when attempting to start the installation process using install.sh. Can anyone advise please? Exception in thread "main" java.awt.AWTError: Can't...

code

the solution manager environment, cluster, and server ID details

how to find or get the file location which is having following details in the solution manager : environment, cluster, and server ID details in the solution manager?

code

I need to force index in a integration view with out edit base view from query

Hi, can us help me with that? i want to know if is possible to "force use index" in a oracle sql db by a integration view. /+ INDEX(bd.table IDX_EXAMPLE) / Thanks,

code

Conversion Error Timestamp -> Text with HIVE

Hi, I want to create a Selection View over a HIVE data source and encountered an error within the WHERE condition that I fail to solve. Users should be able to enter a date range using the fields "from_timestamp" and "to_timestamp" of type "timestamp"...

code

How to find Invalid views using VQL or Query

I want to find the invalid views using vql or query . This is really important as when import happens to higher environement using solution manager it really doesnt show the errored view and need to manually check all the views which is very tedious. ...

code

odata 2 Custom datasource error

Team, I am trying to create a datasource to connect to dataverse api using odata2-wrapper and create a base view following below document. https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Microsoft%20Dynamics%20365%20from%20D...