Latest Activity

code

Denodo 7.0 compatibility with vertica 10 version?

Hi Team, We are using Denodo 7 version which is connectinf with vertica 9 version. Now vertica application need to be updated to latest version i.e 10. We are concern about whether denodo 7 supports vertica 10 connectivity. In the default jdbc adapter...

code

Denodo 7.0 upgrade to Denodo version 8.0

Hi Team, Planning to upgrade the denodo 7.0 to denodo 8.0. Before upgrading we are concern about the impact of this upgradation. We are using two nodes of Denodo instance without load balancing feature. Please guide me what are the different points we...

code

Denodo 7.0 supports MySQL innoDB cluser 5.7?

Hi Team, The underlying Mysql is going to upgrade to EE innoDB 5.7 version. I am concerned about whether Denodo 7.0 supporets this architecture or not. We can connect with Mysql right now but really concern about the comapatibility of Denodo for innoD...

code

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...

code

how to create a base view using .tsv.gz file from S3 bucket.

we are trieng to add base views from s3 bucket. but files are in tsv.gz format. Kindly assist with procedure to access this files. having read access for the same.

code

Import file excel into bv

Hello I have a file excel present on the same machine where denodo is installed. I need to import it to be able to query it via denodo. I tried to create a new excel datasource via FTP / SFTP / FTPS Path but I don't risk it as it doesn't recognize the ...

code

How to isolate denodo from unexpected source environment updates

Hi, Is there any advice on how to isolate denodo from source environment updates that are unwanted/unexpected cascading into denodo base views? We have implemented our views with the branch pruning approach so cascaded changes should be minimised but w...

code

dynamically create derived views based on list of multiple base views

Is there a way to take a list of specifc base views (based on say a certain prefix and create a derived view with a similar name (dv versus bv, etc.) I have a list of like twenty base views and looking for way to generate the derived views automatical...

code

VQL Query Shows a Long Time Spent in Data Serialization

Hello! We are using Denodo 7.0.20200310 and SQL Server 2017. We have a simple SELECT statement joining 2 base views that runs slowly in our test environment (52 seconds) and fast in our QA environment (<1 second). In looking at the trace information...

code

How to avoid array data conversion into text format while creating base view?

I have created a data source connection with another denodo data base. That data base has view in which data are present in array form. On creating a base view from that view, the array data get converted into text form automatically. Could you tell me...