Latest Activity


Text to decimal with Impala as source in Denodo

Hi, Im currently facing conversion challenge while using Impala as the source for denodo, while converting text to decimal. In teradata we are successfully using to_number for this conversion , but the same approach doesnt working with impala in denod...

Teradata Query Banding datatype Text to decimal Data Type Conversion DataSource


List of All DataSource

Hi team, I am using Denodo 8.0 version where I want to see details of all the DataSource created in my server.For which I tried this option 'DESC DATASOURCE <datasource_type> <datasource_name>‘, but in this I have to give one datasource na...



Read timed out when configuring HTTPS proxy in denodo data source

Hello, I am trying to configure HTTPS proxy with authorization for the Denodo data sources in the Server Configuration panel

proxy Denodo vdp jdbc driver DataSource


Connecting to Denodo

How do I connect to Denodo from diferent sources ? e.g Extracting Denodo Data from Excel, SQL Server, DBP, power bi, tableau and other consumers

Denodo Excel Add-In sql server DataSource


REST Webservice as DataSource with optional parameters

I am using a REST Webservice as a Datasource. To get the data, the Webservice GET function takes three Parameters "accountingClientId", "customerId" and "invoiceId". The first two are mandatory, the third is optional. I managed to do this by using ^Exe...

REST Parameter REST Webservice JSON Datasource DataSource


excel data source

Is there any way to create a excel data source of the file stored in the local system of the user not in the local system of virtual dataport server? or is there any way to move the file from local system to local system of virtual dataport server?

Excel DataSource


GET_JDBC_DATASOURCE_TABLES equivalent to get Stored Procedures

We automated our base view creation from a SQL Server using Denodo GET_JDBC_DATASOURCETABLES stored procedure. Unfortunatly, this process ignores the few SQL Server custom stored procedures that we would also like to import in Denodo. Is there a way ar...

Stored Procedures DataSource


Getting Source Tables and Columns of a Datasource through Query

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

JDBC query Database JDBC DataSource


Getting the Source Tables and columns for non-JDBC datasources

Hi Denodo Team, For the views created from JDBC datasource in denodo I am able to get the source tables by using the default procedure GET_SOURCE_TABLES(). But when I use the same procedure to get the underlying source table information for the datasou...

source tables SAP CSV Denodo8 JDBC Data Sources source columns DataSource underlying tables


How to delegate full join to Dremio source

Hi Team, I have 2 views which from same Dremio datasource. and these 2 views is FULL OUTER Join. But the full out join can't delegate to dremio. could you please help this case? Test1, inner join can deletgate, but outer join not; Test2, change the so...

VDP 7.0 DataSource